PREVIEW / etf_1hour / 2013-05-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-05-14.parquet
  size:    205 KB
  rows:    6,374

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-14 04:00:00	SPY	ETF	163.32	163.38	163.28	163.28	7270.0
2013-05-14 05:00:00	SPY	ETF	163.29	163.35	163.21	163.32	4900.0
2013-05-14 06:00:00	SPY	ETF	163.3	163.31	163.14	163.22	59892.0
2013-05-14 07:00:00	SPY	ETF	163.22	163.73	163.22	163.7	764413.0
2013-05-14 08:00:00	SPY	ETF	163.7	163.92	163.2	163.65	1968432.0
2013-05-14 09:00:00	SPY	ETF	163.66	164.3	163.57	164.25	17249568.0
2013-05-14 10:00:00	SPY	ETF	164.25	164.99	164.25	164.965	20334808.0
2013-05-14 11:00:00	SPY	ETF	164.969	165.11	164.81	165.03	11617326.0
2013-05-14 12:00:00	SPY	ETF	165.03	165.21	164.93	164.94	7748750.0
2013-05-14 13:00:00	SPY	ETF	164.94	165.14	164.81	164.86	7055374.0
2013-05-14 14:00:00	SPY	ETF	164.86	165.065	164.75	164.76	10766837.0
2013-05-14 15:00:00	SPY	ETF	164.77	165.35	164.73	165.27	19190383.0
2013-05-14 16:00:00	SPY	ETF	165.26	165.33	163.5976	165.27	19168890.0
2013-05-14 17:00:00	SPY	ETF	165.28	165.3	165.23	165.24	270647.0
2013-05-14 18:00:00	SPY	ETF	165.25	165.25	165.14	165.16	173994.0
2013-05-14 19:00:00	SPY	ETF	165.19	165.24	165.16	165.16	42615.0
2013-05-14 04:00:00	QQQ	ETF	73.11	73.11	73.05	73.05	1500.0
2013-05-14 05:00:00	QQQ	ETF	72.96	72.96	72.96	72.96	100.0
2013-05-14 06:00:00	QQQ	ETF	73.01	73.01	72.94	72.96	6200.0
2013-05-14 07:00:00	QQQ	ETF	72.99	73.15	72.99	73.15	39395.0
2013-05-14 08:00:00	QQQ	ETF	73.09	73.25	73.09	73.15	41857.0
2013-05-14 09:00:00	QQQ	ETF	73.16	73.43	73.08	73.38	3091317.0
2013-05-14 10:00:00	QQQ	ETF	73.37	73.67	73.35	73.67	3354907.0
2013-05-14 11:00:00	QQQ	ETF	73.67	73.71	73.59	73.64	5151626.0
2013-05-14 12:00:00	QQQ	ETF	73.63	73.74	73.5	73.51	6616815.0
2013-05-14 13:00:00	QQQ	ETF	73.51	73.65	73.36	73.41	3384196.0
2013-05-14 14:00:00	QQQ	ETF	73.415	73.49	73.29	73.3001	3566222.0
2013-05-14 15:00:00	QQQ	ETF	73.3	73.57	73.26	73.51	3726770.0
2013-05-14 16:00:00	QQQ	ETF	73.52	73.54	73.1726	73.54	2734734.0
2013-05-14 17:00:00	QQQ	ETF	73.56	73.56	73.52	73.52	36400.0
2013-05-14 18:00:00	QQQ	ETF	73.52	73.52	73.5	73.5	3300.0
2013-05-14 19:00:00	QQQ	ETF	73.51	73.51	73.49	73.49	7100.0
2013-05-14 06:00:00	IWM	ETF	96.69	96.69	96.69	96.69	1700.0
2013-05-14 07:00:00	IWM	ETF	96.57	96.94	96.56	96.91	142300.0
2013-05-14 08:00:00	IWM	ETF	96.9	97.05	96.58	96.92	108120.0
2013-05-14 09:00:00	IWM	ETF	96.91	97.44	96.85	97.39	3679223.0
2013-05-14 10:00:00	IWM	ETF	97.395	97.82	97.34	97.79	6087291.0
2013-05-14 11:00:00	IWM	ETF	97.79	97.94	97.74	97.915	2742077.0
2013-05-14 12:00:00	IWM	ETF	97.91	97.98	97.79	97.8	2430911.0
2013-05-14 13:00:00	IWM	ETF	97.79	97.875	97.61	97.66	2190647.0
2013-05-14 14:00:00	IWM	ETF	97.66	97.77	97.58	97.645	2867881.0
2013-05-14 15:00:00	IWM	ETF	97.63	98.03	97.595	98.0	6410608.0
2013-05-14 16:00:00	IWM	ETF	98.01	98.03	96.7923	97.97	3991847.0
2013-05-14 17:00:00	IWM	ETF	98.0	98.01	97.92	97.92	296470.0
2013-05-14 18:00:00	IWM	ETF	97.93	97.94	97.93	97.93	13800.0
2013-05-14 19:00:00	IWM	ETF	97.96	97.96	97.93	97.93	1200.0
2013-05-14 08:00:00	DIA	ETF	150.99	151.04	150.86	150.91	87913.0
2013-05-14 09:00:00	DIA	ETF	150.88	151.3	150.84	151.26	687621.0
2013-05-14 10:00:00	DIA	ETF	151.29	151.79	151.24	151.774	1027287.0
2013-05-14 11:00:00	DIA	ETF	151.78	151.805	151.6	151.72	739838.0

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

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