PREVIEW / etf_1hour / 2018-12-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-11.parquet
  size:    329 KB
  rows:    10,794

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-12-11 04:00:00	SPY	ETF	263.94	264.5	263.82	264.5	27864.0
2018-12-11 05:00:00	SPY	ETF	264.56	265.77	264.56	265.63	70256.0
2018-12-11 06:00:00	SPY	ETF	265.62	266.78	265.6	266.4	152874.0
2018-12-11 07:00:00	SPY	ETF	266.3	267.22	266.3	266.85	664549.0
2018-12-11 08:00:00	SPY	ETF	266.85	268.1	263.84	267.73	1561613.0
2018-12-11 09:00:00	SPY	ETF	267.72	267.87	266.89	267.11	13656802.0
2018-12-11 10:00:00	SPY	ETF	267.11	267.84	266.0	266.42	14586436.0
2018-12-11 11:00:00	SPY	ETF	266.41	266.5	264.85	265.6208	16307506.0
2018-12-11 12:00:00	SPY	ETF	265.63	265.63	263.61	264.205	17180998.0
2018-12-11 13:00:00	SPY	ETF	264.2	264.71	262.52	262.695	11882139.0
2018-12-11 14:00:00	SPY	ETF	262.71	265.65	262.48	264.99	14812510.0
2018-12-11 15:00:00	SPY	ETF	264.99	266.39	264.0	264.09	23157883.0
2018-12-11 16:00:00	SPY	ETF	264.08	264.54	263.19	263.47	4101886.0
2018-12-11 17:00:00	SPY	ETF	263.46	264.1058	262.73	263.74	553686.0
2018-12-11 18:00:00	SPY	ETF	263.74	264.97	263.59	264.25	494409.0
2018-12-11 19:00:00	SPY	ETF	264.19	265.16	263.77	265.14	246118.0
2018-12-11 04:00:00	QQQ	ETF	162.96	163.4	162.93	163.4	68122.0
2018-12-11 05:00:00	QQQ	ETF	163.5	164.44	163.5	164.38	102498.0
2018-12-11 06:00:00	QQQ	ETF	164.37	165.25	164.36	164.88	90555.0
2018-12-11 07:00:00	QQQ	ETF	164.84	165.44	164.84	165.23	285676.0
2018-12-11 08:00:00	QQQ	ETF	165.08	166.05	164.9	165.8	478102.0
2018-12-11 09:00:00	QQQ	ETF	165.782	165.86	164.9899	165.15	5885441.0
2018-12-11 10:00:00	QQQ	ETF	165.16	165.7	164.27	164.57	8363371.0
2018-12-11 11:00:00	QQQ	ETF	164.57	164.77	163.91	164.59	6060082.0
2018-12-11 12:00:00	QQQ	ETF	164.59	164.59	163.23	163.76	5575131.0
2018-12-11 13:00:00	QQQ	ETF	163.76	163.97	162.37	162.514	4505170.0
2018-12-11 14:00:00	QQQ	ETF	162.52	164.37	162.23	163.97	7096690.0
2018-12-11 15:00:00	QQQ	ETF	163.98	164.95	163.52	163.57	8492653.0
2018-12-11 16:00:00	QQQ	ETF	163.57	163.9	162.73	162.96	3183932.0
2018-12-11 17:00:00	QQQ	ETF	162.92	163.23	162.8	163.2	103555.0
2018-12-11 18:00:00	QQQ	ETF	163.14	164.08	163.13	163.61	212587.0
2018-12-11 19:00:00	QQQ	ETF	163.54	164.3799	163.28	164.3	102563.0
2018-12-11 20:00:00	QQQ	ETF	164.37	164.37	164.37	164.37	350.0
2018-12-11 04:00:00	IWM	ETF	143.71	143.84	143.71	143.84	2797.0
2018-12-11 05:00:00	IWM	ETF	144.5	144.5	144.42	144.49	1277.0
2018-12-11 06:00:00	IWM	ETF	144.71	145.2	144.71	145.2	11020.0
2018-12-11 07:00:00	IWM	ETF	144.95	145.47	144.95	145.17	37082.0
2018-12-11 08:00:00	IWM	ETF	144.96	145.79	143.76	145.68	133070.0
2018-12-11 09:00:00	IWM	ETF	145.76	145.88	144.96	145.53	2455603.0
2018-12-11 10:00:00	IWM	ETF	145.54	146.19	144.98	145.39	2697700.0
2018-12-11 11:00:00	IWM	ETF	145.3906	145.58	144.14	144.57	1994414.0
2018-12-11 12:00:00	IWM	ETF	144.58	144.58	143.53	143.89	2423108.0
2018-12-11 13:00:00	IWM	ETF	143.88	144.08	142.39	142.57	2387582.0
2018-12-11 14:00:00	IWM	ETF	142.57	144.075	142.49	143.76	2546026.0
2018-12-11 15:00:00	IWM	ETF	143.78	144.35	143.4	143.41	5111747.0
2018-12-11 16:00:00	IWM	ETF	143.42	143.82	143.08	143.25	4226969.0
2018-12-11 17:00:00	IWM	ETF	143.01	143.45	143.0	143.22	14819.0
2018-12-11 18:00:00	IWM	ETF	143.45	143.92	143.4	143.6	19644.0
2018-12-11 19:00:00	IWM	ETF	143.46	144.05	143.32	144.05	9828.0
2018-12-11 06:00:00	DIA	ETF	246.27	247.1	246.27	246.94	3650.0

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

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