PREVIEW / etf_1hour / 2018-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-29.parquet
  size:    317 KB
  rows:    10,493

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
2018-01-29 04:00:00	SPY	ETF	286.37	286.37	285.79	285.79	102716.0
2018-01-29 05:00:00	SPY	ETF	285.79	286.07	285.7	286.07	64050.0
2018-01-29 06:00:00	SPY	ETF	286.12	286.17	285.81	286.17	79867.0
2018-01-29 07:00:00	SPY	ETF	286.17	286.17	285.83	286.06	156695.0
2018-01-29 08:00:00	SPY	ETF	286.58	286.58	285.81	285.85	1008538.0
2018-01-29 09:00:00	SPY	ETF	285.85	286.43	285.68	286.27	9197838.0
2018-01-29 10:00:00	SPY	ETF	286.2601	286.3	284.95	285.26	14396680.0
2018-01-29 11:00:00	SPY	ETF	285.25	285.88	284.82	285.45	11290231.0
2018-01-29 12:00:00	SPY	ETF	285.46	285.98	285.24	285.91	7071468.0
2018-01-29 13:00:00	SPY	ETF	285.92	286.13	285.68	285.735	4406230.0
2018-01-29 14:00:00	SPY	ETF	285.735	285.93	285.26	285.57	6184091.0
2018-01-29 15:00:00	SPY	ETF	285.58	285.71	284.5	284.68	21646541.0
2018-01-29 16:00:00	SPY	ETF	284.66	284.93	284.52	284.61	12070653.0
2018-01-29 17:00:00	SPY	ETF	284.61	284.64	284.54	284.61	65191.0
2018-01-29 18:00:00	SPY	ETF	284.63	285.01	284.63	284.96	137832.0
2018-01-29 19:00:00	SPY	ETF	284.97	285.07	284.71	284.74	65921.0
2018-01-29 04:00:00	QQQ	ETF	170.55	170.65	170.33	170.33	21155.0
2018-01-29 05:00:00	QQQ	ETF	170.26	170.46	170.26	170.34	40400.0
2018-01-29 06:00:00	QQQ	ETF	170.43	170.55	170.3	170.53	25200.0
2018-01-29 07:00:00	QQQ	ETF	170.58	170.58	170.29	170.46	127372.0
2018-01-29 08:00:00	QQQ	ETF	170.57	170.6	170.38	170.42	232447.0
2018-01-29 09:00:00	QQQ	ETF	170.42	170.73	170.02	170.605	3847193.0
2018-01-29 10:00:00	QQQ	ETF	170.61	170.629	169.78	170.09	5054394.0
2018-01-29 11:00:00	QQQ	ETF	170.08	170.59	169.76	170.37	3954628.0
2018-01-29 12:00:00	QQQ	ETF	170.365	170.72	170.22	170.66	2328375.0
2018-01-29 13:00:00	QQQ	ETF	170.6701	170.91	170.5	170.59	1833626.0
2018-01-29 14:00:00	QQQ	ETF	170.5863	170.7	170.26	170.43	1836340.0
2018-01-29 15:00:00	QQQ	ETF	170.43	170.56	169.74	170.09	6286058.0
2018-01-29 16:00:00	QQQ	ETF	170.09	170.2705	170.0	170.1	1941011.0
2018-01-29 17:00:00	QQQ	ETF	170.1	170.11	170.02	170.1	17106.0
2018-01-29 18:00:00	QQQ	ETF	170.09	170.35	170.09	170.35	39737.0
2018-01-29 19:00:00	QQQ	ETF	170.36	170.37	170.17	170.2	20988.0
2018-01-29 04:00:00	IWM	ETF	159.5	159.5	158.99	158.99	6738.0
2018-01-29 05:00:00	IWM	ETF	158.92	159.22	158.92	159.22	8150.0
2018-01-29 06:00:00	IWM	ETF	159.21	159.29	159.04	159.25	12400.0
2018-01-29 07:00:00	IWM	ETF	159.25	159.3	159.01	159.05	60027.0
2018-01-29 08:00:00	IWM	ETF	159.6	159.6	158.95	158.95	41685.0
2018-01-29 09:00:00	IWM	ETF	159.01	159.8	158.92	159.54	1853048.0
2018-01-29 10:00:00	IWM	ETF	159.55	159.86	158.875	159.24	4184261.0
2018-01-29 11:00:00	IWM	ETF	159.24	159.29	158.74	159.05	1601731.0
2018-01-29 12:00:00	IWM	ETF	159.02	159.42	158.94	159.37	713655.0
2018-01-29 13:00:00	IWM	ETF	159.38	159.54	159.2	159.26	829984.0
2018-01-29 14:00:00	IWM	ETF	159.27	159.43	159.025	159.3	1683701.0
2018-01-29 15:00:00	IWM	ETF	159.3001	159.34	158.62	158.7	3356532.0
2018-01-29 16:00:00	IWM	ETF	158.69	158.83	158.43	158.54	1199052.0
2018-01-29 17:00:00	IWM	ETF	158.59	158.6	158.59	158.6	1403.0
2018-01-29 18:00:00	IWM	ETF	158.63	158.89	158.63	158.81	8619.0
2018-01-29 19:00:00	IWM	ETF	158.84	158.88	158.57	158.63	11248.0
2018-01-29 04:00:00	DIA	ETF	265.92	265.92	265.92	265.92	500.0
2018-01-29 06:00:00	DIA	ETF	265.7	265.75	265.65	265.75	5100.0

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

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