PREVIEW / etf_1hour / 2018-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-01.parquet
  size:    297 KB
  rows:    9,804

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-06-01 04:00:00	SPY	ETF	271.72	271.83	271.65	271.65	12675.0
2018-06-01 05:00:00	SPY	ETF	271.83	272.17	271.76	272.03	30547.0
2018-06-01 06:00:00	SPY	ETF	272.14	272.14	271.9	272.04	47986.0
2018-06-01 07:00:00	SPY	ETF	272.05	272.2	271.95	272.06	417399.0
2018-06-01 08:00:00	SPY	ETF	272.0301	272.46	270.94	272.45	1535066.0
2018-06-01 09:00:00	SPY	ETF	272.45	273.06	272.33	272.94	7774781.0
2018-06-01 10:00:00	SPY	ETF	272.95	273.6	272.41	273.26	15446592.0
2018-06-01 11:00:00	SPY	ETF	273.26	273.49	273.01	273.39	6843247.0
2018-06-01 12:00:00	SPY	ETF	273.4	273.72	273.37	273.595	4100775.0
2018-06-01 13:00:00	SPY	ETF	273.6	273.94	273.5875	273.62	5126637.0
2018-06-01 14:00:00	SPY	ETF	273.63	273.74	273.26	273.63	5972569.0
2018-06-01 15:00:00	SPY	ETF	273.62	273.65	273.09	273.65	14140018.0
2018-06-01 16:00:00	SPY	ETF	273.65	273.87	273.16	273.68	6232831.0
2018-06-01 17:00:00	SPY	ETF	273.61	273.95	273.61	273.89	658052.0
2018-06-01 18:00:00	SPY	ETF	273.83	273.83	273.75	273.75	17603.0
2018-06-01 19:00:00	SPY	ETF	273.75	273.96	273.75	273.96	25859.0
2018-06-01 04:00:00	QQQ	ETF	170.53	170.62	170.53	170.62	4511.0
2018-06-01 05:00:00	QQQ	ETF	170.6	170.77	170.6	170.67	20323.0
2018-06-01 06:00:00	QQQ	ETF	170.6	170.66	170.54	170.64	9750.0
2018-06-01 07:00:00	QQQ	ETF	170.66	170.87	170.64	170.73	111343.0
2018-06-01 08:00:00	QQQ	ETF	170.8	170.99	170.07	170.98	642666.0
2018-06-01 09:00:00	QQQ	ETF	170.96	171.56	170.84	171.44	3409545.0
2018-06-01 10:00:00	QQQ	ETF	171.45	172.4	171.12	172.25	7881742.0
2018-06-01 11:00:00	QQQ	ETF	172.25	172.65	172.215	172.545	3741045.0
2018-06-01 12:00:00	QQQ	ETF	172.55	172.7	172.49	172.56	2107086.0
2018-06-01 13:00:00	QQQ	ETF	172.57	172.84	172.56	172.68	2821772.0
2018-06-01 14:00:00	QQQ	ETF	172.69	172.75	172.4	172.59	2883525.0
2018-06-01 15:00:00	QQQ	ETF	172.58	172.7599	172.27	172.75	5831492.0
2018-06-01 16:00:00	QQQ	ETF	172.75	172.7807	172.54	172.7	2675822.0
2018-06-01 17:00:00	QQQ	ETF	172.74	172.74	172.5	172.66	104518.0
2018-06-01 18:00:00	QQQ	ETF	172.64	172.65	172.56	172.56	9773.0
2018-06-01 19:00:00	QQQ	ETF	172.64	172.68	172.6	172.68	25237.0
2018-06-01 04:00:00	IWM	ETF	163.47	163.5	163.47	163.49	1002.0
2018-06-01 05:00:00	IWM	ETF	163.58	163.69	163.58	163.65	3000.0
2018-06-01 06:00:00	IWM	ETF	163.6	163.62	163.54	163.6	4100.0
2018-06-01 07:00:00	IWM	ETF	163.62	163.79	163.6	163.75	84107.0
2018-06-01 08:00:00	IWM	ETF	163.71	163.98	162.77	163.96	105371.0
2018-06-01 09:00:00	IWM	ETF	163.97	164.06	163.58	163.685	1936394.0
2018-06-01 10:00:00	IWM	ETF	163.69	163.96	163.28	163.91	3235467.0
2018-06-01 11:00:00	IWM	ETF	163.92	164.21	163.63	163.76	2478803.0
2018-06-01 12:00:00	IWM	ETF	163.76	164.3	163.63	164.19	1913025.0
2018-06-01 13:00:00	IWM	ETF	164.16	164.38	164.12	164.175	1875991.0
2018-06-01 14:00:00	IWM	ETF	164.175	164.2	163.85	164.1	1813694.0
2018-06-01 15:00:00	IWM	ETF	164.09	164.18	163.86	163.88	3863979.0
2018-06-01 16:00:00	IWM	ETF	163.85	164.25	163.76	164.24	1492235.0
2018-06-01 17:00:00	IWM	ETF	164.11	164.13	164.05	164.11	24248.0
2018-06-01 18:00:00	IWM	ETF	164.04	164.04	164.04	164.04	3500.0
2018-06-01 19:00:00	IWM	ETF	164.1	164.1	164.08	164.1	500.0
2018-06-01 04:00:00	DIA	ETF	244.94	245.04	244.94	245.04	500.0
2018-06-01 05:00:00	DIA	ETF	245.25	245.48	245.25	245.42	5000.0

> showing 50 of 9,804 rows — these rows as CSV

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