PREVIEW / etf_1hour / 2018-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-07.parquet
  size:    303 KB
  rows:    9,929

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-03-07 04:00:00	SPY	ETF	270.08	270.28	269.65	269.83	150419.0
2018-03-07 05:00:00	SPY	ETF	269.91	270.59	269.84	269.94	75590.0
2018-03-07 06:00:00	SPY	ETF	269.96	270.2	269.56	269.99	139623.0
2018-03-07 07:00:00	SPY	ETF	269.98	270.85	269.92	270.7	1072217.0
2018-03-07 08:00:00	SPY	ETF	270.29	271.14	268.75	270.7	1447103.0
2018-03-07 09:00:00	SPY	ETF	270.73	271.84	270.2	271.13	10788374.0
2018-03-07 10:00:00	SPY	ETF	271.11	272.51	271.04	272.31	10653561.0
2018-03-07 11:00:00	SPY	ETF	272.3	272.39	270.86	270.88	8253974.0
2018-03-07 12:00:00	SPY	ETF	270.89	271.19	270.27	271.08	10365010.0
2018-03-07 13:00:00	SPY	ETF	271.07	271.62	270.32	271.38	6303493.0
2018-03-07 14:00:00	SPY	ETF	271.39	272.22	271.12	271.809	9182032.0
2018-03-07 15:00:00	SPY	ETF	271.8	273.18	271.73	272.8	18780493.0
2018-03-07 16:00:00	SPY	ETF	272.79	272.85	270.7417	272.4	8287992.0
2018-03-07 17:00:00	SPY	ETF	272.48	272.7912	272.43	272.47	464394.0
2018-03-07 18:00:00	SPY	ETF	272.47	272.48	272.2	272.44	65142.0
2018-03-07 19:00:00	SPY	ETF	272.4	272.58	272.2	272.27	67014.0
2018-03-07 04:00:00	QQQ	ETF	166.97	167.07	166.66	166.8	44174.0
2018-03-07 05:00:00	QQQ	ETF	166.79	167.33	166.79	167.02	101974.0
2018-03-07 06:00:00	QQQ	ETF	166.95	167.03	166.72	166.98	57115.0
2018-03-07 07:00:00	QQQ	ETF	166.99	167.52	166.99	167.32	218514.0
2018-03-07 08:00:00	QQQ	ETF	167.26	167.61	167.13	167.37	395857.0
2018-03-07 09:00:00	QQQ	ETF	167.36	168.13	167.08	167.59	3774263.0
2018-03-07 10:00:00	QQQ	ETF	167.5801	168.6	167.4225	168.45	4306379.0
2018-03-07 11:00:00	QQQ	ETF	168.43	168.46	167.415	167.42	2745348.0
2018-03-07 12:00:00	QQQ	ETF	167.415	167.9	166.96	167.83	3208712.0
2018-03-07 13:00:00	QQQ	ETF	167.81	168.24	167.32	168.13	2659660.0
2018-03-07 14:00:00	QQQ	ETF	168.1115	168.56	167.92	168.31	2883724.0
2018-03-07 15:00:00	QQQ	ETF	168.3	169.07	168.25	168.91	4855661.0
2018-03-07 16:00:00	QQQ	ETF	168.9	168.93	167.9291	168.71	3507955.0
2018-03-07 17:00:00	QQQ	ETF	168.67	168.78	168.65	168.75	5163.0
2018-03-07 18:00:00	QQQ	ETF	168.75	168.93	168.53	168.53	29626.0
2018-03-07 19:00:00	QQQ	ETF	168.69	168.76	168.55	168.63	20295.0
2018-03-07 04:00:00	IWM	ETF	154.25	154.25	153.91	154.06	20852.0
2018-03-07 05:00:00	IWM	ETF	154.2	154.44	154.16	154.21	46712.0
2018-03-07 06:00:00	IWM	ETF	154.0	154.21	153.94	154.16	24586.0
2018-03-07 07:00:00	IWM	ETF	154.33	154.61	154.18	154.42	61880.0
2018-03-07 08:00:00	IWM	ETF	154.42	154.66	153.99	154.43	219587.0
2018-03-07 09:00:00	IWM	ETF	154.35	155.41	154.22	155.03	2768061.0
2018-03-07 10:00:00	IWM	ETF	154.99	156.3701	154.9577	156.31	3081976.0
2018-03-07 11:00:00	IWM	ETF	156.3	156.33	155.28	155.29	2290594.0
2018-03-07 12:00:00	IWM	ETF	155.287	155.98	155.14	155.89	2107541.0
2018-03-07 13:00:00	IWM	ETF	155.88	156.09	155.36	155.95	1810899.0
2018-03-07 14:00:00	IWM	ETF	155.97	156.42	155.79	156.3	1913598.0
2018-03-07 15:00:00	IWM	ETF	156.3	156.93	156.28	156.72	5536514.0
2018-03-07 16:00:00	IWM	ETF	156.74	156.74	156.35	156.46	1299107.0
2018-03-07 17:00:00	IWM	ETF	156.55	156.56	156.42	156.56	4413.0
2018-03-07 18:00:00	IWM	ETF	156.46	156.54	156.34	156.48	9020.0
2018-03-07 19:00:00	IWM	ETF	156.5	156.51	156.36	156.38	12595.0
2018-03-07 04:00:00	DIA	ETF	245.6	245.65	245.42	245.42	2350.0
2018-03-07 05:00:00	DIA	ETF	245.5	246.15	245.5	246.15	800.0

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

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