PREVIEW / etf_1hour / 2020-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-03.parquet
  size:    371 KB
  rows:    12,254

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
2020-01-03 04:00:00	SPY	ETF	321.82	321.82	321.14	321.39	47842.0
2020-01-03 05:00:00	SPY	ETF	321.42	321.6	319.69	320.07	70859.0
2020-01-03 06:00:00	SPY	ETF	320.15	320.86	320.06	320.55	185727.0
2020-01-03 07:00:00	SPY	ETF	320.53	321.5	320.45	321.48	808175.0
2020-01-03 08:00:00	SPY	ETF	321.32	322.75	320.5	321.8	963654.0
2020-01-03 09:00:00	SPY	ETF	321.77	322.95	321.06	322.745	10836355.0
2020-01-03 10:00:00	SPY	ETF	322.61	323.1	322.03	322.5	10582433.0
2020-01-03 11:00:00	SPY	ETF	322.5	323.23	322.12	323.1378	4903419.0
2020-01-03 12:00:00	SPY	ETF	323.14	323.64	323.12	323.415	4968100.0
2020-01-03 13:00:00	SPY	ETF	323.42	323.55	322.32	322.94	7696600.0
2020-01-03 14:00:00	SPY	ETF	322.94	323.31	322.57	323.25	4501063.0
2020-01-03 15:00:00	SPY	ETF	323.25	323.55	322.42	322.44	15808536.0
2020-01-03 16:00:00	SPY	ETF	322.44	324.8065	322.38	322.57	11713761.0
2020-01-03 17:00:00	SPY	ETF	322.57	322.69	322.41	322.66	2066844.0
2020-01-03 18:00:00	SPY	ETF	322.66	322.83	322.61	322.65	43145.0
2020-01-03 19:00:00	SPY	ETF	322.69	322.8	322.55	322.65	28989.0
2020-01-03 04:00:00	QQQ	ETF	213.87	213.88	213.1	213.41	95235.0
2020-01-03 05:00:00	QQQ	ETF	213.41	213.59	212.44	212.63	99651.0
2020-01-03 06:00:00	QQQ	ETF	212.65	213.11	212.6	212.97	107035.0
2020-01-03 07:00:00	QQQ	ETF	212.96	213.64	212.91	213.46	283414.0
2020-01-03 08:00:00	QQQ	ETF	213.42	214.67	212.96	213.78	611182.0
2020-01-03 09:00:00	QQQ	ETF	213.78	214.95	213.21	214.61	4391200.0
2020-01-03 10:00:00	QQQ	ETF	214.57	214.88	214.1	214.4265	3673220.0
2020-01-03 11:00:00	QQQ	ETF	214.44	214.89	214.1154	214.81	1711958.0
2020-01-03 12:00:00	QQQ	ETF	214.81	215.47	214.8	215.2699	2040277.0
2020-01-03 13:00:00	QQQ	ETF	215.27	215.336	214.35	214.8053	2693666.0
2020-01-03 14:00:00	QQQ	ETF	214.8	215.01	214.505	214.95	1810386.0
2020-01-03 15:00:00	QQQ	ETF	214.95	215.16	214.17	214.2	4500501.0
2020-01-03 16:00:00	QQQ	ETF	214.17	215.1	214.09	214.22	690457.0
2020-01-03 17:00:00	QQQ	ETF	214.25	214.29	214.18	214.28	316817.0
2020-01-03 18:00:00	QQQ	ETF	214.34	214.4	214.28	214.31	5158.0
2020-01-03 19:00:00	QQQ	ETF	214.35	214.35	214.18	214.18	6606.0
2020-01-03 04:00:00	IWM	ETF	163.83	163.85	163.43	163.49	12616.0
2020-01-03 05:00:00	IWM	ETF	163.64	163.67	162.87	162.87	7878.0
2020-01-03 06:00:00	IWM	ETF	162.97	163.27	162.91	163.2	24000.0
2020-01-03 07:00:00	IWM	ETF	163.15	163.84	163.15	163.84	81775.0
2020-01-03 08:00:00	IWM	ETF	163.75	164.17	163.27	163.97	112033.0
2020-01-03 09:00:00	IWM	ETF	163.99	165.78	163.7	164.48	2282651.0
2020-01-03 10:00:00	IWM	ETF	164.45	164.87	164.04	164.51	2638591.0
2020-01-03 11:00:00	IWM	ETF	164.518	165.01	164.43	164.825	1392258.0
2020-01-03 12:00:00	IWM	ETF	164.83	165.41	164.83	165.26	875692.0
2020-01-03 13:00:00	IWM	ETF	165.26	165.39	164.44	164.87	1366967.0
2020-01-03 14:00:00	IWM	ETF	164.88	164.96	164.49	164.855	1319369.0
2020-01-03 15:00:00	IWM	ETF	164.85	165.26	164.84	165.09	2922438.0
2020-01-03 16:00:00	IWM	ETF	165.09	165.2	164.87	164.99	1672846.0
2020-01-03 17:00:00	IWM	ETF	165.0	165.02	164.95	165.02	154566.0
2020-01-03 18:00:00	IWM	ETF	165.02	165.05	165.0	165.04	7254.0
2020-01-03 19:00:00	IWM	ETF	164.98	165.05	164.97	165.01	6009.0
2020-01-03 04:00:00	DIA	ETF	285.95	285.95	285.65	285.85	26000.0
2020-01-03 05:00:00	DIA	ETF	285.99	285.99	284.71	284.84	5433.0

> showing 50 of 12,254 rows — these rows as CSV

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