PREVIEW / etf_1hour / 2018-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-13.parquet
  size:    315 KB
  rows:    10,428

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-13 04:00:00	SPY	ETF	266.28	266.37	265.73	265.92	24748.0
2018-12-13 05:00:00	SPY	ETF	265.88	266.24	265.82	265.83	49056.0
2018-12-13 06:00:00	SPY	ETF	265.9	266.17	265.13	265.29	99965.0
2018-12-13 07:00:00	SPY	ETF	265.38	266.0	265.24	265.75	268052.0
2018-12-13 08:00:00	SPY	ETF	265.82	267.09	265.27	266.39	593519.0
2018-12-13 09:00:00	SPY	ETF	266.39	267.28	265.67	265.76	9027980.0
2018-12-13 10:00:00	SPY	ETF	265.76	267.49	264.99	265.81	14393410.0
2018-12-13 11:00:00	SPY	ETF	265.8	266.51	265.0	265.28	10856935.0
2018-12-13 12:00:00	SPY	ETF	265.27	265.58	264.55	265.0788	11401149.0
2018-12-13 13:00:00	SPY	ETF	265.07	265.91	264.28	264.92	9639114.0
2018-12-13 14:00:00	SPY	ETF	264.92	265.23	264.12	264.97	10195698.0
2018-12-13 15:00:00	SPY	ETF	264.99	266.04	264.54	265.37	19854840.0
2018-12-13 16:00:00	SPY	ETF	265.39	265.5372	264.7	264.97	8201829.0
2018-12-13 17:00:00	SPY	ETF	264.94	265.488	264.9	265.04	637514.0
2018-12-13 18:00:00	SPY	ETF	265.02	265.19	264.71	265.0	104863.0
2018-12-13 19:00:00	SPY	ETF	265.0	265.29	264.29	264.34	114455.0
2018-12-13 04:00:00	QQQ	ETF	165.98	165.98	165.48	165.55	4787.0
2018-12-13 05:00:00	QQQ	ETF	165.76	165.9	165.58	165.58	20700.0
2018-12-13 06:00:00	QQQ	ETF	165.49	165.75	165.08	165.21	17782.0
2018-12-13 07:00:00	QQQ	ETF	165.35	165.71	165.08	165.5	51460.0
2018-12-13 08:00:00	QQQ	ETF	165.05	166.78	165.05	166.14	258098.0
2018-12-13 09:00:00	QQQ	ETF	166.09	166.69	165.38	165.5764	4103018.0
2018-12-13 10:00:00	QQQ	ETF	165.57	166.82	164.55	165.26	7288914.0
2018-12-13 11:00:00	QQQ	ETF	165.25	165.79	164.61	164.76	5921357.0
2018-12-13 12:00:00	QQQ	ETF	164.755	164.96	164.14	164.64	4512202.0
2018-12-13 13:00:00	QQQ	ETF	164.63	165.44	164.19	164.69	4963660.0
2018-12-13 14:00:00	QQQ	ETF	164.7	164.9	164.03	164.75	4416176.0
2018-12-13 15:00:00	QQQ	ETF	164.75	165.49	164.34	165.12	7132519.0
2018-12-13 16:00:00	QQQ	ETF	165.11	165.2209	164.57	164.61	1515667.0
2018-12-13 17:00:00	QQQ	ETF	164.59	165.1029	164.59	164.69	27145.0
2018-12-13 18:00:00	QQQ	ETF	164.65	164.85	164.4	164.73	69342.0
2018-12-13 19:00:00	QQQ	ETF	164.69	164.92	164.2	164.29	76241.0
2018-12-13 04:00:00	IWM	ETF	145.0	145.0	145.0	145.0	1122.0
2018-12-13 05:00:00	IWM	ETF	145.14	145.14	145.14	145.14	265.0
2018-12-13 06:00:00	IWM	ETF	144.58	144.58	144.58	144.58	500.0
2018-12-13 07:00:00	IWM	ETF	144.72	145.02	144.7	144.9	3929.0
2018-12-13 08:00:00	IWM	ETF	144.82	145.76	144.72	145.21	25558.0
2018-12-13 09:00:00	IWM	ETF	145.28	145.69	143.97	144.24	1943676.0
2018-12-13 10:00:00	IWM	ETF	144.24	144.99	143.55	144.17	3139232.0
2018-12-13 11:00:00	IWM	ETF	144.19	144.35	143.33	143.73	2198623.0
2018-12-13 12:00:00	IWM	ETF	143.7	143.8	143.0	143.15	1834511.0
2018-12-13 13:00:00	IWM	ETF	143.15	143.57	142.84	142.945	1810511.0
2018-12-13 14:00:00	IWM	ETF	142.94	143.03	142.54	142.92	1858754.0
2018-12-13 15:00:00	IWM	ETF	142.91	143.31	142.61	142.77	4662086.0
2018-12-13 16:00:00	IWM	ETF	142.77	142.87	142.48	142.87	1548090.0
2018-12-13 17:00:00	IWM	ETF	142.8	142.9	142.728	142.9	6104.0
2018-12-13 18:00:00	IWM	ETF	142.87	142.87	142.76	142.85	2868.0
2018-12-13 19:00:00	IWM	ETF	142.85	142.9	142.37	142.37	7100.0
2018-12-13 05:00:00	DIA	ETF	246.15	246.3	246.15	246.2	2138.0
2018-12-13 06:00:00	DIA	ETF	246.06	246.06	245.3	245.42	2500.0

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

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