PREVIEW / etf_1hour / 2020-01-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-06.parquet
  size:    370 KB
  rows:    12,127

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-06 04:00:00	SPY	ETF	320.05	320.52	319.98	320.43	40769.0
2020-01-06 05:00:00	SPY	ETF	320.46	320.74	320.45	320.65	23802.0
2020-01-06 06:00:00	SPY	ETF	320.71	320.85	320.55	320.72	99895.0
2020-01-06 07:00:00	SPY	ETF	320.76	321.36	320.76	321.19	378228.0
2020-01-06 08:00:00	SPY	ETF	321.2	321.55	320.06	320.83	473585.0
2020-01-06 09:00:00	SPY	ETF	320.84	321.75	320.36	321.6	6794422.0
2020-01-06 10:00:00	SPY	ETF	321.595	322.49	321.47	322.22	5836934.0
2020-01-06 11:00:00	SPY	ETF	322.225	322.56	322.08	322.27	5836835.0
2020-01-06 12:00:00	SPY	ETF	322.275	322.5	322.14	322.39	2898349.0
2020-01-06 13:00:00	SPY	ETF	322.39	322.88	322.35	322.75	3462759.0
2020-01-06 14:00:00	SPY	ETF	322.745	323.21	322.6	322.99	4384733.0
2020-01-06 15:00:00	SPY	ETF	323.0	323.73	322.89	323.67	14189520.0
2020-01-06 16:00:00	SPY	ETF	323.66	323.95	323.27	323.27	10453202.0
2020-01-06 17:00:00	SPY	ETF	323.26	323.33	323.15	323.31	129367.0
2020-01-06 18:00:00	SPY	ETF	323.33	323.47	323.21	323.27	62600.0
2020-01-06 19:00:00	SPY	ETF	323.25	323.83	323.25	323.67	91885.0
2020-01-06 04:00:00	QQQ	ETF	212.26	212.54	212.12	212.5	31565.0
2020-01-06 05:00:00	QQQ	ETF	212.43	212.72	212.41	212.67	34232.0
2020-01-06 06:00:00	QQQ	ETF	212.67	212.78	212.54	212.72	25761.0
2020-01-06 07:00:00	QQQ	ETF	212.72	213.15	212.7	213.01	79744.0
2020-01-06 08:00:00	QQQ	ETF	212.86	213.54	212.29	212.8	221547.0
2020-01-06 09:00:00	QQQ	ETF	212.77	213.97	212.24	213.9	3328624.0
2020-01-06 10:00:00	QQQ	ETF	213.92	214.7	213.79	214.54	3134373.0
2020-01-06 11:00:00	QQQ	ETF	214.545	214.8427	214.4001	214.525	1743070.0
2020-01-06 12:00:00	QQQ	ETF	214.53	214.5599	214.26	214.51	1280923.0
2020-01-06 13:00:00	QQQ	ETF	214.5115	214.85	214.48	214.71	1380210.0
2020-01-06 14:00:00	QQQ	ETF	214.713	215.11	214.6	214.94	1382484.0
2020-01-06 15:00:00	QQQ	ETF	214.95	215.59	214.85	215.54	3414738.0
2020-01-06 16:00:00	QQQ	ETF	215.55	215.74	215.07	215.25	1135676.0
2020-01-06 17:00:00	QQQ	ETF	215.28	215.31	215.17	215.22	19850.0
2020-01-06 18:00:00	QQQ	ETF	215.26	215.4	215.11	215.11	35626.0
2020-01-06 19:00:00	QQQ	ETF	215.17	215.66	215.17	215.55	55506.0
2020-01-06 04:00:00	IWM	ETF	163.58	163.82	163.58	163.82	4864.0
2020-01-06 05:00:00	IWM	ETF	163.92	163.96	163.79	163.94	6250.0
2020-01-06 06:00:00	IWM	ETF	163.9	164.04	163.86	163.96	26085.0
2020-01-06 07:00:00	IWM	ETF	163.97	164.28	163.95	164.26	21756.0
2020-01-06 08:00:00	IWM	ETF	164.23	164.45	163.88	164.07	114681.0
2020-01-06 09:00:00	IWM	ETF	164.04	164.14	163.5801	163.65	2244542.0
2020-01-06 10:00:00	IWM	ETF	163.65	164.84	163.54	164.7	2290987.0
2020-01-06 11:00:00	IWM	ETF	164.71	165.05	164.56	165.03	1569002.0
2020-01-06 12:00:00	IWM	ETF	165.02	165.14	164.92	165.04	748880.0
2020-01-06 13:00:00	IWM	ETF	165.05	165.2261	165.01	165.065	545418.0
2020-01-06 14:00:00	IWM	ETF	165.065	165.525	165.02	165.47	1006255.0
2020-01-06 15:00:00	IWM	ETF	165.48	165.54	165.16	165.37	2814339.0
2020-01-06 16:00:00	IWM	ETF	165.38	165.43	165.02	165.08	1799912.0
2020-01-06 17:00:00	IWM	ETF	165.08	165.15	165.05	165.1	4970.0
2020-01-06 18:00:00	IWM	ETF	165.1	165.24	165.06	165.06	5565.0
2020-01-06 19:00:00	IWM	ETF	165.13	165.38	165.04	165.27	27864.0
2020-01-06 04:00:00	DIA	ETF	284.2	284.2	284.03	284.03	949.0
2020-01-06 05:00:00	DIA	ETF	284.59	284.72	284.59	284.72	1200.0

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

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