PREVIEW / etf_1hour / 2019-11-22

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-22.parquet
  size:    330 KB
  rows:    10,917

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
2019-11-22 04:00:00	SPY	ETF	311.3	311.42	310.94	311.05	20452.0
2019-11-22 05:00:00	SPY	ETF	311.06	311.15	310.9	310.97	20501.0
2019-11-22 06:00:00	SPY	ETF	310.95	311.0	310.62	310.9	28827.0
2019-11-22 07:00:00	SPY	ETF	310.91	311.11	310.9	311.0	82314.0
2019-11-22 08:00:00	SPY	ETF	311.0099	311.4	310.62	311.09	484948.0
2019-11-22 09:00:00	SPY	ETF	311.06	311.22	310.72	311.08	3450152.0
2019-11-22 10:00:00	SPY	ETF	311.08	311.24	310.17	310.4	8569587.0
2019-11-22 11:00:00	SPY	ETF	310.4	310.67	309.85	310.53	4256387.0
2019-11-22 12:00:00	SPY	ETF	310.54	310.92	310.49	310.85	2594491.0
2019-11-22 13:00:00	SPY	ETF	310.84	310.97	310.7	310.895	3224970.0
2019-11-22 14:00:00	SPY	ETF	310.9	311.0	310.71	310.9	3160390.0
2019-11-22 15:00:00	SPY	ETF	310.91	311.03	310.58	311.0	9284239.0
2019-11-22 16:00:00	SPY	ETF	310.98	311.22	310.3088	311.19	7689036.0
2019-11-22 17:00:00	SPY	ETF	311.19	311.2	310.96	311.16	1123060.0
2019-11-22 18:00:00	SPY	ETF	311.18	311.2	311.14	311.19	11124.0
2019-11-22 19:00:00	SPY	ETF	311.19	311.22	311.15	311.15	22434.0
2019-11-22 04:00:00	QQQ	ETF	202.55	202.55	202.19	202.36	13054.0
2019-11-22 05:00:00	QQQ	ETF	202.39	202.45	202.29	202.31	16610.0
2019-11-22 06:00:00	QQQ	ETF	202.35	202.35	202.05	202.2	14899.0
2019-11-22 07:00:00	QQQ	ETF	202.27	202.43	202.21	202.24	25649.0
2019-11-22 08:00:00	QQQ	ETF	202.4	202.6	201.9	202.25	269153.0
2019-11-22 09:00:00	QQQ	ETF	202.23	202.32	201.8	202.01	1731125.0
2019-11-22 10:00:00	QQQ	ETF	202.01	202.15	200.99	201.2062	2533016.0
2019-11-22 11:00:00	QQQ	ETF	201.21	201.5	200.74	201.365	1891543.0
2019-11-22 12:00:00	QQQ	ETF	201.37	201.74	201.3401	201.69	1033772.0
2019-11-22 13:00:00	QQQ	ETF	201.69	201.7636	201.41	201.57	821624.0
2019-11-22 14:00:00	QQQ	ETF	201.57	201.69	201.38	201.63	724740.0
2019-11-22 15:00:00	QQQ	ETF	201.64	201.82	201.43	201.82	2317549.0
2019-11-22 16:00:00	QQQ	ETF	201.82	201.92	201.65	201.92	1549014.0
2019-11-22 17:00:00	QQQ	ETF	201.82	201.89	201.81	201.85	8108.0
2019-11-22 18:00:00	QQQ	ETF	201.84	201.84	201.82	201.83	5295.0
2019-11-22 19:00:00	QQQ	ETF	201.83	201.9	201.83	201.89	2761.0
2019-11-22 04:00:00	IWM	ETF	158.2	158.32	158.2	158.29	400.0
2019-11-22 05:00:00	IWM	ETF	158.38	158.39	158.21	158.23	17000.0
2019-11-22 06:00:00	IWM	ETF	158.21	158.27	158.01	158.19	16300.0
2019-11-22 07:00:00	IWM	ETF	158.2	158.31	158.2	158.3	9100.0
2019-11-22 08:00:00	IWM	ETF	158.22	158.3	158.07	158.28	16004.0
2019-11-22 09:00:00	IWM	ETF	158.26	158.54	158.07	158.355	1344886.0
2019-11-22 10:00:00	IWM	ETF	158.35	158.4	157.58	157.85	2088347.0
2019-11-22 11:00:00	IWM	ETF	157.84	157.95	157.35	157.83	1371763.0
2019-11-22 12:00:00	IWM	ETF	157.83	158.28	157.82	158.27	863126.0
2019-11-22 13:00:00	IWM	ETF	158.2624	158.33	158.18	158.31	731563.0
2019-11-22 14:00:00	IWM	ETF	158.32	158.37	158.18	158.28	1108201.0
2019-11-22 15:00:00	IWM	ETF	158.28	158.43	158.16	158.18	1785322.0
2019-11-22 16:00:00	IWM	ETF	158.22	158.44	158.1955	158.4	1497665.0
2019-11-22 17:00:00	IWM	ETF	158.31	158.4	158.28	158.28	3006.0
2019-11-22 18:00:00	IWM	ETF	158.38	158.38	158.38	158.38	1000.0
2019-11-22 05:00:00	DIA	ETF	278.34	278.34	278.34	278.34	100.0
2019-11-22 08:00:00	DIA	ETF	278.35	278.35	278.13	278.25	2065.0
2019-11-22 09:00:00	DIA	ETF	278.35	278.6	278.04	278.47	181078.0

> showing 50 of 10,917 rows — these rows as CSV

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