PREVIEW / etf_1hour / 2015-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-22.parquet
  size:    240 KB
  rows:    7,603

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
2015-04-22 04:00:00	SPY	ETF	209.82	209.82	208.72	208.83	60276.0
2015-04-22 05:00:00	SPY	ETF	208.81	209.19	208.59	209.13	46109.0
2015-04-22 06:00:00	SPY	ETF	209.01	209.01	208.54	208.94	108888.0
2015-04-22 07:00:00	SPY	ETF	208.97	209.28	208.95	209.19	222658.0
2015-04-22 08:00:00	SPY	ETF	209.19	210.15	208.99	209.73	658696.0
2015-04-22 09:00:00	SPY	ETF	209.73	210.1	209.28	209.535	10291336.0
2015-04-22 10:00:00	SPY	ETF	209.54	210.16	208.9	210.08	19232154.0
2015-04-22 11:00:00	SPY	ETF	210.08	210.24	209.92	210.21	7057231.0
2015-04-22 12:00:00	SPY	ETF	210.2099	210.37	209.91	210.26	6109987.0
2015-04-22 13:00:00	SPY	ETF	210.26	210.67	210.12	210.58	5624231.0
2015-04-22 14:00:00	SPY	ETF	210.59	210.77	210.53	210.58	6815206.0
2015-04-22 15:00:00	SPY	ETF	210.59	210.85	210.0753	210.64	17071110.0
2015-04-22 16:00:00	SPY	ETF	210.64	210.66	210.0753	210.43	4361022.0
2015-04-22 17:00:00	SPY	ETF	210.46	210.48	210.39	210.45	106336.0
2015-04-22 18:00:00	SPY	ETF	210.45	210.56	210.44	210.54	134735.0
2015-04-22 19:00:00	SPY	ETF	210.55	210.58	210.51	210.54	27712.0
2015-04-22 20:00:00	SPY	ETF	210.6421	210.6421	210.6421	210.6421	59000.0
2015-04-22 04:00:00	QQQ	ETF	107.99	107.99	107.61	107.61	8400.0
2015-04-22 05:00:00	QQQ	ETF	107.43	107.72	107.42	107.72	700.0
2015-04-22 06:00:00	QQQ	ETF	107.57	107.72	107.45	107.72	32800.0
2015-04-22 07:00:00	QQQ	ETF	107.78	107.96	107.78	107.9	66592.0
2015-04-22 08:00:00	QQQ	ETF	107.92	108.24	107.89	108.23	96932.0
2015-04-22 09:00:00	QQQ	ETF	108.25	108.42	107.88	108.0249	2816559.0
2015-04-22 10:00:00	QQQ	ETF	108.03	108.22	107.64	108.198	4008211.0
2015-04-22 11:00:00	QQQ	ETF	108.195	108.38	108.16	108.369	1905052.0
2015-04-22 12:00:00	QQQ	ETF	108.36	108.41	108.21	108.35	912558.0
2015-04-22 13:00:00	QQQ	ETF	108.36	108.54	108.25	108.5	1618264.0
2015-04-22 14:00:00	QQQ	ETF	108.5	108.69	108.461	108.64	1928004.0
2015-04-22 15:00:00	QQQ	ETF	108.64	108.83	108.57	108.65	4098521.0
2015-04-22 16:00:00	QQQ	ETF	108.65	108.65	108.27	108.3	1621360.0
2015-04-22 17:00:00	QQQ	ETF	108.3	108.33	108.22	108.31	225933.0
2015-04-22 18:00:00	QQQ	ETF	108.33	108.45	108.32	108.45	43397.0
2015-04-22 19:00:00	QQQ	ETF	108.47	108.5	108.46	108.46	8219.0
2015-04-22 04:00:00	IWM	ETF	125.19	125.19	125.14	125.14	200.0
2015-04-22 05:00:00	IWM	ETF	124.83	124.83	124.83	124.83	100.0
2015-04-22 06:00:00	IWM	ETF	124.65	124.71	124.4	124.6	4550.0
2015-04-22 07:00:00	IWM	ETF	124.8	124.93	124.7	124.86	53181.0
2015-04-22 08:00:00	IWM	ETF	124.87	125.29	124.81	125.29	132631.0
2015-04-22 09:00:00	IWM	ETF	125.35	125.64	124.909	125.16	2803387.0
2015-04-22 10:00:00	IWM	ETF	125.17	125.36	124.47	125.32	5344390.0
2015-04-22 11:00:00	IWM	ETF	125.32	125.62	125.32	125.52	2019724.0
2015-04-22 12:00:00	IWM	ETF	125.53	125.73	125.385	125.72	1453691.0
2015-04-22 13:00:00	IWM	ETF	125.72	125.82	125.55	125.75	1256839.0
2015-04-22 14:00:00	IWM	ETF	125.74	125.88	125.685	125.7	1411165.0
2015-04-22 15:00:00	IWM	ETF	125.71	125.81	125.6	125.71	2856538.0
2015-04-22 16:00:00	IWM	ETF	125.71	125.77	125.59	125.61	614842.0
2015-04-22 17:00:00	IWM	ETF	125.63	125.65	125.63	125.65	1400.0
2015-04-22 18:00:00	IWM	ETF	125.56	125.56	125.52	125.52	4980.0
2015-04-22 08:00:00	DIA	ETF	178.75	179.2	178.6	179.071	12110.0
2015-04-22 09:00:00	DIA	ETF	179.23	179.88	178.81	179.02	633094.0

> showing 50 of 7,603 rows — these rows as CSV

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