PREVIEW / etf_1hour / 2011-05-31

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-31.parquet
  size:    185 KB
  rows:    5,732

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-05-31 04:00:00	SPY	ETF	134.31	134.9	134.31	134.87	12261.0
2011-05-31 05:00:00	SPY	ETF	134.74	134.85	134.73	134.85	38060.0
2011-05-31 06:00:00	SPY	ETF	134.81	134.87	134.7	134.76	17775.0
2011-05-31 07:00:00	SPY	ETF	134.79	134.8	134.57	134.58	535133.0
2011-05-31 08:00:00	SPY	ETF	134.59	134.67	134.49	134.63	1003741.0
2011-05-31 09:00:00	SPY	ETF	134.62	134.89	134.42	134.44	19874442.0
2011-05-31 10:00:00	SPY	ETF	134.44	134.559	134.09	134.13	24177011.0
2011-05-31 11:00:00	SPY	ETF	134.13	134.32	133.99	134.04	22325252.0
2011-05-31 12:00:00	SPY	ETF	134.04	134.1439	133.84	134.0	12905459.0
2011-05-31 13:00:00	SPY	ETF	134.0	134.4	133.98	134.33	13881363.0
2011-05-31 14:00:00	SPY	ETF	134.33	134.4	134.2	134.32	10798564.0
2011-05-31 15:00:00	SPY	ETF	134.31	134.91	134.19	134.89	38389732.0
2011-05-31 16:00:00	SPY	ETF	134.9	135.09	134.12	134.93	16924668.0
2011-05-31 17:00:00	SPY	ETF	134.91	135.01	134.5	134.97	273369.0
2011-05-31 18:00:00	SPY	ETF	134.96	135.12	134.89	135.11	242160.0
2011-05-31 19:00:00	SPY	ETF	135.11	135.26	135.1	135.21	143416.0
2011-05-31 04:00:00	QQQ	ETF	57.66	58.02	57.66	58.02	12248.0
2011-05-31 06:00:00	QQQ	ETF	57.98	57.98	57.98	57.98	200.0
2011-05-31 07:00:00	QQQ	ETF	57.89	57.95	57.86	57.87	55200.0
2011-05-31 08:00:00	QQQ	ETF	57.88	57.91	57.84	57.88	384885.0
2011-05-31 09:00:00	QQQ	ETF	57.88	58.07	57.88	57.96	6097076.0
2011-05-31 10:00:00	QQQ	ETF	57.96	57.97	57.73	57.75	6745983.0
2011-05-31 11:00:00	QQQ	ETF	57.74	57.85	57.7	57.74	3711368.0
2011-05-31 12:00:00	QQQ	ETF	57.745	57.82	57.67	57.77	2142846.0
2011-05-31 13:00:00	QQQ	ETF	57.77	58.02	57.765	57.98	3316478.0
2011-05-31 14:00:00	QQQ	ETF	57.9792	58.05	57.93	58.029	3009867.0
2011-05-31 15:00:00	QQQ	ETF	58.02	58.29	57.94	58.29	13499321.0
2011-05-31 16:00:00	QQQ	ETF	58.3	58.44	58.2283	58.37	5013519.0
2011-05-31 17:00:00	QQQ	ETF	58.38	58.4	57.9625	58.36	60115.0
2011-05-31 18:00:00	QQQ	ETF	58.37	58.44	58.35	58.42	55756.0
2011-05-31 19:00:00	QQQ	ETF	58.43	58.49	58.34	58.37	68772.0
2011-05-31 04:00:00	IWM	ETF	83.95	84.77	83.95	84.72	2882.0
2011-05-31 05:00:00	IWM	ETF	84.62	84.62	84.62	84.62	292.0
2011-05-31 06:00:00	IWM	ETF	84.64	84.64	84.54	84.54	13385.0
2011-05-31 07:00:00	IWM	ETF	84.56	84.64	84.53	84.53	50520.0
2011-05-31 08:00:00	IWM	ETF	84.51	84.6	84.47	84.51	258300.0
2011-05-31 09:00:00	IWM	ETF	84.51	84.67	84.24	84.27	6879956.0
2011-05-31 10:00:00	IWM	ETF	84.27	84.34	83.77	83.99	12816215.0
2011-05-31 11:00:00	IWM	ETF	83.99	84.38	83.98	84.2	6916026.0
2011-05-31 12:00:00	IWM	ETF	84.19	84.31	83.88	84.16	5725768.0
2011-05-31 13:00:00	IWM	ETF	84.17	84.525	84.16	84.46	6968891.0
2011-05-31 14:00:00	IWM	ETF	84.46	84.54	84.34	84.46	5090990.0
2011-05-31 15:00:00	IWM	ETF	84.46	84.86	84.35	84.83	13122823.0
2011-05-31 16:00:00	IWM	ETF	84.83	85.06	84.3411	84.95	3154203.0
2011-05-31 17:00:00	IWM	ETF	84.96	85.01	83.6119	85.0	551909.0
2011-05-31 18:00:00	IWM	ETF	85.0	85.0	84.97	84.99	4776.0
2011-05-31 19:00:00	IWM	ETF	85.0	85.01	84.98	85.0	40365.0
2011-05-31 04:00:00	DIA	ETF	125.24	125.44	125.24	125.44	2200.0
2011-05-31 07:00:00	DIA	ETF	125.36	125.36	125.19	125.2	4440.0
2011-05-31 08:00:00	DIA	ETF	125.15	125.2	125.13	125.15	31040.0

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

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