PREVIEW / etf_1hour / 2012-10-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-10-26.parquet
  size:    182 KB
  rows:    5,642

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
2012-10-26 04:00:00	SPY	ETF	140.4	140.59	140.3	140.48	41175.0
2012-10-26 05:00:00	SPY	ETF	140.52	140.55	140.33	140.42	95955.0
2012-10-26 06:00:00	SPY	ETF	140.37	140.39	140.21	140.31	156680.0
2012-10-26 07:00:00	SPY	ETF	140.3	140.67	140.25	140.61	882454.0
2012-10-26 08:00:00	SPY	ETF	140.61	141.68	140.25	141.35	3973573.0
2012-10-26 09:00:00	SPY	ETF	141.34	141.78	141.15	141.2	15383914.0
2012-10-26 10:00:00	SPY	ETF	141.19	141.55	140.65	140.82	21708023.0
2012-10-26 11:00:00	SPY	ETF	140.83	141.4021	140.68	140.8	19695053.0
2012-10-26 12:00:00	SPY	ETF	140.8	140.94	140.39	140.91	15218328.0
2012-10-26 13:00:00	SPY	ETF	140.92	141.38	140.66	141.25	14184098.0
2012-10-26 14:00:00	SPY	ETF	141.24	141.59	141.13	141.3975	10720399.0
2012-10-26 15:00:00	SPY	ETF	141.39	141.84	141.19	141.3	23626858.0
2012-10-26 16:00:00	SPY	ETF	141.3	141.6	141.0929	141.23	19363670.0
2012-10-26 17:00:00	SPY	ETF	141.24	141.33	141.18	141.24	197076.0
2012-10-26 18:00:00	SPY	ETF	141.25	141.26	141.21	141.21	4810.0
2012-10-26 19:00:00	SPY	ETF	141.2	141.26	141.19	141.2	16753.0
2012-10-26 04:00:00	QQQ	ETF	64.66	64.71	64.59	64.65	16051.0
2012-10-26 05:00:00	QQQ	ETF	64.72	64.74	64.72	64.74	300.0
2012-10-26 06:00:00	QQQ	ETF	64.62	64.7	64.62	64.7	5300.0
2012-10-26 07:00:00	QQQ	ETF	64.73	65.0	64.73	64.98	493195.0
2012-10-26 08:00:00	QQQ	ETF	64.97	65.6	64.76	65.14	5174173.0
2012-10-26 09:00:00	QQQ	ETF	65.14	65.57	64.77	65.31	10211483.0
2012-10-26 10:00:00	QQQ	ETF	65.32	65.51	64.97	64.99	6240039.0
2012-10-26 11:00:00	QQQ	ETF	64.9914	65.16	64.87	64.94	4586910.0
2012-10-26 12:00:00	QQQ	ETF	64.93	64.99	64.65	64.965	5471453.0
2012-10-26 13:00:00	QQQ	ETF	64.97	65.3301	64.83	65.26	4293817.0
2012-10-26 14:00:00	QQQ	ETF	65.2699	65.48	65.19	65.4	3318226.0
2012-10-26 15:00:00	QQQ	ETF	65.39	65.623	65.335	65.36	9055094.0
2012-10-26 16:00:00	QQQ	ETF	65.35	65.58	65.1725	65.38	2563028.0
2012-10-26 17:00:00	QQQ	ETF	65.38	65.48	65.36	65.48	34350.0
2012-10-26 18:00:00	QQQ	ETF	65.38	65.38	65.35	65.35	11562.0
2012-10-26 19:00:00	QQQ	ETF	65.37	65.37	65.35	65.35	300.0
2012-10-26 05:00:00	IWM	ETF	81.0	81.05	81.0	81.05	200.0
2012-10-26 07:00:00	IWM	ETF	80.8	81.1	80.8	81.1	160224.0
2012-10-26 08:00:00	IWM	ETF	81.09	81.56	80.72	81.47	1382263.0
2012-10-26 09:00:00	IWM	ETF	81.44	81.9	81.2	81.2	5032457.0
2012-10-26 10:00:00	IWM	ETF	81.2	81.49	80.8	80.93	7441255.0
2012-10-26 11:00:00	IWM	ETF	80.93	81.09	80.76	80.78	3490036.0
2012-10-26 12:00:00	IWM	ETF	80.775	80.78	80.46	80.74	4377898.0
2012-10-26 13:00:00	IWM	ETF	80.74	81.02	80.61	80.91	2992707.0
2012-10-26 14:00:00	IWM	ETF	80.91	81.17	80.84	81.07	3505346.0
2012-10-26 15:00:00	IWM	ETF	81.06	81.29	80.97	81.13	6918587.0
2012-10-26 16:00:00	IWM	ETF	81.13	81.28	80.6676	80.6676	1716020.0
2012-10-26 17:00:00	IWM	ETF	81.17	81.19	81.14	81.14	8800.0
2012-10-26 18:00:00	IWM	ETF	81.14	81.14	81.14	81.14	100.0
2012-10-26 19:00:00	IWM	ETF	81.14	81.18	81.14	81.18	3000.0
2012-10-26 08:00:00	DIA	ETF	130.31	130.77	130.27	130.77	130400.0
2012-10-26 09:00:00	DIA	ETF	130.64	131.03	130.54	130.54	654698.0
2012-10-26 10:00:00	DIA	ETF	130.56	130.87	130.24	130.4	782730.0
2012-10-26 11:00:00	DIA	ETF	130.4	130.69	130.339	130.42	322785.0

> showing 50 of 5,642 rows — these rows as CSV

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