PREVIEW / etf_30min / 2021-01-26

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-01-26.parquet
  size:    621 KB
  rows:    23,455

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-26 04:00:00	SPY	ETF	383.65	384.26	383.63	384.1	24894.0
2021-01-26 04:30:00	SPY	ETF	384.2	384.31	383.4	383.56	16551.0
2021-01-26 05:00:00	SPY	ETF	383.6	383.86	383.5	383.81	7599.0
2021-01-26 05:30:00	SPY	ETF	383.76	383.8	383.4	383.7	9819.0
2021-01-26 06:00:00	SPY	ETF	383.73	384.2	383.68	384.07	13918.0
2021-01-26 06:30:00	SPY	ETF	384.15	384.83	383.93	384.44	173857.0
2021-01-26 07:00:00	SPY	ETF	384.39	385.22	384.36	384.73	212312.0
2021-01-26 07:30:00	SPY	ETF	384.82	385.08	384.51	384.93	160536.0
2021-01-26 08:00:00	SPY	ETF	384.5501	385.1496	382.46	384.71	135881.0
2021-01-26 08:30:00	SPY	ETF	384.74	385.08	384.65	385.05	219133.0
2021-01-26 09:00:00	SPY	ETF	385.1	385.46	385.1	385.41	131032.0
2021-01-26 09:30:00	SPY	ETF	385.41	385.85	384.4	384.7316	4083237.0
2021-01-26 10:00:00	SPY	ETF	384.74	385.31	383.8	384.74	3751598.0
2021-01-26 10:30:00	SPY	ETF	384.7429	385.01	384.21	384.43	2002233.0
2021-01-26 11:00:00	SPY	ETF	384.44	384.95	383.89	384.33	1951553.0
2021-01-26 11:30:00	SPY	ETF	384.33	384.39	383.56	383.6391	1684010.0
2021-01-26 12:00:00	SPY	ETF	383.635	384.29	383.6	384.18	1465400.0
2021-01-26 12:30:00	SPY	ETF	384.189	384.28	383.64	384.01	1095387.0
2021-01-26 13:00:00	SPY	ETF	384.02	384.53	383.92	384.41	2309792.0
2021-01-26 13:30:00	SPY	ETF	384.4199	384.83	384.35	384.545	1092481.0
2021-01-26 14:00:00	SPY	ETF	384.5431	384.9	384.12	384.4715	1545680.0
2021-01-26 14:30:00	SPY	ETF	384.4719	384.68	384.17	384.65	1783686.0
2021-01-26 15:00:00	SPY	ETF	384.6362	384.95	384.3736	384.8934	2279195.0
2021-01-26 15:30:00	SPY	ETF	384.895	384.96	383.54	383.83	6671891.0
2021-01-26 16:00:00	SPY	ETF	383.82	384.94	383.69	384.77	3117242.0
2021-01-26 16:30:00	SPY	ETF	384.72	384.75	384.25	384.25	519242.0
2021-01-26 17:00:00	SPY	ETF	384.21	384.4	383.95	384.09	95556.0
2021-01-26 17:30:00	SPY	ETF	384.09	384.1	384.0	384.09	94100.0
2021-01-26 18:00:00	SPY	ETF	384.09	384.83	384.09	384.54	261952.0
2021-01-26 18:30:00	SPY	ETF	383.79	384.61	383.79	384.22	51586.0
2021-01-26 19:00:00	SPY	ETF	384.29	384.39	384.0	384.26	48320.0
2021-01-26 19:30:00	SPY	ETF	384.36	384.36	384.01	384.21	42588.0
2021-01-26 04:00:00	QQQ	ETF	327.59	327.92	327.56	327.7	24235.0
2021-01-26 04:30:00	QQQ	ETF	327.73	327.85	327.16	327.16	15593.0
2021-01-26 05:00:00	QQQ	ETF	327.33	327.54	327.31	327.49	7098.0
2021-01-26 05:30:00	QQQ	ETF	327.46	327.46	327.12	327.43	8193.0
2021-01-26 06:00:00	QQQ	ETF	327.4	327.8	327.4	327.58	11530.0
2021-01-26 06:30:00	QQQ	ETF	327.74	328.43	327.51	328.11	69239.0
2021-01-26 07:00:00	QQQ	ETF	328.07	328.75	328.07	328.44	120820.0
2021-01-26 07:30:00	QQQ	ETF	328.47	328.47	328.13	328.2	91365.0
2021-01-26 08:00:00	QQQ	ETF	328.19	328.66	326.5	328.19	103266.0
2021-01-26 08:30:00	QQQ	ETF	328.22	328.53	328.16	328.44	33775.0
2021-01-26 09:00:00	QQQ	ETF	328.55	328.92	328.53	328.87	203562.0
2021-01-26 09:30:00	QQQ	ETF	328.86	329.23	327.22	328.46	2605790.0
2021-01-26 10:00:00	QQQ	ETF	328.48	329.17	327.56	328.64	2020250.0
2021-01-26 10:30:00	QQQ	ETF	328.6401	329.55	328.52	329.195	1552336.0
2021-01-26 11:00:00	QQQ	ETF	329.22	329.76	328.47	328.532	1737205.0
2021-01-26 11:30:00	QQQ	ETF	328.54	328.8	327.87	327.94	1294834.0
2021-01-26 12:00:00	QQQ	ETF	327.9461	328.857	327.93	328.78	854043.0
2021-01-26 12:30:00	QQQ	ETF	328.78	328.85	328.17	328.47	498746.0

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

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