PREVIEW / etf_1hour / 2013-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-06-12.parquet
  size:    208 KB
  rows:    6,440

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-12 04:00:00	SPY	ETF	163.92	164.05	163.7	163.9	69600.0
2013-06-12 05:00:00	SPY	ETF	163.88	164.11	163.88	163.9	128600.0
2013-06-12 06:00:00	SPY	ETF	163.94	164.27	163.94	164.2	80901.0
2013-06-12 07:00:00	SPY	ETF	164.2	164.22	164.0	164.18	408296.0
2013-06-12 08:00:00	SPY	ETF	164.18	164.21	163.92	164.14	773895.0
2013-06-12 09:00:00	SPY	ETF	164.12	164.39	163.73	163.82	14622668.0
2013-06-12 10:00:00	SPY	ETF	163.83	163.83	162.96	163.05	24935247.0
2013-06-12 11:00:00	SPY	ETF	163.04	163.25	162.21	162.379	23396015.0
2013-06-12 12:00:00	SPY	ETF	162.38	162.54	161.98	162.49	19901564.0
2013-06-12 13:00:00	SPY	ETF	162.5	162.8	162.23	162.599	12685824.0
2013-06-12 14:00:00	SPY	ETF	162.598	162.62	161.8	162.03	21206383.0
2013-06-12 15:00:00	SPY	ETF	162.02	162.1	161.6	161.77	36804987.0
2013-06-12 16:00:00	SPY	ETF	161.77	163.1717	161.54	161.68	16519361.0
2013-06-12 17:00:00	SPY	ETF	161.68	161.69	161.59	161.66	284380.0
2013-06-12 18:00:00	SPY	ETF	161.66	161.76	161.59	161.6	265172.0
2013-06-12 19:00:00	SPY	ETF	161.58	161.69	161.56	161.63	137622.0
2013-06-12 04:00:00	QQQ	ETF	73.02	73.05	72.88	73.04	11300.0
2013-06-12 05:00:00	QQQ	ETF	73.06	73.14	72.98	72.98	9700.0
2013-06-12 06:00:00	QQQ	ETF	72.99	73.12	72.99	73.1	8791.0
2013-06-12 07:00:00	QQQ	ETF	73.11	73.12	73.04	73.1	15250.0
2013-06-12 08:00:00	QQQ	ETF	73.08	73.12	72.99	73.07	54226.0
2013-06-12 09:00:00	QQQ	ETF	73.08	73.16	72.78	72.8	4248713.0
2013-06-12 10:00:00	QQQ	ETF	72.81	72.82	72.48	72.5	7391316.0
2013-06-12 11:00:00	QQQ	ETF	72.51	72.62	72.14	72.201	6720185.0
2013-06-12 12:00:00	QQQ	ETF	72.21	72.2655	71.99	72.25	5571335.0
2013-06-12 13:00:00	QQQ	ETF	72.26	72.38	72.16	72.28	2838436.0
2013-06-12 14:00:00	QQQ	ETF	72.28	72.28	71.925	71.9801	3374299.0
2013-06-12 15:00:00	QQQ	ETF	71.99	71.99	71.74	71.86	6753338.0
2013-06-12 16:00:00	QQQ	ETF	71.85	72.781	71.7	72.6832	5015215.0
2013-06-12 17:00:00	QQQ	ETF	71.76	71.79	71.74	71.79	34080.0
2013-06-12 18:00:00	QQQ	ETF	71.78	71.79	71.75	71.77	1973.0
2013-06-12 19:00:00	QQQ	ETF	71.75	71.79	71.75	71.78	22370.0
2013-06-12 06:00:00	IWM	ETF	97.98	98.37	97.98	98.34	10300.0
2013-06-12 07:00:00	IWM	ETF	98.37	98.38	98.25	98.38	30522.0
2013-06-12 08:00:00	IWM	ETF	98.34	98.41	98.12	98.25	116520.0
2013-06-12 09:00:00	IWM	ETF	98.28	98.48	97.88	98.09	4487187.0
2013-06-12 10:00:00	IWM	ETF	98.09	98.1	97.51	97.6	10850736.0
2013-06-12 11:00:00	IWM	ETF	97.61	97.69	97.08	97.19	6261176.0
2013-06-12 12:00:00	IWM	ETF	97.19	97.31	96.84	97.22	7386765.0
2013-06-12 13:00:00	IWM	ETF	97.21	97.48	97.12	97.35	4081118.0
2013-06-12 14:00:00	IWM	ETF	97.35	97.37	96.85	96.95	4775386.0
2013-06-12 15:00:00	IWM	ETF	96.94	96.95	96.625	96.78	8968481.0
2013-06-12 16:00:00	IWM	ETF	96.77	97.6799	96.53	96.67	6564969.0
2013-06-12 17:00:00	IWM	ETF	96.62	96.62	96.58	96.58	27124.0
2013-06-12 18:00:00	IWM	ETF	96.67	96.7	96.67	96.7	3500.0
2013-06-12 19:00:00	IWM	ETF	96.6	96.74	96.6	96.67	2854.0
2013-06-12 05:00:00	DIA	ETF	151.94	151.94	151.94	151.94	100.0
2013-06-12 07:00:00	DIA	ETF	152.14	152.14	152.08	152.08	430.0
2013-06-12 08:00:00	DIA	ETF	152.06	152.06	151.95	152.02	3492.0
2013-06-12 09:00:00	DIA	ETF	152.07	152.35	151.68	151.76	734023.0

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

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