PREVIEW / etf_30min / 2022-11-29

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-11-29.parquet
  size:    668 KB
  rows:    26,538

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2022-11-29 04:00:00	SPY	ETF	397.75	398.0	397.28	397.28	37893.0
2022-11-29 04:30:00	SPY	ETF	397.43	397.43	396.58	396.83	16144.0
2022-11-29 05:00:00	SPY	ETF	396.88	397.41	396.77	397.26	18391.0
2022-11-29 05:30:00	SPY	ETF	397.31	397.53	397.02	397.02	11848.0
2022-11-29 06:00:00	SPY	ETF	397.07	397.23	396.67	397.07	12537.0
2022-11-29 06:30:00	SPY	ETF	397.1	397.48	396.88	397.48	41547.0
2022-11-29 07:00:00	SPY	ETF	397.46	397.5	397.22	397.24	125607.0
2022-11-29 07:30:00	SPY	ETF	397.26	397.38	396.76	397.38	76140.0
2022-11-29 08:00:00	SPY	ETF	397.36	398.14	396.0	396.46	249788.0
2022-11-29 08:30:00	SPY	ETF	396.46	396.7	395.79	396.36	178700.0
2022-11-29 09:00:00	SPY	ETF	396.3	396.63	395.95	396.04	326674.0
2022-11-29 09:30:00	SPY	ETF	396.05	396.6399	395.24	395.68	4067937.0
2022-11-29 10:00:00	SPY	ETF	395.71	397.03	395.39	397.02	3942284.0
2022-11-29 10:30:00	SPY	ETF	397.02	397.3	396.23	396.33	2934557.0
2022-11-29 11:00:00	SPY	ETF	396.34	396.5189	393.3	393.74	5526577.0
2022-11-29 11:30:00	SPY	ETF	393.73	394.68	393.51	394.6407	2544195.0
2022-11-29 12:00:00	SPY	ETF	394.65	394.72	394.085	394.26	1967898.0
2022-11-29 12:30:00	SPY	ETF	394.27	395.257	394.23	394.957	1946599.0
2022-11-29 13:00:00	SPY	ETF	394.94	395.09	393.98	394.0	1825773.0
2022-11-29 13:30:00	SPY	ETF	394.01	395.07	393.93	395.015	1592575.0
2022-11-29 14:00:00	SPY	ETF	395.02	396.09	394.69	394.755	2979307.0
2022-11-29 14:30:00	SPY	ETF	394.76	394.85	394.191	394.74	2165810.0
2022-11-29 15:00:00	SPY	ETF	394.73	395.3294	394.475	394.94	2640921.0
2022-11-29 15:30:00	SPY	ETF	394.935	395.53	394.79	395.25	4673151.0
2022-11-29 16:00:00	SPY	ETF	395.25	395.4	394.95	395.17	1847045.0
2022-11-29 16:30:00	SPY	ETF	395.17	395.45	395.14	395.43	159624.0
2022-11-29 17:00:00	SPY	ETF	395.43	395.45	395.23	395.38	36493.0
2022-11-29 17:30:00	SPY	ETF	395.35	395.39	395.28	395.3	9558.0
2022-11-29 18:00:00	SPY	ETF	395.35	395.36	395.01	395.03	42423.0
2022-11-29 18:30:00	SPY	ETF	395.04	395.08	394.86	394.96	43365.0
2022-11-29 19:00:00	SPY	ETF	394.98	395.23	394.94	395.11	22625.0
2022-11-29 19:30:00	SPY	ETF	395.2	395.6	395.15	395.52	42649.0
2022-11-29 04:00:00	QQQ	ETF	284.12	284.8	283.86	284.12	59403.0
2022-11-29 04:30:00	QQQ	ETF	284.2	284.2	283.67	283.83	28833.0
2022-11-29 05:00:00	QQQ	ETF	283.86	284.21	283.69	284.1	33161.0
2022-11-29 05:30:00	QQQ	ETF	284.15	284.37	284.08	284.09	18780.0
2022-11-29 06:00:00	QQQ	ETF	284.08	284.25	283.79	284.1	35502.0
2022-11-29 06:30:00	QQQ	ETF	284.13	284.23	283.87	284.19	54420.0
2022-11-29 07:00:00	QQQ	ETF	284.3	284.32	284.071	284.071	149750.0
2022-11-29 07:30:00	QQQ	ETF	284.11	284.24	283.7	284.24	111940.0
2022-11-29 08:00:00	QQQ	ETF	284.17	284.7204	282.922	283.42	382074.0
2022-11-29 08:30:00	QQQ	ETF	283.53	283.63	282.88	283.3	282997.0
2022-11-29 09:00:00	QQQ	ETF	283.27	283.61	282.88	282.9	432406.0
2022-11-29 09:30:00	QQQ	ETF	282.94	283.1	281.58	281.89	3348617.0
2022-11-29 10:00:00	QQQ	ETF	281.91	283.0599	281.49	283.04	2781640.0
2022-11-29 10:30:00	QQQ	ETF	283.04	283.35	282.22	282.2907	1846391.0
2022-11-29 11:00:00	QQQ	ETF	282.32	282.42	279.17	279.78	4487141.0
2022-11-29 11:30:00	QQQ	ETF	279.75	280.66	279.51	280.57	2014123.0
2022-11-29 12:00:00	QQQ	ETF	280.585	280.76	280.19	280.37	1230253.0
2022-11-29 12:30:00	QQQ	ETF	280.39	281.2899	280.3	280.89	1404183.0

> showing 50 of 26,538 rows — these rows as CSV

> unlock the full archive -- $79 one-time