PREVIEW / etf_30min / 2022-07-28

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-28.parquet
  size:    662 KB
  rows:    26,271

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-07-28 04:00:00	SPY	ETF	401.04	401.04	399.84	399.94	40929.0
2022-07-28 04:30:00	SPY	ETF	399.9	399.97	399.5	399.61	14001.0
2022-07-28 05:00:00	SPY	ETF	399.72	399.72	399.19	399.34	51190.0
2022-07-28 05:30:00	SPY	ETF	399.32	399.93	399.29	399.9	22074.0
2022-07-28 06:00:00	SPY	ETF	399.94	400.09	399.72	400.09	15142.0
2022-07-28 06:30:00	SPY	ETF	400.1	400.24	399.84	400.0	23603.0
2022-07-28 07:00:00	SPY	ETF	399.99	400.36	399.99	400.27	54329.0
2022-07-28 07:30:00	SPY	ETF	400.19	400.26	400.02	400.1	112592.0
2022-07-28 08:00:00	SPY	ETF	400.21	400.78	399.3204	399.98	137819.0
2022-07-28 08:30:00	SPY	ETF	400.12	401.65	399.06	400.81	1098492.0
2022-07-28 09:00:00	SPY	ETF	400.83	402.08	400.5	401.86	305775.0
2022-07-28 09:30:00	SPY	ETF	401.89	402.77	398.33	399.34	6841044.0
2022-07-28 10:00:00	SPY	ETF	399.38	400.01	398.15	398.75	4401668.0
2022-07-28 10:30:00	SPY	ETF	398.76	401.6	398.35	401.56	4339095.0
2022-07-28 11:00:00	SPY	ETF	401.57	403.87	401.42	403.86	4240516.0
2022-07-28 11:30:00	SPY	ETF	403.85	404.49	403.14	403.65	3843070.0
2022-07-28 12:00:00	SPY	ETF	403.65	404.35	403.33	404.24	2071807.0
2022-07-28 12:30:00	SPY	ETF	404.25	404.42	403.62	404.0776	1563668.0
2022-07-28 13:00:00	SPY	ETF	404.07	405.1	403.61	405.0507	2110060.0
2022-07-28 13:30:00	SPY	ETF	405.06	406.42	404.98	406.15	3351497.0
2022-07-28 14:00:00	SPY	ETF	406.16	406.19	405.39	405.822	3218405.0
2022-07-28 14:30:00	SPY	ETF	405.83	406.32	405.585	406.2	2512512.0
2022-07-28 15:00:00	SPY	ETF	406.22	406.8	405.82	406.465	2959271.0
2022-07-28 15:30:00	SPY	ETF	406.4658	406.4736	405.52	406.01	8354328.0
2022-07-28 16:00:00	SPY	ETF	406.01	407.49	405.93	407.2	3691321.0
2022-07-28 16:30:00	SPY	ETF	407.17	409.72	406.49	409.21	805109.0
2022-07-28 17:00:00	SPY	ETF	409.13	409.45	408.97	408.97	152560.0
2022-07-28 17:30:00	SPY	ETF	408.97	409.29	408.85	409.11	75597.0
2022-07-28 18:00:00	SPY	ETF	409.1	409.1	408.21	408.5	95165.0
2022-07-28 18:30:00	SPY	ETF	408.55	408.56	408.0	408.14	39560.0
2022-07-28 19:00:00	SPY	ETF	408.19	408.26	407.85	408.24	15742.0
2022-07-28 19:30:00	SPY	ETF	408.2	408.35	408.11	408.31	28724.0
2022-07-28 04:00:00	QQQ	ETF	305.6	305.6	304.22	304.4	45060.0
2022-07-28 04:30:00	QQQ	ETF	304.32	304.36	303.95	304.1	28885.0
2022-07-28 05:00:00	QQQ	ETF	304.2	304.2	303.57	303.83	123678.0
2022-07-28 05:30:00	QQQ	ETF	303.85	304.61	303.81	304.53	26374.0
2022-07-28 06:00:00	QQQ	ETF	304.6	304.98	304.44	304.98	45077.0
2022-07-28 06:30:00	QQQ	ETF	304.98	305.06	304.71	304.97	35288.0
2022-07-28 07:00:00	QQQ	ETF	305.0	305.3	305.0	305.16	93336.0
2022-07-28 07:30:00	QQQ	ETF	305.16	305.17	304.79	304.92	192516.0
2022-07-28 08:00:00	QQQ	ETF	305.1	307.04	303.71	304.8	241100.0
2022-07-28 08:30:00	QQQ	ETF	304.85	306.99	303.88	305.9	1364042.0
2022-07-28 09:00:00	QQQ	ETF	305.9	306.8996	305.51	306.61	431495.0
2022-07-28 09:30:00	QQQ	ETF	306.59	307.69	302.87	303.71	7020164.0
2022-07-28 10:00:00	QQQ	ETF	303.75	304.68	302.82	303.35	3740603.0
2022-07-28 10:30:00	QQQ	ETF	303.35	305.87	302.745	305.83	3077795.0
2022-07-28 11:00:00	QQQ	ETF	305.85	308.03	305.76	308.02	3946568.0
2022-07-28 11:30:00	QQQ	ETF	308.02	308.7205	307.45	307.99	3032621.0
2022-07-28 12:00:00	QQQ	ETF	307.99	308.22	307.275	308.099	2147363.0
2022-07-28 12:30:00	QQQ	ETF	308.1	308.34	307.47	307.49	1226592.0

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

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