PREVIEW / etf_1hour / 2018-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-10.parquet
  size:    334 KB
  rows:    10,978

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-10 04:00:00	SPY	ETF	262.7	263.14	262.51	263.0	36839.0
2018-12-10 05:00:00	SPY	ETF	263.04	263.28	262.84	263.26	20945.0
2018-12-10 06:00:00	SPY	ETF	263.27	263.51	262.86	263.18	166677.0
2018-12-10 07:00:00	SPY	ETF	263.2	264.16	262.84	263.94	384632.0
2018-12-10 08:00:00	SPY	ETF	263.96	264.77	262.0	263.9	603414.0
2018-12-10 09:00:00	SPY	ETF	263.89	264.21	261.27	261.67	16251611.0
2018-12-10 10:00:00	SPY	ETF	261.66	263.26	260.14	260.49	24852247.0
2018-12-10 11:00:00	SPY	ETF	260.4925	261.27	258.62	260.26	28912455.0
2018-12-10 12:00:00	SPY	ETF	260.25	262.78	259.615	262.29	18385544.0
2018-12-10 13:00:00	SPY	ETF	262.29	263.6199	261.8315	263.0213	14860673.0
2018-12-10 14:00:00	SPY	ETF	263.03	264.4	262.33	263.3	15114567.0
2018-12-10 15:00:00	SPY	ETF	263.3	265.1613	262.71	264.08	23965783.0
2018-12-10 16:00:00	SPY	ETF	264.06	264.88	264.04	264.46	5693972.0
2018-12-10 17:00:00	SPY	ETF	264.48	264.69	264.07	264.69	255152.0
2018-12-10 18:00:00	SPY	ETF	264.65	264.65	263.9	264.03	176820.0
2018-12-10 19:00:00	SPY	ETF	264.07	264.21	263.42	263.52	187599.0
2018-12-10 04:00:00	QQQ	ETF	160.4	161.0	160.4	161.0	48227.0
2018-12-10 05:00:00	QQQ	ETF	160.89	161.22	160.83	161.2	11653.0
2018-12-10 06:00:00	QQQ	ETF	161.2	161.37	161.08	161.21	59931.0
2018-12-10 07:00:00	QQQ	ETF	161.19	162.0	160.9	161.77	261496.0
2018-12-10 08:00:00	QQQ	ETF	160.98	162.42	160.3	161.61	512990.0
2018-12-10 09:00:00	QQQ	ETF	161.62	162.76	160.56	160.96	8933930.0
2018-12-10 10:00:00	QQQ	ETF	160.96	162.36	160.35	160.6099	12825860.0
2018-12-10 11:00:00	QQQ	ETF	160.61	161.34	159.41	160.6	12430668.0
2018-12-10 12:00:00	QQQ	ETF	160.59	162.39	160.01	161.99	7320523.0
2018-12-10 13:00:00	QQQ	ETF	161.995	162.74	161.38	162.34	6118978.0
2018-12-10 14:00:00	QQQ	ETF	162.37	163.36	161.93	162.54	6350335.0
2018-12-10 15:00:00	QQQ	ETF	162.54	163.78	162.177	163.05	7425863.0
2018-12-10 16:00:00	QQQ	ETF	163.04	163.61	163.02	163.24	1939551.0
2018-12-10 17:00:00	QQQ	ETF	163.17	163.38	163.17	163.38	27280.0
2018-12-10 18:00:00	QQQ	ETF	163.36	163.36	162.88	162.88	63980.0
2018-12-10 19:00:00	QQQ	ETF	162.95	163.07	162.6	162.62	65205.0
2018-12-10 04:00:00	IWM	ETF	143.91	144.03	143.91	144.03	700.0
2018-12-10 06:00:00	IWM	ETF	144.21	144.24	144.02	144.03	1240.0
2018-12-10 07:00:00	IWM	ETF	144.23	144.67	144.11	144.6	112324.0
2018-12-10 08:00:00	IWM	ETF	144.25	145.04	144.15	144.5	166260.0
2018-12-10 09:00:00	IWM	ETF	144.43	144.72	143.11	143.7	2672873.0
2018-12-10 10:00:00	IWM	ETF	143.69	144.44	142.45	142.62	3349249.0
2018-12-10 11:00:00	IWM	ETF	142.63	143.36	141.45	142.72	4614043.0
2018-12-10 12:00:00	IWM	ETF	142.71	143.74	142.12	143.37	3045881.0
2018-12-10 13:00:00	IWM	ETF	143.37	143.97	142.94	143.57	2565549.0
2018-12-10 14:00:00	IWM	ETF	143.58	144.4	143.0601	143.57	3470393.0
2018-12-10 15:00:00	IWM	ETF	143.55	144.15	143.08	143.64	5336713.0
2018-12-10 16:00:00	IWM	ETF	143.64	144.2	143.6	144.0	1606539.0
2018-12-10 17:00:00	IWM	ETF	144.17	144.17	143.88	143.88	2029.0
2018-12-10 18:00:00	IWM	ETF	144.15	144.15	143.79	143.81	11270.0
2018-12-10 19:00:00	IWM	ETF	143.79	143.86	143.39	143.46	67651.0
2018-12-10 04:00:00	DIA	ETF	243.6	243.6	243.6	243.6	100.0
2018-12-10 05:00:00	DIA	ETF	243.86	243.86	243.86	243.86	500.0
2018-12-10 06:00:00	DIA	ETF	244.0	244.26	244.0	244.26	2105.0

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

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