PREVIEW / etf_1hour / 2013-06-03

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-03.parquet
  size:    211 KB
  rows:    6,594

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-03 04:00:00	SPY	ETF	163.67	163.67	163.27	163.49	68300.0
2013-06-03 05:00:00	SPY	ETF	163.48	163.9	163.45	163.84	133450.0
2013-06-03 06:00:00	SPY	ETF	163.84	164.17	163.75	164.17	161243.0
2013-06-03 07:00:00	SPY	ETF	164.175	164.38	164.09	164.15	1101899.0
2013-06-03 08:00:00	SPY	ETF	164.14	164.37	163.31	163.93	1654560.0
2013-06-03 09:00:00	SPY	ETF	163.92	163.99	163.22	163.27	23873129.0
2013-06-03 10:00:00	SPY	ETF	163.42	164.17	162.88	163.36	39874070.0
2013-06-03 11:00:00	SPY	ETF	163.35	163.42	162.6599	163.118	22390411.0
2013-06-03 12:00:00	SPY	ETF	163.12	163.37	162.86	163.23	12395656.0
2013-06-03 13:00:00	SPY	ETF	163.23	163.49	163.07	163.3613	10103206.0
2013-06-03 14:00:00	SPY	ETF	163.3699	163.93	163.27	163.71	13752038.0
2013-06-03 15:00:00	SPY	ETF	163.71	164.46	163.61	164.38	25688610.0
2013-06-03 16:00:00	SPY	ETF	164.34	164.4456	163.4787	164.21	10401936.0
2013-06-03 17:00:00	SPY	ETF	164.18	164.2	163.5133	164.14	141154.0
2013-06-03 18:00:00	SPY	ETF	164.13	164.19	163.71	163.82	247363.0
2013-06-03 19:00:00	SPY	ETF	163.82	164.06	163.82	164.0	180594.0
2013-06-03 04:00:00	QQQ	ETF	73.17	73.17	73.0	73.11	18425.0
2013-06-03 05:00:00	QQQ	ETF	73.08	73.3	73.08	73.26	9470.0
2013-06-03 06:00:00	QQQ	ETF	73.29	73.41	73.23	73.41	16159.0
2013-06-03 07:00:00	QQQ	ETF	73.42	73.5	73.41	73.44	501369.0
2013-06-03 08:00:00	QQQ	ETF	73.43	73.46	73.27	73.34	194628.0
2013-06-03 09:00:00	QQQ	ETF	73.325	73.35	72.9	73.11	6268173.0
2013-06-03 10:00:00	QQQ	ETF	73.07	73.31	72.77	72.86	9342694.0
2013-06-03 11:00:00	QQQ	ETF	72.86	72.9	72.43	72.63	6039149.0
2013-06-03 12:00:00	QQQ	ETF	72.62	72.76	72.475	72.75	2875569.0
2013-06-03 13:00:00	QQQ	ETF	72.74	72.84	72.67	72.8	2719089.0
2013-06-03 14:00:00	QQQ	ETF	72.79	73.04	72.76	72.96	3728482.0
2013-06-03 15:00:00	QQQ	ETF	72.96	73.4	72.95	73.38	9536009.0
2013-06-03 16:00:00	QQQ	ETF	73.39	73.4	72.6465	73.36	3446387.0
2013-06-03 17:00:00	QQQ	ETF	73.36	73.38	73.34	73.34	10020.0
2013-06-03 18:00:00	QQQ	ETF	73.34	73.34	73.14	73.2	31506.0
2013-06-03 19:00:00	QQQ	ETF	73.21	73.32	73.21	73.32	16791.0
2013-06-03 05:00:00	IWM	ETF	97.98	97.98	97.98	97.98	10000.0
2013-06-03 06:00:00	IWM	ETF	98.02	98.25	98.02	98.25	4600.0
2013-06-03 07:00:00	IWM	ETF	98.28	98.55	98.26	98.38	157897.0
2013-06-03 08:00:00	IWM	ETF	98.37	98.48	98.13	98.17	154312.0
2013-06-03 09:00:00	IWM	ETF	98.17	98.41	97.73	97.98	7075293.0
2013-06-03 10:00:00	IWM	ETF	97.99	98.84	97.5	97.86	15638263.0
2013-06-03 11:00:00	IWM	ETF	97.86	97.88	97.03	97.45	8368643.0
2013-06-03 12:00:00	IWM	ETF	97.45	97.68	97.12	97.29	5391297.0
2013-06-03 13:00:00	IWM	ETF	97.28	97.71	97.1521	97.66	6169060.0
2013-06-03 14:00:00	IWM	ETF	97.66	98.11	97.55	97.94	6761763.0
2013-06-03 15:00:00	IWM	ETF	97.95	98.72	97.895	98.66	15098017.0
2013-06-03 16:00:00	IWM	ETF	98.66	98.73	97.8865	98.58	6803307.0
2013-06-03 17:00:00	IWM	ETF	98.58	98.59	98.58	98.59	2650.0
2013-06-03 18:00:00	IWM	ETF	98.58	98.6	98.4	98.45	14544.0
2013-06-03 19:00:00	IWM	ETF	98.46	98.52	98.44	98.52	963.0
2013-06-03 06:00:00	DIA	ETF	151.63	151.63	151.63	151.63	3000.0
2013-06-03 07:00:00	DIA	ETF	151.7	151.85	151.69	151.69	9375.0
2013-06-03 08:00:00	DIA	ETF	151.72	151.75	151.55	151.6	29021.0

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

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