PREVIEW / etf_1hour / 2021-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-01.parquet
  size:    430 KB
  rows:    15,000

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.46	384.92	116223.0
2021-03-01 05:00:00	SPY	ETF	384.95	385.2	384.77	384.84	139536.0
2021-03-01 06:00:00	SPY	ETF	384.86	384.99	384.06	384.33	114005.0
2021-03-01 07:00:00	SPY	ETF	384.28	384.83	384.12	384.63	335702.0
2021-03-01 08:00:00	SPY	ETF	384.5099	385.06	380.36	384.93	1277495.0
2021-03-01 09:00:00	SPY	ETF	384.91	387.04	384.5	386.93	14030580.0
2021-03-01 10:00:00	SPY	ETF	386.94	389.14	386.47	388.99	14988191.0
2021-03-01 11:00:00	SPY	ETF	388.99	389.5	388.4	389.37	9141175.0
2021-03-01 12:00:00	SPY	ETF	389.38	389.68	388.76	388.91	5629271.0
2021-03-01 13:00:00	SPY	ETF	388.93	389.675	388.25	389.51	5748382.0
2021-03-01 14:00:00	SPY	ETF	389.5119	390.92	389.2	390.52	6565018.0
2021-03-01 15:00:00	SPY	ETF	390.53	390.73	389.0	389.52	20077454.0
2021-03-01 16:00:00	SPY	ETF	389.51	390.22	389.1	390.03	4587547.0
2021-03-01 17:00:00	SPY	ETF	389.9	390.05	389.9	390.05	88443.0
2021-03-01 18:00:00	SPY	ETF	390.07	390.34	389.58	390.14	108652.0
2021-03-01 19:00:00	SPY	ETF	390.05	390.29	389.84	390.08	110002.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.76	319.24	110421.0
2021-03-01 05:00:00	QQQ	ETF	319.24	319.92	319.1	319.28	84477.0
2021-03-01 06:00:00	QQQ	ETF	319.29	319.33	318.16	318.52	189235.0
2021-03-01 07:00:00	QQQ	ETF	318.48	318.89	318.03	318.52	268703.0
2021-03-01 08:00:00	QQQ	ETF	318.49	320.0	317.81	318.69	1215827.0
2021-03-01 09:00:00	QQQ	ETF	318.8	319.73	317.935	319.3981	7538846.0
2021-03-01 10:00:00	QQQ	ETF	319.42	321.59	318.68	321.3	7673706.0
2021-03-01 11:00:00	QQQ	ETF	321.31	322.52	321.065	322.31	4781433.0
2021-03-01 12:00:00	QQQ	ETF	322.32	322.5	321.57	321.8999	2964351.0
2021-03-01 13:00:00	QQQ	ETF	321.93	322.3	321.27	321.9918	2573092.0
2021-03-01 14:00:00	QQQ	ETF	322.01	323.76	321.87	323.55	3191389.0
2021-03-01 15:00:00	QQQ	ETF	323.55	323.94	322.85	323.6	6654242.0
2021-03-01 16:00:00	QQQ	ETF	323.61	324.67	323.21	324.56	1472441.0
2021-03-01 17:00:00	QQQ	ETF	324.34	324.6	324.32	324.46	48501.0
2021-03-01 18:00:00	QQQ	ETF	324.5	324.85	324.36	324.59	94756.0
2021-03-01 19:00:00	QQQ	ETF	324.61	324.81	324.44	324.74	65856.0
2021-03-01 04:00:00	IWM	ETF	223.5	223.8	223.24	223.6	27970.0
2021-03-01 05:00:00	IWM	ETF	223.37	223.83	223.34	223.39	16101.0
2021-03-01 06:00:00	IWM	ETF	223.28	223.36	222.8	223.0	90477.0
2021-03-01 07:00:00	IWM	ETF	222.99	222.99	222.33	222.75	85503.0
2021-03-01 08:00:00	IWM	ETF	222.7399	223.64	218.31	222.79	144393.0
2021-03-01 09:00:00	IWM	ETF	222.74	224.42	222.42	223.31	5162183.0
2021-03-01 10:00:00	IWM	ETF	223.37	224.9	222.96	224.83	3049012.0
2021-03-01 11:00:00	IWM	ETF	224.85	225.46	224.5	225.32	1925422.0
2021-03-01 12:00:00	IWM	ETF	225.31	225.87	224.85	225.158	1251030.0
2021-03-01 13:00:00	IWM	ETF	225.2	226.1388	224.48	225.7952	1450264.0
2021-03-01 14:00:00	IWM	ETF	225.83	226.71	225.658	226.44	1469070.0
2021-03-01 15:00:00	IWM	ETF	226.45	226.67	225.75	226.13	4343545.0
2021-03-01 16:00:00	IWM	ETF	226.13	226.73	225.9	226.55	1259731.0
2021-03-01 17:00:00	IWM	ETF	226.42	226.7	226.42	226.7	10337.0
2021-03-01 18:00:00	IWM	ETF	226.7	226.79	226.42	226.5	13793.0
2021-03-01 19:00:00	IWM	ETF	226.4	226.62	226.34	226.48	16869.0
2021-03-01 04:00:00	DIA	ETF	312.89	313.05	312.71	312.71	1100.0

> showing 50 of 15,000 rows — these rows as CSV

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