PREVIEW / etf_1hour / 2013-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-14.parquet
  size:    203 KB
  rows:    6,382

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-06-14 04:00:00	SPY	ETF	164.22	164.37	164.17	164.37	17050.0
2013-06-14 05:00:00	SPY	ETF	164.39	164.42	163.94	163.96	170400.0
2013-06-14 06:00:00	SPY	ETF	163.92	164.03	163.83	163.92	61980.0
2013-06-14 07:00:00	SPY	ETF	163.9	164.23	163.9	164.09	361853.0
2013-06-14 08:00:00	SPY	ETF	164.09	164.23	163.87	164.06	789341.0
2013-06-14 09:00:00	SPY	ETF	164.06	164.48	163.89	164.45	12729681.0
2013-06-14 10:00:00	SPY	ETF	164.45	164.67	163.46	163.57	18767568.0
2013-06-14 11:00:00	SPY	ETF	163.57	163.915	163.31	163.67	17784727.0
2013-06-14 12:00:00	SPY	ETF	163.67	163.83	163.35	163.43	11388689.0
2013-06-14 13:00:00	SPY	ETF	163.42	163.42	162.95	163.131	14557636.0
2013-06-14 14:00:00	SPY	ETF	163.11	163.63	162.91	163.2	13876141.0
2013-06-14 15:00:00	SPY	ETF	163.19	163.73	163.03	163.18	25463927.0
2013-06-14 16:00:00	SPY	ETF	163.19	163.5855	162.99	163.0	20122598.0
2013-06-14 17:00:00	SPY	ETF	163.01	163.02	162.95	162.96	375795.0
2013-06-14 18:00:00	SPY	ETF	162.95	163.05	162.7	162.83	132488.0
2013-06-14 19:00:00	SPY	ETF	162.83	162.93	162.82	162.93	46881.0
2013-06-14 04:00:00	QQQ	ETF	72.82	72.82	72.76	72.82	3800.0
2013-06-14 05:00:00	QQQ	ETF	72.84	72.84	72.66	72.66	4400.0
2013-06-14 06:00:00	QQQ	ETF	72.64	72.7	72.57	72.64	5600.0
2013-06-14 07:00:00	QQQ	ETF	72.63	72.74	72.63	72.72	13195.0
2013-06-14 08:00:00	QQQ	ETF	72.73	72.77	72.66	72.76	48606.0
2013-06-14 09:00:00	QQQ	ETF	72.73	72.82	72.6	72.789	2909923.0
2013-06-14 10:00:00	QQQ	ETF	72.79	72.84	72.34	72.39	5460605.0
2013-06-14 11:00:00	QQQ	ETF	72.39	72.4901	72.25	72.41	3639336.0
2013-06-14 12:00:00	QQQ	ETF	72.41	72.61	72.32	72.41	3032825.0
2013-06-14 13:00:00	QQQ	ETF	72.4	72.42	72.18	72.2601	3041674.0
2013-06-14 14:00:00	QQQ	ETF	72.265	72.47	72.171	72.31	3210397.0
2013-06-14 15:00:00	QQQ	ETF	72.31	72.51	72.24	72.29	4377831.0
2013-06-14 16:00:00	QQQ	ETF	72.29	72.759	72.23	72.24	1717386.0
2013-06-14 17:00:00	QQQ	ETF	72.26	72.3	72.21	72.25	15580.0
2013-06-14 18:00:00	QQQ	ETF	72.25	72.27	72.13	72.13	3650.0
2013-06-14 19:00:00	QQQ	ETF	72.24	72.26	72.23	72.25	3446.0
2013-06-14 04:00:00	IWM	ETF	98.68	98.68	98.68	98.68	10000.0
2013-06-14 06:00:00	IWM	ETF	98.29	98.4	98.28	98.3	20484.0
2013-06-14 07:00:00	IWM	ETF	98.35	98.45	98.32	98.4	14120.0
2013-06-14 08:00:00	IWM	ETF	98.36	98.42	98.2	98.35	174173.0
2013-06-14 09:00:00	IWM	ETF	98.37	98.6	98.08	98.58	5402707.0
2013-06-14 10:00:00	IWM	ETF	98.58	98.64	97.9	97.96	6352651.0
2013-06-14 11:00:00	IWM	ETF	97.97	98.24	97.81	98.16	4585638.0
2013-06-14 12:00:00	IWM	ETF	98.16	98.16	97.77	97.84	4140966.0
2013-06-14 13:00:00	IWM	ETF	97.84	97.84	97.42	97.58	4777583.0
2013-06-14 14:00:00	IWM	ETF	97.56	97.99	97.4801	97.71	3118135.0
2013-06-14 15:00:00	IWM	ETF	97.715	97.93	97.6	97.74	6130689.0
2013-06-14 16:00:00	IWM	ETF	97.72	97.9804	97.44	97.58	1187444.0
2013-06-14 17:00:00	IWM	ETF	97.58	97.6	97.55	97.6	3282.0
2013-06-14 18:00:00	IWM	ETF	97.55	97.55	97.51	97.51	7062.0
2013-06-14 19:00:00	IWM	ETF	97.51	97.59	97.51	97.59	500.0
2013-06-14 05:00:00	DIA	ETF	151.75	151.75	151.75	151.75	300.0
2013-06-14 07:00:00	DIA	ETF	151.61	151.82	151.61	151.75	8950.0
2013-06-14 08:00:00	DIA	ETF	151.74	151.74	151.55	151.67	7330.0

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

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