PREVIEW / etf_1hour / 2020-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-02.parquet
  size:    379 KB
  rows:    12,359

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-02 04:00:00	SPY	ETF	323.52	323.86	323.52	323.83	28435.0
2020-01-02 05:00:00	SPY	ETF	323.82	323.98	323.82	323.91	15239.0
2020-01-02 06:00:00	SPY	ETF	323.94	323.94	323.63	323.63	17868.0
2020-01-02 07:00:00	SPY	ETF	323.61	323.85	323.61	323.85	64861.0
2020-01-02 08:00:00	SPY	ETF	323.6899	324.08	322.83	324.03	366678.0
2020-01-02 09:00:00	SPY	ETF	324.02	324.05	323.41	323.87	7139911.0
2020-01-02 10:00:00	SPY	ETF	323.87	323.9	322.61	323.25	7134424.0
2020-01-02 11:00:00	SPY	ETF	323.26	323.36	322.53	323.05	5304002.0
2020-01-02 12:00:00	SPY	ETF	323.06	323.46	322.92	323.36	3607233.0
2020-01-02 13:00:00	SPY	ETF	323.365	323.37	322.96	323.165	3734806.0
2020-01-02 14:00:00	SPY	ETF	323.17	323.87	323.13	323.78	6801232.0
2020-01-02 15:00:00	SPY	ETF	323.78	324.85	323.72	324.84	14899353.0
2020-01-02 16:00:00	SPY	ETF	324.84	325.12	324.1595	325.11	8883571.0
2020-01-02 17:00:00	SPY	ETF	325.08	325.19	324.86	325.1	337585.0
2020-01-02 18:00:00	SPY	ETF	325.06	325.25	325.06	325.08	146165.0
2020-01-02 19:00:00	SPY	ETF	325.05	325.19	325.02	325.14	66999.0
2020-01-02 04:00:00	QQQ	ETF	213.98	214.26	213.95	214.22	52659.0
2020-01-02 05:00:00	QQQ	ETF	214.24	214.37	214.24	214.32	24110.0
2020-01-02 06:00:00	QQQ	ETF	214.3	214.3	214.06	214.15	13286.0
2020-01-02 07:00:00	QQQ	ETF	214.08	214.34	214.06	214.29	81322.0
2020-01-02 08:00:00	QQQ	ETF	214.15	214.62	213.5	214.5502	208725.0
2020-01-02 09:00:00	QQQ	ETF	214.58	215.16	214.25	215.07	4673289.0
2020-01-02 10:00:00	QQQ	ETF	215.08	215.11	213.98	214.62	3245875.0
2020-01-02 11:00:00	QQQ	ETF	214.63	214.75	214.08	214.65	1879490.0
2020-01-02 12:00:00	QQQ	ETF	214.65	215.05	214.59	215.025	1446018.0
2020-01-02 13:00:00	QQQ	ETF	215.02	215.025	214.78	215.0154	1417372.0
2020-01-02 14:00:00	QQQ	ETF	215.02	215.5	215.0	215.465	3000752.0
2020-01-02 15:00:00	QQQ	ETF	215.46	216.15	215.45	216.14	4556869.0
2020-01-02 16:00:00	QQQ	ETF	216.12	216.41	216.01	216.4	1485362.0
2020-01-02 17:00:00	QQQ	ETF	216.42	216.46	216.32	216.4	37991.0
2020-01-02 18:00:00	QQQ	ETF	216.34	216.55	216.18	216.35	50903.0
2020-01-02 19:00:00	QQQ	ETF	216.34	216.48	216.33	216.45	22145.0
2020-01-02 04:00:00	IWM	ETF	166.79	166.79	166.79	166.79	130.0
2020-01-02 05:00:00	IWM	ETF	166.92	167.05	166.92	167.03	8800.0
2020-01-02 06:00:00	IWM	ETF	167.02	167.02	166.83	166.85	7321.0
2020-01-02 07:00:00	IWM	ETF	166.81	166.96	166.81	166.94	25378.0
2020-01-02 08:00:00	IWM	ETF	166.96	167.14	166.79	167.1	57833.0
2020-01-02 09:00:00	IWM	ETF	167.1	167.1	165.51	165.75	2714533.0
2020-01-02 10:00:00	IWM	ETF	165.77	165.78	164.61	165.2	2846585.0
2020-01-02 11:00:00	IWM	ETF	165.19	165.28	164.2299	164.64	1751713.0
2020-01-02 12:00:00	IWM	ETF	164.64	164.74	164.5	164.74	1423335.0
2020-01-02 13:00:00	IWM	ETF	164.74	164.7441	164.29	164.49	890282.0
2020-01-02 14:00:00	IWM	ETF	164.48	165.15	164.46	165.08	1216527.0
2020-01-02 15:00:00	IWM	ETF	165.07	165.77	164.9841	165.75	2750617.0
2020-01-02 16:00:00	IWM	ETF	165.76	166.0	165.6	165.96	2474439.0
2020-01-02 17:00:00	IWM	ETF	166.0	166.04	165.9301	166.0	4600.0
2020-01-02 18:00:00	IWM	ETF	166.0	166.13	166.0	166.05	4203.0
2020-01-02 19:00:00	IWM	ETF	166.02	166.04	165.96	165.96	4500.0
2020-01-02 04:00:00	DIA	ETF	286.79	286.83	286.76	286.82	1900.0
2020-01-02 05:00:00	DIA	ETF	286.92	287.01	286.92	287.01	2898.0

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

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