PREVIEW / etf_1hour / 2011-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-11-02.parquet
  size:    183 KB
  rows:    5,628

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-11-02 04:00:00	SPY	ETF	123.63	124.25	123.6	123.81	29889.0
2011-11-02 05:00:00	SPY	ETF	124.0	124.08	122.61	122.8	102680.0
2011-11-02 06:00:00	SPY	ETF	122.8	123.44	122.8	123.25	154997.0
2011-11-02 07:00:00	SPY	ETF	123.23	123.63	123.08	123.4	796194.0
2011-11-02 08:00:00	SPY	ETF	123.43	124.04	123.39	123.62	2659753.0
2011-11-02 09:00:00	SPY	ETF	123.63	124.02	123.38	123.53	24713402.0
2011-11-02 10:00:00	SPY	ETF	123.53	124.4	123.28	124.22	35493257.0
2011-11-02 11:00:00	SPY	ETF	124.22	124.4	124.0	124.07	19985559.0
2011-11-02 12:00:00	SPY	ETF	124.068	124.24	123.4	123.44	28073635.0
2011-11-02 13:00:00	SPY	ETF	123.45	123.49	122.7905	123.07	30995550.0
2011-11-02 14:00:00	SPY	ETF	123.07	123.84	122.8	123.7	29574476.0
2011-11-02 15:00:00	SPY	ETF	123.7	124.22	123.44	123.99	48963562.0
2011-11-02 16:00:00	SPY	ETF	123.99	124.09	121.967	124.06	18960570.0
2011-11-02 17:00:00	SPY	ETF	124.05	124.3	124.04	124.25	361967.0
2011-11-02 18:00:00	SPY	ETF	124.24	124.33	123.51	123.67	747140.0
2011-11-02 19:00:00	SPY	ETF	123.69	123.81	123.18	123.27	258545.0
2011-11-02 04:00:00	QQQ	ETF	57.09	57.24	57.09	57.17	1301.0
2011-11-02 05:00:00	QQQ	ETF	56.92	56.92	56.66	56.66	400.0
2011-11-02 06:00:00	QQQ	ETF	56.66	56.66	56.66	56.66	400.0
2011-11-02 07:00:00	QQQ	ETF	56.67	56.85	56.67	56.8	229580.0
2011-11-02 08:00:00	QQQ	ETF	56.79	56.95	56.76	56.86	330174.0
2011-11-02 09:00:00	QQQ	ETF	56.87	57.05	56.66	56.71	8775638.0
2011-11-02 10:00:00	QQQ	ETF	56.72	57.12	56.56	57.0607	9546718.0
2011-11-02 11:00:00	QQQ	ETF	57.07	57.16	56.89	56.93	7935957.0
2011-11-02 12:00:00	QQQ	ETF	56.92	56.99	56.66	56.675	5654207.0
2011-11-02 13:00:00	QQQ	ETF	56.68	56.7101	56.45	56.5	5909200.0
2011-11-02 14:00:00	QQQ	ETF	56.5	56.84	56.385	56.77	5904810.0
2011-11-02 15:00:00	QQQ	ETF	56.77	57.0	56.66	56.9	9649413.0
2011-11-02 16:00:00	QQQ	ETF	56.89	57.06	56.87	57.02	2701508.0
2011-11-02 17:00:00	QQQ	ETF	57.05	57.13	57.02	57.08	124725.0
2011-11-02 18:00:00	QQQ	ETF	57.1	57.13	56.84	56.85	136366.0
2011-11-02 19:00:00	QQQ	ETF	56.87	56.93	56.72	56.75	80381.0
2011-11-02 04:00:00	IWM	ETF	72.43	72.9	72.43	72.61	1516.0
2011-11-02 05:00:00	IWM	ETF	72.72	72.72	71.7	71.7	2180.0
2011-11-02 06:00:00	IWM	ETF	72.0	72.22	72.0	72.1	1030.0
2011-11-02 07:00:00	IWM	ETF	72.1	72.37	71.98	72.23	92880.0
2011-11-02 08:00:00	IWM	ETF	72.19	72.55	72.19	72.43	256925.0
2011-11-02 09:00:00	IWM	ETF	72.45	72.91	72.2	72.32	8816974.0
2011-11-02 10:00:00	IWM	ETF	72.33	73.18	72.23	73.09	8608119.0
2011-11-02 11:00:00	IWM	ETF	73.09	73.3	72.95	73.04	4847437.0
2011-11-02 12:00:00	IWM	ETF	73.04	73.19	72.49	72.53	5868563.0
2011-11-02 13:00:00	IWM	ETF	72.54	72.56	71.83	72.1531	9064700.0
2011-11-02 14:00:00	IWM	ETF	72.15	72.81	71.91	72.7452	7502565.0
2011-11-02 15:00:00	IWM	ETF	72.76	73.28	72.59	73.2	13547739.0
2011-11-02 16:00:00	IWM	ETF	73.2	73.31	72.9	73.21	1535691.0
2011-11-02 17:00:00	IWM	ETF	73.24	73.32	73.21	73.32	31000.0
2011-11-02 18:00:00	IWM	ETF	73.22	73.22	72.95	73.04	17567.0
2011-11-02 19:00:00	IWM	ETF	72.97	72.97	72.75	72.75	6400.0
2011-11-02 04:00:00	DIA	ETF	118.05	118.15	117.85	117.85	8500.0
2011-11-02 07:00:00	DIA	ETF	117.39	117.57	117.39	117.57	700.0

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

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