PREVIEW / etf_30min / 2021-01-15

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-15.parquet
  size:    626 KB
  rows:    23,506

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-01-15 04:00:00	SPY	ETF	377.4	377.73	377.27	377.39	31834.0
2021-01-15 04:30:00	SPY	ETF	377.48	377.67	377.39	377.44	3967.0
2021-01-15 05:00:00	SPY	ETF	377.5	377.66	377.1	377.42	7111.0
2021-01-15 05:30:00	SPY	ETF	377.56	377.9	377.31	377.31	11667.0
2021-01-15 06:00:00	SPY	ETF	377.25	377.25	376.65	376.97	81373.0
2021-01-15 06:30:00	SPY	ETF	376.93	377.22	376.72	377.18	29652.0
2021-01-15 07:00:00	SPY	ETF	377.17	377.4	376.7	377.31	153633.0
2021-01-15 07:30:00	SPY	ETF	377.35	377.56	376.76	376.97	179288.0
2021-01-15 08:00:00	SPY	ETF	376.8101	377.56	376.65	377.27	150390.0
2021-01-15 08:30:00	SPY	ETF	377.15	377.38	376.6	376.73	461547.0
2021-01-15 09:00:00	SPY	ETF	376.71	377.11	376.31	376.72	558343.0
2021-01-15 09:30:00	SPY	ETF	376.72	377.58	376.64	377.1	6434342.0
2021-01-15 10:00:00	SPY	ETF	377.1	377.32	373.7	374.57	26197028.0
2021-01-15 10:30:00	SPY	ETF	374.59	375.74	374.13	375.31	5414517.0
2021-01-15 11:00:00	SPY	ETF	375.32	376.47	374.3	376.38	5827622.0
2021-01-15 11:30:00	SPY	ETF	376.36	376.92	375.92	376.17	3734274.0
2021-01-15 12:00:00	SPY	ETF	376.18	376.47	375.7	376.2	2064272.0
2021-01-15 12:30:00	SPY	ETF	376.21	376.81	376.091	376.64	1897849.0
2021-01-15 13:00:00	SPY	ETF	376.645	377.29	376.19	376.94	2444595.0
2021-01-15 13:30:00	SPY	ETF	376.94	377.14	376.54	376.76	2586392.0
2021-01-15 14:00:00	SPY	ETF	376.76	377.08	376.31	376.57	3175659.0
2021-01-15 14:30:00	SPY	ETF	376.57	377.17	376.42	376.4768	2521534.0
2021-01-15 15:00:00	SPY	ETF	376.48	377.22	375.98	376.5099	3931017.0
2021-01-15 15:30:00	SPY	ETF	376.5	376.65	375.41	375.68	10612709.0
2021-01-15 16:00:00	SPY	ETF	375.64	375.7	374.2	374.3	20210197.0
2021-01-15 16:30:00	SPY	ETF	374.33	375.7	374.01	374.12	947197.0
2021-01-15 17:00:00	SPY	ETF	374.16	375.7	374.15	374.26	1864614.0
2021-01-15 17:30:00	SPY	ETF	374.24	375.7	374.0	375.14	1667420.0
2021-01-15 18:00:00	SPY	ETF	375.15	375.5	374.7	374.9	122758.0
2021-01-15 18:30:00	SPY	ETF	374.94	374.94	374.7	374.7	48281.0
2021-01-15 19:00:00	SPY	ETF	374.7	374.71	374.55	374.57	10457.0
2021-01-15 19:30:00	SPY	ETF	374.56	374.62	374.5	374.52	26473.0
2021-01-15 04:00:00	QQQ	ETF	314.14	314.33	313.91	313.93	18050.0
2021-01-15 04:30:00	QQQ	ETF	313.96	314.18	313.8	313.8	9611.0
2021-01-15 05:00:00	QQQ	ETF	313.83	313.99	313.59	313.73	3240.0
2021-01-15 05:30:00	QQQ	ETF	313.84	314.22	313.5	313.6	4649.0
2021-01-15 06:00:00	QQQ	ETF	313.7	313.71	313.19	313.34	19450.0
2021-01-15 06:30:00	QQQ	ETF	313.47	313.48	313.23	313.47	12863.0
2021-01-15 07:00:00	QQQ	ETF	313.56	314.15	313.49	314.14	73994.0
2021-01-15 07:30:00	QQQ	ETF	314.13	314.32	313.8	314.22	91599.0
2021-01-15 08:00:00	QQQ	ETF	313.8	314.58	313.06	314.43	136785.0
2021-01-15 08:30:00	QQQ	ETF	314.4	314.56	314.17	314.21	235070.0
2021-01-15 09:00:00	QQQ	ETF	314.11	314.5	313.65	314.03	399306.0
2021-01-15 09:30:00	QQQ	ETF	314.13	315.12	313.89	314.42	2584803.0
2021-01-15 10:00:00	QQQ	ETF	314.43	314.61	310.81	311.73	3705522.0
2021-01-15 10:30:00	QQQ	ETF	311.76	312.84	311.36	312.05	2120540.0
2021-01-15 11:00:00	QQQ	ETF	312.09	313.37	310.58	313.275	2240394.0
2021-01-15 11:30:00	QQQ	ETF	313.25	313.71	312.81	312.86	1514220.0
2021-01-15 12:00:00	QQQ	ETF	312.86	313.25	312.52	312.642	846679.0
2021-01-15 12:30:00	QQQ	ETF	312.64	313.387	312.54	313.14	671108.0

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

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