PREVIEW / etf_1hour / 2013-01-02

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-02.parquet
  size:    212 KB
  rows:    6,695

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-01-02 04:00:00	SPY	ETF	142.83	143.69	142.83	143.69	33905.0
2013-01-02 05:00:00	SPY	ETF	143.65	144.1	143.51	144.1	29961.0
2013-01-02 06:00:00	SPY	ETF	144.22	144.95	143.97	144.32	578031.0
2013-01-02 07:00:00	SPY	ETF	144.32	144.94	144.32	144.73	957027.0
2013-01-02 08:00:00	SPY	ETF	144.72	145.09	144.4	144.9	2534476.0
2013-01-02 09:00:00	SPY	ETF	144.91	145.58	144.73	145.45	36793246.0
2013-01-02 10:00:00	SPY	ETF	145.46	145.59	144.97	145.08	27818473.0
2013-01-02 11:00:00	SPY	ETF	145.08	145.17	144.74	144.785	16008951.0
2013-01-02 12:00:00	SPY	ETF	144.799	145.05	144.73	144.835	13158354.0
2013-01-02 13:00:00	SPY	ETF	144.835	145.02	144.81	144.905	10879904.0
2013-01-02 14:00:00	SPY	ETF	144.91	145.14	144.85	145.06	13168575.0
2013-01-02 15:00:00	SPY	ETF	145.07	146.11	145.06	146.09	41879624.0
2013-01-02 16:00:00	SPY	ETF	146.08	146.15	142.4251	146.05	15297715.0
2013-01-02 17:00:00	SPY	ETF	146.05	146.08	145.91	145.92	5807102.0
2013-01-02 18:00:00	SPY	ETF	145.91	145.92	145.75	145.76	278675.0
2013-01-02 19:00:00	SPY	ETF	145.8	145.8	145.72	145.73	80392.0
2013-01-02 04:00:00	QQQ	ETF	65.5	65.5	65.5	65.5	913.0
2013-01-02 05:00:00	QQQ	ETF	65.8	65.99	65.8	65.99	2112.0
2013-01-02 06:00:00	QQQ	ETF	66.1	66.28	66.1	66.11	4175.0
2013-01-02 07:00:00	QQQ	ETF	66.11	66.47	66.1	66.4	503428.0
2013-01-02 08:00:00	QQQ	ETF	66.39	66.6	66.12	66.54	2959884.0
2013-01-02 09:00:00	QQQ	ETF	66.55	67.0985	66.51	66.9781	20161490.0
2013-01-02 10:00:00	QQQ	ETF	66.98	66.99	66.63	66.69	7035447.0
2013-01-02 11:00:00	QQQ	ETF	66.69	66.73	66.5	66.54	5524069.0
2013-01-02 12:00:00	QQQ	ETF	66.535	66.67	66.48	66.61	3800297.0
2013-01-02 13:00:00	QQQ	ETF	66.61	66.74	66.57	66.62	2456703.0
2013-01-02 14:00:00	QQQ	ETF	66.6155	66.79	66.59	66.76	2818539.0
2013-01-02 15:00:00	QQQ	ETF	66.77	67.23	66.77	67.21	11259000.0
2013-01-02 16:00:00	QQQ	ETF	67.21	67.23	65.1251	67.19	9928291.0
2013-01-02 17:00:00	QQQ	ETF	67.2	67.22	67.12	67.14	12150.0
2013-01-02 18:00:00	QQQ	ETF	67.14	67.2	67.12	67.12	34750.0
2013-01-02 19:00:00	QQQ	ETF	67.12	67.12	67.09	67.12	68760.0
2013-01-02 06:00:00	IWM	ETF	85.48	85.94	85.48	85.94	7650.0
2013-01-02 07:00:00	IWM	ETF	85.77	86.05	85.77	85.97	162593.0
2013-01-02 08:00:00	IWM	ETF	85.96	86.44	85.9	86.3	812661.0
2013-01-02 09:00:00	IWM	ETF	86.31	86.57	86.04	86.5	13617027.0
2013-01-02 10:00:00	IWM	ETF	86.51	86.61	86.23	86.318	11463042.0
2013-01-02 11:00:00	IWM	ETF	86.31	86.47	86.22	86.3025	8708694.0
2013-01-02 12:00:00	IWM	ETF	86.2965	86.43	86.215	86.23	5935487.0
2013-01-02 13:00:00	IWM	ETF	86.235	86.56	86.23	86.52	8856007.0
2013-01-02 14:00:00	IWM	ETF	86.52	86.62	86.13	86.2301	8051523.0
2013-01-02 15:00:00	IWM	ETF	86.24	86.83	86.238	86.83	17807742.0
2013-01-02 16:00:00	IWM	ETF	86.82	86.93	84.2851	86.87	9703538.0
2013-01-02 17:00:00	IWM	ETF	86.89	86.91	86.81	86.84	22200.0
2013-01-02 18:00:00	IWM	ETF	86.86	86.92	86.69	86.69	18065.0
2013-01-02 19:00:00	IWM	ETF	86.9	86.9	86.72	86.72	999.0
2013-01-02 04:00:00	DIA	ETF	131.5	131.5	131.5	131.5	465.0
2013-01-02 05:00:00	DIA	ETF	131.9	132.2	131.9	132.2	1100.0
2013-01-02 06:00:00	DIA	ETF	132.19	132.65	132.19	132.24	1900.0
2013-01-02 07:00:00	DIA	ETF	132.4	132.7	132.38	132.58	15850.0

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

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