PREVIEW / etf_30min / 2021-05-24

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-05-24.parquet
  size:    596 KB
  rows:    23,209

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-05-24 04:00:00	SPY	ETF	415.9	416.99	415.9	416.73	32870.0
2021-05-24 04:30:00	SPY	ETF	416.35	416.6	416.35	416.51	5153.0
2021-05-24 05:00:00	SPY	ETF	416.45	416.91	416.39	416.78	6900.0
2021-05-24 05:30:00	SPY	ETF	416.78	417.04	416.7	416.96	17667.0
2021-05-24 06:00:00	SPY	ETF	417.06	417.06	416.94	416.96	31242.0
2021-05-24 06:30:00	SPY	ETF	416.96	416.97	416.81	416.97	62384.0
2021-05-24 07:00:00	SPY	ETF	416.88	416.97	416.67	416.68	63041.0
2021-05-24 07:30:00	SPY	ETF	416.67	416.88	416.57	416.83	25700.0
2021-05-24 08:00:00	SPY	ETF	416.74	417.04	416.26	416.96	185621.0
2021-05-24 08:30:00	SPY	ETF	416.95	417.27	416.95	417.21	106786.0
2021-05-24 09:00:00	SPY	ETF	417.22	417.41	417.14	417.37	224259.0
2021-05-24 09:30:00	SPY	ETF	417.34	418.21	417.08	418.21	5082357.0
2021-05-24 10:00:00	SPY	ETF	418.2	419.295	418.2	419.02	4385241.0
2021-05-24 10:30:00	SPY	ETF	419.02	419.5	418.99	419.3	2671228.0
2021-05-24 11:00:00	SPY	ETF	419.3	419.59	419.09	419.5481	1672557.0
2021-05-24 11:30:00	SPY	ETF	419.545	419.68	419.21	419.23	1530845.0
2021-05-24 12:00:00	SPY	ETF	419.225	419.4485	418.91	418.97	1522706.0
2021-05-24 12:30:00	SPY	ETF	418.98	419.36	418.9714	419.2819	1239436.0
2021-05-24 13:00:00	SPY	ETF	419.29	419.63	419.14	419.625	1210664.0
2021-05-24 13:30:00	SPY	ETF	419.63	419.84	419.59	419.7481	1322785.0
2021-05-24 14:00:00	SPY	ETF	419.75	420.18	419.74	420.05	2202761.0
2021-05-24 14:30:00	SPY	ETF	420.0519	420.32	420.01	420.0519	2070980.0
2021-05-24 15:00:00	SPY	ETF	420.055	420.28	419.86	419.945	3225373.0
2021-05-24 15:30:00	SPY	ETF	419.95	419.99	418.94	419.13	9680456.0
2021-05-24 16:00:00	SPY	ETF	419.13	419.46	419.06	419.44	2470859.0
2021-05-24 16:30:00	SPY	ETF	419.45	419.62	419.17	419.57	203623.0
2021-05-24 17:00:00	SPY	ETF	419.58	419.58	419.47	419.47	16731.0
2021-05-24 17:30:00	SPY	ETF	419.47	419.59	419.43	419.58	27737.0
2021-05-24 18:00:00	SPY	ETF	419.58	419.74	419.36	419.71	27657.0
2021-05-24 18:30:00	SPY	ETF	419.17	419.95	419.17	419.9	35136.0
2021-05-24 19:00:00	SPY	ETF	419.92	420.0	419.73	419.76	36985.0
2021-05-24 19:30:00	SPY	ETF	419.81	419.98	419.68	419.81	22756.0
2021-05-24 04:00:00	QQQ	ETF	328.74	328.74	328.45	328.5	21688.0
2021-05-24 04:30:00	QQQ	ETF	328.5	328.5	328.21	328.37	19241.0
2021-05-24 05:00:00	QQQ	ETF	328.29	328.84	328.29	328.73	23777.0
2021-05-24 05:30:00	QQQ	ETF	328.67	329.1	328.64	329.0	7350.0
2021-05-24 06:00:00	QQQ	ETF	329.04	329.1	328.9	328.99	29754.0
2021-05-24 06:30:00	QQQ	ETF	328.84	329.02	328.8	328.97	26863.0
2021-05-24 07:00:00	QQQ	ETF	328.96	329.01	328.62	328.68	41184.0
2021-05-24 07:30:00	QQQ	ETF	328.7	329.11	328.66	329.05	66228.0
2021-05-24 08:00:00	QQQ	ETF	329.07	329.47	327.15	329.35	139097.0
2021-05-24 08:30:00	QQQ	ETF	329.39	329.6	329.34	329.34	108676.0
2021-05-24 09:00:00	QQQ	ETF	329.45	329.66	329.25	329.39	197625.0
2021-05-24 09:30:00	QQQ	ETF	329.37	331.17	329.0	331.08	3694564.0
2021-05-24 10:00:00	QQQ	ETF	331.08	332.52	331.08	332.3982	2438597.0
2021-05-24 10:30:00	QQQ	ETF	332.41	332.77	332.26	332.48	1761050.0
2021-05-24 11:00:00	QQQ	ETF	332.48	332.91	332.33	332.65	1268619.0
2021-05-24 11:30:00	QQQ	ETF	332.675	333.01	332.6	332.81	1027206.0
2021-05-24 12:00:00	QQQ	ETF	332.81	333.12	332.41	332.51	1150216.0
2021-05-24 12:30:00	QQQ	ETF	332.53	332.69	332.3	332.52	932593.0

> showing 50 of 23,209 rows — these rows as CSV

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