PREVIEW / etf_30min / 2021-03-01

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-03-01.parquet
  size:    641 KB
  rows:    24,492

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
2021-03-01 04:00:00	SPY	ETF	385.0	385.34	384.72	384.72	87896.0
2021-03-01 04:30:00	SPY	ETF	384.73	385.03	384.46	384.92	28327.0
2021-03-01 05:00:00	SPY	ETF	384.95	385.2	384.77	385.1	113063.0
2021-03-01 05:30:00	SPY	ETF	385.0	385.16	384.84	384.84	26473.0
2021-03-01 06:00:00	SPY	ETF	384.86	384.91	384.25	384.25	37648.0
2021-03-01 06:30:00	SPY	ETF	384.24	384.99	384.06	384.33	76357.0
2021-03-01 07:00:00	SPY	ETF	384.28	384.83	384.12	384.34	260486.0
2021-03-01 07:30:00	SPY	ETF	384.35	384.66	384.18	384.63	75216.0
2021-03-01 08:00:00	SPY	ETF	384.5099	385.06	380.36	384.4	573403.0
2021-03-01 08:30:00	SPY	ETF	384.43	385.05	384.24	384.93	704092.0
2021-03-01 09:00:00	SPY	ETF	384.91	385.59	384.5	385.59	550633.0
2021-03-01 09:30:00	SPY	ETF	385.59	387.04	385.54	386.93	13479947.0
2021-03-01 10:00:00	SPY	ETF	386.94	388.4	386.47	388.03	9742230.0
2021-03-01 10:30:00	SPY	ETF	388.025	389.14	387.93	388.99	5245961.0
2021-03-01 11:00:00	SPY	ETF	388.99	389.4099	388.4	388.82	5494360.0
2021-03-01 11:30:00	SPY	ETF	388.81	389.5	388.72	389.37	3646815.0
2021-03-01 12:00:00	SPY	ETF	389.38	389.68	389.01	389.32	3401417.0
2021-03-01 12:30:00	SPY	ETF	389.3399	389.68	388.76	388.91	2227854.0
2021-03-01 13:00:00	SPY	ETF	388.93	389.06	388.25	389.02	3435081.0
2021-03-01 13:30:00	SPY	ETF	389.02	389.675	389.01	389.51	2313301.0
2021-03-01 14:00:00	SPY	ETF	389.5119	390.48	389.2	390.4188	3872806.0
2021-03-01 14:30:00	SPY	ETF	390.42	390.92	390.29	390.52	2692212.0
2021-03-01 15:00:00	SPY	ETF	390.53	390.73	389.98	390.335	3743985.0
2021-03-01 15:30:00	SPY	ETF	390.34	390.49	389.0	389.52	16333469.0
2021-03-01 16:00:00	SPY	ETF	389.51	390.0	389.1	389.75	4328087.0
2021-03-01 16:30:00	SPY	ETF	389.74	390.22	389.58	390.03	259460.0
2021-03-01 17:00:00	SPY	ETF	389.9	390.05	389.9	390.0	76068.0
2021-03-01 17:30:00	SPY	ETF	389.98	390.05	389.97	390.05	12375.0
2021-03-01 18:00:00	SPY	ETF	390.07	390.34	389.91	390.08	74702.0
2021-03-01 18:30:00	SPY	ETF	389.58	390.3	389.58	390.14	33950.0
2021-03-01 19:00:00	SPY	ETF	390.05	390.29	389.84	390.13	61690.0
2021-03-01 19:30:00	SPY	ETF	390.19	390.22	389.9	390.08	48312.0
2021-03-01 20:00:00	SPY	ETF	389.58	390.05	389.58	390.05	800.0
2021-03-01 04:00:00	QQQ	ETF	319.0	319.91	318.92	318.99	67918.0
2021-03-01 04:30:00	QQQ	ETF	318.94	319.4	318.76	319.24	42503.0
2021-03-01 05:00:00	QQQ	ETF	319.24	319.9	319.1	319.8	50938.0
2021-03-01 05:30:00	QQQ	ETF	319.71	319.92	319.23	319.28	33539.0
2021-03-01 06:00:00	QQQ	ETF	319.29	319.33	318.4	318.59	91966.0
2021-03-01 06:30:00	QQQ	ETF	318.51	319.09	318.16	318.52	97269.0
2021-03-01 07:00:00	QQQ	ETF	318.48	318.89	318.21	318.51	130860.0
2021-03-01 07:30:00	QQQ	ETF	318.45	318.59	318.03	318.52	137843.0
2021-03-01 08:00:00	QQQ	ETF	318.49	320.0	317.99	318.3	1006105.0
2021-03-01 08:30:00	QQQ	ETF	318.3	318.88	317.81	318.69	209722.0
2021-03-01 09:00:00	QQQ	ETF	318.8	319.47	318.4	319.32	337473.0
2021-03-01 09:30:00	QQQ	ETF	319.34	319.73	317.935	319.3981	7201373.0
2021-03-01 10:00:00	QQQ	ETF	319.42	320.56	318.68	320.29	4571474.0
2021-03-01 10:30:00	QQQ	ETF	320.31	321.59	320.035	321.3	3102232.0
2021-03-01 11:00:00	QQQ	ETF	321.31	321.92	321.065	321.4	2290347.0
2021-03-01 11:30:00	QQQ	ETF	321.4	322.52	321.26	322.31	2491086.0
2021-03-01 12:00:00	QQQ	ETF	322.32	322.48	321.6594	322.08	1543241.0

> showing 50 of 24,492 rows — these rows as CSV

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