PREVIEW / etf_1hour / 2013-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-23.parquet
  size:    212 KB
  rows:    6,654

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
2013-05-23 04:00:00	SPY	ETF	164.85	164.85	163.81	164.04	159115.0
2013-05-23 05:00:00	SPY	ETF	164.04	164.35	164.04	164.16	125157.0
2013-05-23 06:00:00	SPY	ETF	164.09	164.82	164.04	164.79	392414.0
2013-05-23 07:00:00	SPY	ETF	164.79	165.0	164.36	164.42	1257242.0
2013-05-23 08:00:00	SPY	ETF	164.42	164.95	163.74	164.51	4009000.0
2013-05-23 09:00:00	SPY	ETF	164.51	164.72	164.03	164.17	31789159.0
2013-05-23 10:00:00	SPY	ETF	164.17	165.04	163.94	164.5201	40536261.0
2013-05-23 11:00:00	SPY	ETF	164.53	165.8623	164.52	165.2899	24669231.0
2013-05-23 12:00:00	SPY	ETF	165.29	165.76	165.14	165.292	18006345.0
2013-05-23 13:00:00	SPY	ETF	165.295	165.8624	164.81	165.37	18391225.0
2013-05-23 14:00:00	SPY	ETF	165.38	165.91	165.21	165.65	23829439.0
2013-05-23 15:00:00	SPY	ETF	165.66	165.81	165.19	165.43	31105986.0
2013-05-23 16:00:00	SPY	ETF	165.45	165.8623	164.9711	165.63	9385520.0
2013-05-23 17:00:00	SPY	ETF	165.62	165.67	165.57	165.64	211881.0
2013-05-23 18:00:00	SPY	ETF	165.63	165.75	165.58	165.74	120187.0
2013-05-23 19:00:00	SPY	ETF	165.71	165.88	165.66	165.83	143096.0
2013-05-23 04:00:00	QQQ	ETF	72.97	73.03	72.71	72.86	19001.0
2013-05-23 05:00:00	QQQ	ETF	72.74	72.89	72.74	72.88	42600.0
2013-05-23 06:00:00	QQQ	ETF	72.81	73.1	72.8	73.1	41000.0
2013-05-23 07:00:00	QQQ	ETF	73.07	73.13	72.94	72.98	116850.0
2013-05-23 08:00:00	QQQ	ETF	72.98	73.22	72.78	73.13	820794.0
2013-05-23 09:00:00	QQQ	ETF	73.13	73.21	72.83	72.929	8934352.0
2013-05-23 10:00:00	QQQ	ETF	72.93	73.5	72.84	73.2	11451324.0
2013-05-23 11:00:00	QQQ	ETF	73.2	73.58	73.1937	73.473	3913838.0
2013-05-23 12:00:00	QQQ	ETF	73.47	73.63	73.38	73.47	2627016.0
2013-05-23 13:00:00	QQQ	ETF	73.48	73.52	73.23	73.45	2606070.0
2013-05-23 14:00:00	QQQ	ETF	73.44	73.7	73.39	73.59	4091030.0
2013-05-23 15:00:00	QQQ	ETF	73.595	73.63	73.38	73.42	4870903.0
2013-05-23 16:00:00	QQQ	ETF	73.43	73.6029	73.4154	73.53	1762256.0
2013-05-23 17:00:00	QQQ	ETF	73.57	73.57	73.56	73.56	6250.0
2013-05-23 18:00:00	QQQ	ETF	73.54	73.57	73.52	73.55	7539.0
2013-05-23 19:00:00	QQQ	ETF	73.56	73.65	73.56	73.63	3860.0
2013-05-23 04:00:00	IWM	ETF	97.11	97.11	96.54	96.54	2477.0
2013-05-23 05:00:00	IWM	ETF	96.66	96.69	96.65	96.65	60670.0
2013-05-23 06:00:00	IWM	ETF	96.6	96.99	96.5	96.93	43300.0
2013-05-23 07:00:00	IWM	ETF	96.92	97.09	96.71	96.75	360653.0
2013-05-23 08:00:00	IWM	ETF	96.77	97.1	96.71	96.86	386687.0
2013-05-23 09:00:00	IWM	ETF	96.87	97.03	96.51	96.64	9354257.0
2013-05-23 10:00:00	IWM	ETF	96.65	97.36	96.555	96.9	8401758.0
2013-05-23 11:00:00	IWM	ETF	96.91	97.54	96.91	97.45	3874639.0
2013-05-23 12:00:00	IWM	ETF	97.45	97.83	97.4299	97.54	3564982.0
2013-05-23 13:00:00	IWM	ETF	97.54	97.74	97.35	97.72	2995425.0
2013-05-23 14:00:00	IWM	ETF	97.72	97.935	97.58	97.76	4149030.0
2013-05-23 15:00:00	IWM	ETF	97.77	97.91	97.605	97.88	6490650.0
2013-05-23 16:00:00	IWM	ETF	97.88	98.02	97.1866	98.0	598285.0
2013-05-23 17:00:00	IWM	ETF	98.0	98.0	98.0	98.0	1000.0
2013-05-23 18:00:00	IWM	ETF	98.0	98.0	98.0	98.0	345.0
2013-05-23 19:00:00	IWM	ETF	97.92	98.03	97.92	98.03	2300.0
2013-05-23 04:00:00	DIA	ETF	151.65	151.65	151.45	151.45	200.0
2013-05-23 05:00:00	DIA	ETF	151.7	151.7	151.7	151.7	200.0

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

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