PREVIEW / etf_1hour / 2013-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-01-07.parquet
  size:    199 KB
  rows:    6,275

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-07 04:00:00	SPY	ETF	146.03	146.03	145.9	145.92	6608.0
2013-01-07 05:00:00	SPY	ETF	145.94	145.96	145.94	145.96	28550.0
2013-01-07 06:00:00	SPY	ETF	145.96	145.98	145.87	145.91	204199.0
2013-01-07 07:00:00	SPY	ETF	145.88	146.04	145.88	145.96	215259.0
2013-01-07 08:00:00	SPY	ETF	145.99	146.02	145.83	145.85	463343.0
2013-01-07 09:00:00	SPY	ETF	145.85	145.89	145.59	145.75	14676438.0
2013-01-07 10:00:00	SPY	ETF	145.75	145.98	145.725	145.811	12527879.0
2013-01-07 11:00:00	SPY	ETF	145.81	145.91	145.54	145.58	9508396.0
2013-01-07 12:00:00	SPY	ETF	145.57	145.62	145.43	145.5399	11241199.0
2013-01-07 13:00:00	SPY	ETF	145.54	145.68	145.48	145.59	9628338.0
2013-01-07 14:00:00	SPY	ETF	145.59	145.88	145.58	145.87	8397974.0
2013-01-07 15:00:00	SPY	ETF	145.87	146.4442	145.8	145.965	17370340.0
2013-01-07 16:00:00	SPY	ETF	145.97	146.4442	145.6184	145.99	20181600.0
2013-01-07 17:00:00	SPY	ETF	145.97	146.01	145.95	145.99	1078507.0
2013-01-07 18:00:00	SPY	ETF	146.0	146.01	145.93	145.93	76208.0
2013-01-07 19:00:00	SPY	ETF	145.92	146.0	145.87	146.0	63018.0
2013-01-07 04:00:00	QQQ	ETF	66.51	66.51	66.48	66.48	663.0
2013-01-07 05:00:00	QQQ	ETF	66.5	66.5	66.5	66.5	600.0
2013-01-07 07:00:00	QQQ	ETF	66.46	66.55	66.42	66.42	15000.0
2013-01-07 08:00:00	QQQ	ETF	66.45	66.47	66.36	66.4	139285.0
2013-01-07 09:00:00	QQQ	ETF	66.39	66.46	66.25	66.3399	4424166.0
2013-01-07 10:00:00	QQQ	ETF	66.33	66.66	66.32	66.54	3732393.0
2013-01-07 11:00:00	QQQ	ETF	66.53	66.71	66.43	66.45	3652023.0
2013-01-07 12:00:00	QQQ	ETF	66.44	66.51	66.37	66.42	1860899.0
2013-01-07 13:00:00	QQQ	ETF	66.43	66.5399	66.35	66.43	1368975.0
2013-01-07 14:00:00	QQQ	ETF	66.42	66.6	66.42	66.57	1771758.0
2013-01-07 15:00:00	QQQ	ETF	66.57	66.76	66.52	66.66	4058633.0
2013-01-07 16:00:00	QQQ	ETF	66.66	66.72	66.6175	66.65	3725775.0
2013-01-07 17:00:00	QQQ	ETF	66.64	66.65	66.64	66.64	3718.0
2013-01-07 18:00:00	QQQ	ETF	66.64	66.65	66.64	66.65	6800.0
2013-01-07 19:00:00	QQQ	ETF	66.62	66.64	66.6	66.63	9350.0
2013-01-07 05:00:00	IWM	ETF	86.95	86.95	86.9	86.9	500.0
2013-01-07 06:00:00	IWM	ETF	86.9	86.9	86.85	86.85	1400.0
2013-01-07 07:00:00	IWM	ETF	86.85	86.86	86.81	86.83	37600.0
2013-01-07 08:00:00	IWM	ETF	86.84	86.92	86.78	86.81	265558.0
2013-01-07 09:00:00	IWM	ETF	86.8	86.98	86.68	86.87	5279426.0
2013-01-07 10:00:00	IWM	ETF	86.87	87.07	86.8	86.86	3275097.0
2013-01-07 11:00:00	IWM	ETF	86.87	86.89	86.7	86.74	2008477.0
2013-01-07 12:00:00	IWM	ETF	86.74	86.83	86.69	86.78	1359560.0
2013-01-07 13:00:00	IWM	ETF	86.78	86.85	86.62	86.71	1425400.0
2013-01-07 14:00:00	IWM	ETF	86.709	86.87	86.68	86.85	1344978.0
2013-01-07 15:00:00	IWM	ETF	86.85	87.07	86.82	86.88	5396285.0
2013-01-07 16:00:00	IWM	ETF	86.89	87.04	86.88	87.01	2388002.0
2013-01-07 17:00:00	IWM	ETF	87.07	87.07	87.07	87.07	298.0
2013-01-07 18:00:00	IWM	ETF	87.02	87.02	87.0	87.0	500.0
2013-01-07 19:00:00	IWM	ETF	86.97	87.0	86.97	87.0	600.0
2013-01-07 04:00:00	DIA	ETF	134.06	134.06	134.06	134.06	100.0
2013-01-07 07:00:00	DIA	ETF	133.74	133.74	133.71	133.71	2200.0
2013-01-07 08:00:00	DIA	ETF	133.85	133.85	133.67	133.71	78450.0
2013-01-07 09:00:00	DIA	ETF	133.67	133.71	133.3	133.41	1725827.0

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

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