PREVIEW / etf_30min / 2021-02-23

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-02-23.parquet
  size:    652 KB
  rows:    25,227

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-02-23 04:00:00	SPY	ETF	387.27	387.27	385.62	385.62	51959.0
2021-02-23 04:30:00	SPY	ETF	385.9	386.04	385.29	385.4	39673.0
2021-02-23 05:00:00	SPY	ETF	385.38	385.57	384.36	384.47	60297.0
2021-02-23 05:30:00	SPY	ETF	384.54	384.64	383.69	384.25	53027.0
2021-02-23 06:00:00	SPY	ETF	384.3	384.89	383.79	384.88	131557.0
2021-02-23 06:30:00	SPY	ETF	384.94	385.5	384.85	385.5	75708.0
2021-02-23 07:00:00	SPY	ETF	385.41	385.69	385.21	385.63	276425.0
2021-02-23 07:30:00	SPY	ETF	385.57	385.67	385.02	385.58	347562.0
2021-02-23 08:00:00	SPY	ETF	385.57	389.0	384.0096	385.23	572767.0
2021-02-23 08:30:00	SPY	ETF	385.23	385.4	384.7	385.14	500126.0
2021-02-23 09:00:00	SPY	ETF	385.14	385.15	384.27	384.63	791712.0
2021-02-23 09:30:00	SPY	ETF	384.65	384.73	380.2	382.2394	15482497.0
2021-02-23 10:00:00	SPY	ETF	382.23	384.37	381.43	384.37	9363735.0
2021-02-23 10:30:00	SPY	ETF	384.37	385.71	383.58	385.24	8359700.0
2021-02-23 11:00:00	SPY	ETF	385.245	386.13	384.27	384.73	5341704.0
2021-02-23 11:30:00	SPY	ETF	384.74	385.39	383.79	383.99	4133076.0
2021-02-23 12:00:00	SPY	ETF	383.98	384.34	382.835	384.2	4449158.0
2021-02-23 12:30:00	SPY	ETF	384.18	384.62	382.56	382.7799	3713010.0
2021-02-23 13:00:00	SPY	ETF	382.78	385.2	382.5	385.08	4196621.0
2021-02-23 13:30:00	SPY	ETF	385.0989	385.4699	384.415	385.15	3096385.0
2021-02-23 14:00:00	SPY	ETF	385.14	386.05	384.915	385.865	2956992.0
2021-02-23 14:30:00	SPY	ETF	385.86	386.74	384.735	386.7087	4327154.0
2021-02-23 15:00:00	SPY	ETF	386.73	388.93	386.59	388.85	6315737.0
2021-02-23 15:30:00	SPY	ETF	388.8613	388.945	387.28	387.5	10421110.0
2021-02-23 16:00:00	SPY	ETF	387.51	387.88	387.1	387.2	2839332.0
2021-02-23 16:30:00	SPY	ETF	387.21	387.6537	386.99	387.31	287272.0
2021-02-23 17:00:00	SPY	ETF	387.33	387.5	387.11	387.2	99610.0
2021-02-23 17:30:00	SPY	ETF	387.2	387.4	387.17	387.35	63447.0
2021-02-23 18:00:00	SPY	ETF	387.35	387.6	386.35	386.38	250375.0
2021-02-23 18:30:00	SPY	ETF	387.5	387.55	386.37	387.1	103172.0
2021-02-23 19:00:00	SPY	ETF	387.05	387.5	386.6	386.72	87146.0
2021-02-23 19:30:00	SPY	ETF	386.81	387.24	386.71	387.1	38984.0
2021-02-23 04:00:00	QQQ	ETF	321.5	322.0	319.18	319.28	78240.0
2021-02-23 04:30:00	QQQ	ETF	319.31	319.98	318.93	319.23	54871.0
2021-02-23 05:00:00	QQQ	ETF	319.22	319.36	316.27	316.74	139940.0
2021-02-23 05:30:00	QQQ	ETF	316.74	317.35	315.62	316.43	290742.0
2021-02-23 06:00:00	QQQ	ETF	316.48	317.65	315.86	317.45	267322.0
2021-02-23 06:30:00	QQQ	ETF	317.43	317.79	316.84	317.49	90844.0
2021-02-23 07:00:00	QQQ	ETF	317.49	318.11	317.44	318.03	194602.0
2021-02-23 07:30:00	QQQ	ETF	317.97	318.1	317.2	317.66	225513.0
2021-02-23 08:00:00	QQQ	ETF	317.67	324.95	316.0804	317.0399	475569.0
2021-02-23 08:30:00	QQQ	ETF	316.99	317.54	316.3	317.45	351668.0
2021-02-23 09:00:00	QQQ	ETF	317.45	317.51	316.35	316.96	400975.0
2021-02-23 09:30:00	QQQ	ETF	317.0	317.3397	311.0	314.21	15529440.0
2021-02-23 10:00:00	QQQ	ETF	314.2	317.631	313.64	317.5701	10144379.0
2021-02-23 10:30:00	QQQ	ETF	317.6	319.38	316.43	318.8	6182827.0
2021-02-23 11:00:00	QQQ	ETF	318.79	319.86	317.19	317.68	4233347.0
2021-02-23 11:30:00	QQQ	ETF	317.69	318.54	316.21	316.39	3775945.0
2021-02-23 12:00:00	QQQ	ETF	316.38	317.14	314.86	317.02	4181441.0
2021-02-23 12:30:00	QQQ	ETF	317.01	317.335	314.19	314.55	4850094.0

> showing 50 of 25,227 rows — these rows as CSV

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