PREVIEW / etf_1hour / 2018-04-24

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-24.parquet
  size:    304 KB
  rows:    9,911

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-04-24 04:00:00	SPY	ETF	267.45	268.13	267.45	268.0	38301.0
2018-04-24 05:00:00	SPY	ETF	268.06	268.06	267.81	267.94	38767.0
2018-04-24 06:00:00	SPY	ETF	267.97	268.4	267.96	268.3	60470.0
2018-04-24 07:00:00	SPY	ETF	268.29	268.45	268.13	268.3	177025.0
2018-04-24 08:00:00	SPY	ETF	268.29	268.44	267.23	268.03	416889.0
2018-04-24 09:00:00	SPY	ETF	268.02	268.05	266.92	267.2702	6741662.0
2018-04-24 10:00:00	SPY	ETF	267.27	267.78	266.19	266.38	11184617.0
2018-04-24 11:00:00	SPY	ETF	266.38	266.87	265.68	265.71	11658664.0
2018-04-24 12:00:00	SPY	ETF	265.7	266.0	263.57	263.57	14464975.0
2018-04-24 13:00:00	SPY	ETF	263.58	264.09	261.98	262.31	13947493.0
2018-04-24 14:00:00	SPY	ETF	262.3	262.65	261.28	262.33	17854290.0
2018-04-24 15:00:00	SPY	ETF	262.33	263.34	261.65	263.03	27306590.0
2018-04-24 16:00:00	SPY	ETF	263.04	267.76	262.97	263.24	6835097.0
2018-04-24 17:00:00	SPY	ETF	263.23	263.27	263.08	263.16	139346.0
2018-04-24 18:00:00	SPY	ETF	263.16	263.52	263.07	263.39	73719.0
2018-04-24 19:00:00	SPY	ETF	263.45	263.52	263.29	263.45	15539.0
2018-04-24 04:00:00	QQQ	ETF	162.39	163.12	162.39	163.07	45725.0
2018-04-24 05:00:00	QQQ	ETF	163.08	163.2	163.01	163.14	16200.0
2018-04-24 06:00:00	QQQ	ETF	163.06	163.5	163.04	163.39	43267.0
2018-04-24 07:00:00	QQQ	ETF	163.36	163.36	162.94	163.11	280216.0
2018-04-24 08:00:00	QQQ	ETF	163.06	163.24	162.79	162.86	487038.0
2018-04-24 09:00:00	QQQ	ETF	162.86	162.905	161.75	162.21	4462669.0
2018-04-24 10:00:00	QQQ	ETF	162.2	162.43	160.61	160.71	7223991.0
2018-04-24 11:00:00	QQQ	ETF	160.71	160.93	159.69	160.05	8840265.0
2018-04-24 12:00:00	QQQ	ETF	160.04	160.31	158.61	158.61	7563768.0
2018-04-24 13:00:00	QQQ	ETF	158.61	159.18	158.01	158.2454	7758081.0
2018-04-24 14:00:00	QQQ	ETF	158.24	158.42	157.39	158.23	10229764.0
2018-04-24 15:00:00	QQQ	ETF	158.27	158.87	157.58	158.5	11259782.0
2018-04-24 16:00:00	QQQ	ETF	158.49	158.9	158.44	158.82	2492448.0
2018-04-24 17:00:00	QQQ	ETF	158.73	158.85	158.6	158.7	102422.0
2018-04-24 18:00:00	QQQ	ETF	158.74	159.01	158.71	158.81	88360.0
2018-04-24 19:00:00	QQQ	ETF	158.88	159.01	158.8	158.94	27219.0
2018-04-24 04:00:00	IWM	ETF	156.0	156.01	156.0	156.01	2700.0
2018-04-24 05:00:00	IWM	ETF	155.9	155.99	155.9	155.99	2100.0
2018-04-24 06:00:00	IWM	ETF	155.91	156.09	155.91	156.09	1630.0
2018-04-24 07:00:00	IWM	ETF	156.09	156.27	156.04	156.22	4050.0
2018-04-24 08:00:00	IWM	ETF	156.22	156.27	156.0	156.05	13450.0
2018-04-24 09:00:00	IWM	ETF	156.05	156.42	155.81	156.19	1868789.0
2018-04-24 10:00:00	IWM	ETF	156.18	156.63	155.66	156.1	3001298.0
2018-04-24 11:00:00	IWM	ETF	156.11	156.34	155.55	155.88	2248789.0
2018-04-24 12:00:00	IWM	ETF	155.87	156.08	154.42	154.43	2840440.0
2018-04-24 13:00:00	IWM	ETF	154.42	154.8	153.5	153.67	2814275.0
2018-04-24 14:00:00	IWM	ETF	153.68	154.28	153.19	153.91	2875387.0
2018-04-24 15:00:00	IWM	ETF	153.93	154.61	153.86	154.44	4820854.0
2018-04-24 16:00:00	IWM	ETF	154.45	154.669	154.41	154.6	1199952.0
2018-04-24 17:00:00	IWM	ETF	154.43	154.58	154.43	154.58	2223.0
2018-04-24 18:00:00	IWM	ETF	154.57	154.75	154.43	154.66	19862.0
2018-04-24 19:00:00	IWM	ETF	154.72	154.73	154.61	154.66	8316.0
2018-04-24 04:00:00	DIA	ETF	244.96	245.01	244.96	245.01	305.0
2018-04-24 05:00:00	DIA	ETF	245.3	245.46	245.28	245.46	1600.0

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

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