PREVIEW / etf_1hour / 2014-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-15.parquet
  size:    220 KB
  rows:    6,886

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
2014-04-15 04:00:00	SPY	ETF	183.04	183.04	182.82	182.87	20100.0
2014-04-15 05:00:00	SPY	ETF	182.92	183.01	182.78	182.94	67274.0
2014-04-15 06:00:00	SPY	ETF	182.94	183.2	182.93	183.11	108396.0
2014-04-15 07:00:00	SPY	ETF	183.07	183.48	183.05	183.45	247177.0
2014-04-15 08:00:00	SPY	ETF	183.45	183.69	183.11	183.4	938661.0
2014-04-15 09:00:00	SPY	ETF	183.38	184.29	183.15	184.1	16927742.0
2014-04-15 10:00:00	SPY	ETF	184.095	184.25	182.58	182.76	29526025.0
2014-04-15 11:00:00	SPY	ETF	182.76	183.16	182.04	182.2499	24017542.0
2014-04-15 12:00:00	SPY	ETF	182.25	182.25	181.62	181.67	16109243.0
2014-04-15 13:00:00	SPY	ETF	181.66	183.0	181.51	182.93	16503390.0
2014-04-15 14:00:00	SPY	ETF	182.94	184.05	182.88	183.73	20820733.0
2014-04-15 15:00:00	SPY	ETF	183.7299	184.33	183.49	184.23	24324897.0
2014-04-15 16:00:00	SPY	ETF	184.24	184.87	182.9698	184.86	6213287.0
2014-04-15 17:00:00	SPY	ETF	184.85	184.94	184.76	184.78	242296.0
2014-04-15 18:00:00	SPY	ETF	184.79	184.85	184.68	184.69	88399.0
2014-04-15 19:00:00	SPY	ETF	184.67	184.71	184.66	184.66	94960.0
2014-04-15 04:00:00	QQQ	ETF	84.88	84.88	84.77	84.77	6000.0
2014-04-15 05:00:00	QQQ	ETF	84.76	84.84	84.74	84.83	55100.0
2014-04-15 06:00:00	QQQ	ETF	84.85	85.01	84.83	84.98	126464.0
2014-04-15 07:00:00	QQQ	ETF	84.95	85.14	84.93	85.14	53718.0
2014-04-15 08:00:00	QQQ	ETF	85.12	85.2	84.97	85.11	316205.0
2014-04-15 09:00:00	QQQ	ETF	85.12	85.54	84.9	85.24	7675079.0
2014-04-15 10:00:00	QQQ	ETF	85.23	85.4	84.03	84.13	13342669.0
2014-04-15 11:00:00	QQQ	ETF	84.12	84.38	83.67	83.79	11710877.0
2014-04-15 12:00:00	QQQ	ETF	83.77	83.86	83.31	83.34	11267624.0
2014-04-15 13:00:00	QQQ	ETF	83.33	84.3	83.28	84.23	9986896.0
2014-04-15 14:00:00	QQQ	ETF	84.24	85.06	84.19	84.84	10307692.0
2014-04-15 15:00:00	QQQ	ETF	84.8443	85.25	84.63	85.05	11754536.0
2014-04-15 16:00:00	QQQ	ETF	85.06	85.65	83.4631	85.58	2513306.0
2014-04-15 17:00:00	QQQ	ETF	85.59	85.63	85.53	85.53	76876.0
2014-04-15 18:00:00	QQQ	ETF	85.55	85.55	85.5	85.5	30009.0
2014-04-15 19:00:00	QQQ	ETF	85.51	85.53	85.49	85.5	13887.0
2014-04-15 06:00:00	IWM	ETF	110.8	110.8	110.73	110.73	400.0
2014-04-15 07:00:00	IWM	ETF	110.99	111.3	110.99	111.3	114030.0
2014-04-15 08:00:00	IWM	ETF	111.3	111.44	111.16	111.31	265151.0
2014-04-15 09:00:00	IWM	ETF	111.33	111.72	110.7	111.46	9231595.0
2014-04-15 10:00:00	IWM	ETF	111.45	111.64	109.44	109.82	15052126.0
2014-04-15 11:00:00	IWM	ETF	109.82	110.18	109.29	109.47	10245072.0
2014-04-15 12:00:00	IWM	ETF	109.46	109.47	108.8	108.82	5762322.0
2014-04-15 13:00:00	IWM	ETF	108.82	110.18	108.66	110.12	8657845.0
2014-04-15 14:00:00	IWM	ETF	110.12	111.07	110.0	110.74	7926148.0
2014-04-15 15:00:00	IWM	ETF	110.75	111.565	110.5	111.17	10160650.0
2014-04-15 16:00:00	IWM	ETF	111.17	111.59	109.2481	111.56	1211229.0
2014-04-15 17:00:00	IWM	ETF	111.56	111.71	111.51	111.51	103787.0
2014-04-15 18:00:00	IWM	ETF	111.51	111.51	111.51	111.51	700.0
2014-04-15 19:00:00	IWM	ETF	111.42	111.43	111.42	111.42	1541.0
2014-04-15 06:00:00	DIA	ETF	161.55	161.55	161.5	161.5	300.0
2014-04-15 07:00:00	DIA	ETF	161.59	161.75	161.59	161.75	7250.0
2014-04-15 08:00:00	DIA	ETF	162.04	162.04	161.66	161.7	2600.0
2014-04-15 09:00:00	DIA	ETF	161.74	162.47	161.539	162.34	774104.0

> showing 50 of 6,886 rows — these rows as CSV

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