PREVIEW / etf_1hour / 2013-09-25

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-25.parquet
  size:    202 KB
  rows:    6,340

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-09-25 04:00:00	SPY	ETF	169.33	169.55	169.13	169.51	10960.0
2013-09-25 05:00:00	SPY	ETF	169.55	169.75	169.55	169.67	5900.0
2013-09-25 06:00:00	SPY	ETF	169.61	169.61	169.33	169.38	42700.0
2013-09-25 07:00:00	SPY	ETF	169.37	169.49	169.28	169.49	222989.0
2013-09-25 08:00:00	SPY	ETF	169.35	169.77	169.35	169.68	783878.0
2013-09-25 09:00:00	SPY	ETF	169.69	169.79	169.03	169.31	13059819.0
2013-09-25 10:00:00	SPY	ETF	169.31	169.59	168.89	169.39	18331078.0
2013-09-25 11:00:00	SPY	ETF	169.39	169.93	169.25	169.83	12124989.0
2013-09-25 12:00:00	SPY	ETF	169.825	169.98	169.35	169.61	11323173.0
2013-09-25 13:00:00	SPY	ETF	169.62	169.75	168.9	169.23	16980771.0
2013-09-25 14:00:00	SPY	ETF	169.23	169.38	169.04	169.18	11418239.0
2013-09-25 15:00:00	SPY	ETF	169.18	169.53	169.03	169.08	16944810.0
2013-09-25 16:00:00	SPY	ETF	169.07	169.3197	168.98	169.1	6686196.0
2013-09-25 17:00:00	SPY	ETF	169.06	169.3023	169.06	169.09	57730.0
2013-09-25 18:00:00	SPY	ETF	169.1	169.23	169.1	169.19	44140.0
2013-09-25 19:00:00	SPY	ETF	169.19	169.23	169.15	169.19	67215.0
2013-09-25 04:00:00	QQQ	ETF	78.67	78.82	78.65	78.82	19100.0
2013-09-25 05:00:00	QQQ	ETF	78.86	78.96	78.86	78.92	15700.0
2013-09-25 06:00:00	QQQ	ETF	78.9	78.9	78.76	78.76	22800.0
2013-09-25 07:00:00	QQQ	ETF	78.75	78.8	78.72	78.8	18100.0
2013-09-25 08:00:00	QQQ	ETF	78.82	78.95	78.76	78.9	255450.0
2013-09-25 09:00:00	QQQ	ETF	78.92	78.94	78.55	78.58	2729812.0
2013-09-25 10:00:00	QQQ	ETF	78.58	78.8401	78.4	78.7195	4740283.0
2013-09-25 11:00:00	QQQ	ETF	78.72	78.9799	78.62	78.93	2109385.0
2013-09-25 12:00:00	QQQ	ETF	78.93	79.0	78.71	78.84	1925664.0
2013-09-25 13:00:00	QQQ	ETF	78.86	78.93	78.48	78.65	2531304.0
2013-09-25 14:00:00	QQQ	ETF	78.655	78.701	78.5468	78.59	2366239.0
2013-09-25 15:00:00	QQQ	ETF	78.6	78.77	78.55	78.57	3002937.0
2013-09-25 16:00:00	QQQ	ETF	78.58	78.7974	78.52	78.56	2122431.0
2013-09-25 17:00:00	QQQ	ETF	78.57	78.7308	78.54	78.54	356806.0
2013-09-25 18:00:00	QQQ	ETF	78.59	78.64	78.59	78.63	16210.0
2013-09-25 19:00:00	QQQ	ETF	78.62	78.63	78.6	78.61	6545.0
2013-09-25 04:00:00	IWM	ETF	106.41	106.66	106.41	106.66	20200.0
2013-09-25 05:00:00	IWM	ETF	106.68	106.68	106.68	106.68	5000.0
2013-09-25 07:00:00	IWM	ETF	106.6	106.62	106.52	106.62	10210.0
2013-09-25 08:00:00	IWM	ETF	106.64	106.86	106.6	106.8	196646.0
2013-09-25 09:00:00	IWM	ETF	106.79	106.9	106.33	106.64	2669485.0
2013-09-25 10:00:00	IWM	ETF	106.62	106.99	106.46	106.87	6014422.0
2013-09-25 11:00:00	IWM	ETF	106.87	107.48	106.67	107.43	5812884.0
2013-09-25 12:00:00	IWM	ETF	107.43	107.44	107.0465	107.29	3675711.0
2013-09-25 13:00:00	IWM	ETF	107.3	107.39	106.51	106.75	5503878.0
2013-09-25 14:00:00	IWM	ETF	106.75	106.85	106.54	106.56	3034702.0
2013-09-25 15:00:00	IWM	ETF	106.56	106.775	106.45	106.48	5114355.0
2013-09-25 16:00:00	IWM	ETF	106.48	106.7172	106.39	106.48	1172088.0
2013-09-25 17:00:00	IWM	ETF	106.9108	106.9108	106.9108	106.9108	331511.0
2013-09-25 18:00:00	IWM	ETF	106.46	106.55	106.46	106.48	1158.0
2013-09-25 19:00:00	IWM	ETF	106.54	106.54	106.54	106.54	100.0
2013-09-25 09:00:00	DIA	ETF	153.3	153.36	152.67	152.87	1038180.0
2013-09-25 10:00:00	DIA	ETF	152.89	153.13	152.55	153.01	1130057.0
2013-09-25 11:00:00	DIA	ETF	153.03	153.39	152.86	153.26	612835.0

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

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