PREVIEW / etf_1hour / 2011-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-26.parquet
  size:    178 KB
  rows:    5,486

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
2011-07-26 04:00:00	SPY	ETF	134.01	134.21	134.01	134.07	3120.0
2011-07-26 05:00:00	SPY	ETF	133.89	133.89	133.65	133.65	1200.0
2011-07-26 06:00:00	SPY	ETF	133.8	134.1	133.77	134.08	13900.0
2011-07-26 07:00:00	SPY	ETF	134.13	134.21	134.01	134.03	1762444.0
2011-07-26 08:00:00	SPY	ETF	134.01	134.19	133.95	133.96	2660427.0
2011-07-26 09:00:00	SPY	ETF	133.95	133.97	133.1	133.25	20558155.0
2011-07-26 10:00:00	SPY	ETF	133.24	133.6	133.03	133.484	25511149.0
2011-07-26 11:00:00	SPY	ETF	133.48	133.75	133.45	133.53	11355209.0
2011-07-26 12:00:00	SPY	ETF	133.54	133.76	133.48	133.6177	8031759.0
2011-07-26 13:00:00	SPY	ETF	133.62	133.68	133.39	133.55	8896979.0
2011-07-26 14:00:00	SPY	ETF	133.56	133.96	133.51	133.65	15365349.0
2011-07-26 15:00:00	SPY	ETF	133.65	133.73	133.11	133.33	27691335.0
2011-07-26 16:00:00	SPY	ETF	133.33	133.4848	133.04	133.1	7533375.0
2011-07-26 17:00:00	SPY	ETF	133.09	133.15	132.98	133.0	526188.0
2011-07-26 18:00:00	SPY	ETF	133.01	133.36	132.98	133.14	243772.0
2011-07-26 19:00:00	SPY	ETF	133.13	133.16	133.06	133.1	46917.0
2011-07-26 04:00:00	QQQ	ETF	59.68	59.68	59.68	59.68	215.0
2011-07-26 07:00:00	QQQ	ETF	59.64	59.68	59.57	59.6	720408.0
2011-07-26 08:00:00	QQQ	ETF	59.59	59.68	59.56	59.56	1028564.0
2011-07-26 09:00:00	QQQ	ETF	59.55	59.73	59.37	59.41	7326337.0
2011-07-26 10:00:00	QQQ	ETF	59.45	59.63	59.32	59.57	9004019.0
2011-07-26 11:00:00	QQQ	ETF	59.57	59.7	59.57	59.62	3309928.0
2011-07-26 12:00:00	QQQ	ETF	59.63	59.72	59.58	59.7	3230406.0
2011-07-26 13:00:00	QQQ	ETF	59.7	59.73	59.57	59.6629	2895184.0
2011-07-26 14:00:00	QQQ	ETF	59.66	59.83	59.63	59.72	2973518.0
2011-07-26 15:00:00	QQQ	ETF	59.7116	59.76	59.53	59.62	6095593.0
2011-07-26 16:00:00	QQQ	ETF	59.61	59.63	59.37	59.53	2611809.0
2011-07-26 17:00:00	QQQ	ETF	59.54	59.6378	59.43	59.6378	99025.0
2011-07-26 18:00:00	QQQ	ETF	59.46	59.61	59.41	59.47	31779.0
2011-07-26 19:00:00	QQQ	ETF	59.5	59.52	59.47	59.48	36217.0
2011-07-26 04:00:00	IWM	ETF	83.26	83.44	83.26	83.44	200.0
2011-07-26 07:00:00	IWM	ETF	83.52	83.52	83.26	83.3	440836.0
2011-07-26 08:00:00	IWM	ETF	83.3	83.42	83.17	83.19	1596904.0
2011-07-26 09:00:00	IWM	ETF	83.18	83.22	82.43	82.47	9930721.0
2011-07-26 10:00:00	IWM	ETF	82.5	82.65	82.21	82.6	9312610.0
2011-07-26 11:00:00	IWM	ETF	82.6	82.94	82.6	82.78	4855677.0
2011-07-26 12:00:00	IWM	ETF	82.77	82.95	82.635	82.7526	3481033.0
2011-07-26 13:00:00	IWM	ETF	82.751	82.84	82.4601	82.6329	3290213.0
2011-07-26 14:00:00	IWM	ETF	82.63	82.87	82.59	82.6	3030592.0
2011-07-26 15:00:00	IWM	ETF	82.6	82.64	82.3	82.44	7039909.0
2011-07-26 16:00:00	IWM	ETF	82.44	82.47	82.21	82.22	1160881.0
2011-07-26 17:00:00	IWM	ETF	82.23	82.39	82.2	82.33	138427.0
2011-07-26 18:00:00	IWM	ETF	82.32	82.35	82.29	82.3	10695.0
2011-07-26 19:00:00	IWM	ETF	82.3	82.3	82.24	82.24	687.0
2011-07-26 04:00:00	DIA	ETF	126.12	126.12	126.12	126.12	100.0
2011-07-26 07:00:00	DIA	ETF	126.03	126.03	126.03	126.03	500.0
2011-07-26 08:00:00	DIA	ETF	125.88	125.91	125.77	125.77	107562.0
2011-07-26 09:00:00	DIA	ETF	125.73	125.73	124.79	124.94	1090436.0
2011-07-26 10:00:00	DIA	ETF	124.8401	125.16	124.72	125.02	1241140.0
2011-07-26 11:00:00	DIA	ETF	125.02	125.27	125.0	125.07	323870.0

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

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