PREVIEW / etf_30min / 2022-05-11

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-05-11.parquet
  size:    706 KB
  rows:    28,056

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-05-11 04:00:00	SPY	ETF	400.57	402.09	400.53	402.09	16093.0
2022-05-11 04:30:00	SPY	ETF	402.26	403.65	402.21	403.41	20738.0
2022-05-11 05:00:00	SPY	ETF	403.58	403.85	403.22	403.49	40279.0
2022-05-11 05:30:00	SPY	ETF	403.45	403.62	403.32	403.51	17229.0
2022-05-11 06:00:00	SPY	ETF	403.51	403.6	402.76	403.23	53032.0
2022-05-11 06:30:00	SPY	ETF	403.35	403.9	403.35	403.49	89423.0
2022-05-11 07:00:00	SPY	ETF	403.51	403.94	403.37	403.84	98018.0
2022-05-11 07:30:00	SPY	ETF	403.86	404.54	403.6	403.85	227513.0
2022-05-11 08:00:00	SPY	ETF	403.53	404.48	400.0	402.75	703089.0
2022-05-11 08:30:00	SPY	ETF	402.75	402.75	394.33	395.02	3489822.0
2022-05-11 09:00:00	SPY	ETF	395.05	398.4	394.79	398.04	1835288.0
2022-05-11 09:30:00	SPY	ETF	398.05	403.17	395.22	402.26	13664465.0
2022-05-11 10:00:00	SPY	ETF	402.25	403.42	399.6	402.68	9400817.0
2022-05-11 10:30:00	SPY	ETF	402.64	404.04	400.79	401.45	5800578.0
2022-05-11 11:00:00	SPY	ETF	401.44	402.03	399.56	401.91	4773566.0
2022-05-11 11:30:00	SPY	ETF	401.92	403.8	400.84	401.39	4259293.0
2022-05-11 12:00:00	SPY	ETF	401.34	401.68	398.7	398.86	4345290.0
2022-05-11 12:30:00	SPY	ETF	398.84	399.75	396.83	396.98	5599322.0
2022-05-11 13:00:00	SPY	ETF	396.97	397.1	395.47	395.61	6379965.0
2022-05-11 13:30:00	SPY	ETF	395.6	396.4	393.25	393.52	6817943.0
2022-05-11 14:00:00	SPY	ETF	393.51	397.34	393.44	396.0	7223360.0
2022-05-11 14:30:00	SPY	ETF	396.01	398.16	395.17	395.33	6233530.0
2022-05-11 15:00:00	SPY	ETF	395.3	395.75	393.93	394.69	6501850.0
2022-05-11 15:30:00	SPY	ETF	394.69	395.22	391.96	392.77	15638725.0
2022-05-11 16:00:00	SPY	ETF	392.77	394.09	392.3101	393.72	4279717.0
2022-05-11 16:30:00	SPY	ETF	393.7	394.24	392.75	393.79	284569.0
2022-05-11 17:00:00	SPY	ETF	393.91	394.128	393.17	393.25	788853.0
2022-05-11 17:30:00	SPY	ETF	393.29	393.65	393.2	393.5	118690.0
2022-05-11 18:00:00	SPY	ETF	393.59	393.65	392.37	392.65	179718.0
2022-05-11 18:30:00	SPY	ETF	392.64	393.55	392.64	393.55	45436.0
2022-05-11 19:00:00	SPY	ETF	393.6	393.71	393.15	393.19	22763.0
2022-05-11 19:30:00	SPY	ETF	393.16	394.13	393.06	393.85	99068.0
2022-05-11 04:00:00	QQQ	ETF	302.98	303.86	302.25	303.85	94003.0
2022-05-11 04:30:00	QQQ	ETF	303.86	305.0	303.86	304.74	73573.0
2022-05-11 05:00:00	QQQ	ETF	304.71	305.24	304.5	304.75	62164.0
2022-05-11 05:30:00	QQQ	ETF	304.79	305.01	304.62	304.88	60105.0
2022-05-11 06:00:00	QQQ	ETF	304.84	304.93	304.06	304.7	104598.0
2022-05-11 06:30:00	QQQ	ETF	304.77	305.56	304.77	305.21	84941.0
2022-05-11 07:00:00	QQQ	ETF	305.22	305.6	304.89	305.37	227443.0
2022-05-11 07:30:00	QQQ	ETF	305.37	305.86	304.83	305.09	345109.0
2022-05-11 08:00:00	QQQ	ETF	305.14	305.84	300.535	303.5	512424.0
2022-05-11 08:30:00	QQQ	ETF	303.5	303.5	294.92	295.8	5704426.0
2022-05-11 09:00:00	QQQ	ETF	295.78	299.0	295.64	298.41	2271072.0
2022-05-11 09:30:00	QQQ	ETF	298.44	304.09	296.01	301.8598	16388620.0
2022-05-11 10:00:00	QQQ	ETF	301.83	302.91	298.81	301.72	9527901.0
2022-05-11 10:30:00	QQQ	ETF	301.69	302.53	299.18	299.94	6614591.0
2022-05-11 11:00:00	QQQ	ETF	299.93	300.35	297.8	300.2	5114663.0
2022-05-11 11:30:00	QQQ	ETF	300.22	301.98	299.03	299.46	4251070.0
2022-05-11 12:00:00	QQQ	ETF	299.46	299.99	297.33	297.51	4300844.0
2022-05-11 12:30:00	QQQ	ETF	297.46	298.39	295.57	295.8	4921611.0

> showing 50 of 28,056 rows — these rows as CSV

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