PREVIEW / etf_1hour / 2011-05-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	135.99	136.03	135.99	136.03	650.0
2011-05-11 05:00:00	SPY	ETF	135.97	136.28	135.96	136.24	23450.0
2011-05-11 06:00:00	SPY	ETF	136.2	136.22	136.0	136.01	13600.0
2011-05-11 07:00:00	SPY	ETF	136.09	136.17	135.87	135.87	209325.0
2011-05-11 08:00:00	SPY	ETF	135.89	136.12	135.68	135.82	2707320.0
2011-05-11 09:00:00	SPY	ETF	135.82	135.92	135.31	135.425	16274419.0
2011-05-11 10:00:00	SPY	ETF	135.41	135.46	135.08	135.26	23027887.0
2011-05-11 11:00:00	SPY	ETF	135.265	135.42	134.83	134.93	14502269.0
2011-05-11 12:00:00	SPY	ETF	134.93	134.9325	133.98	134.4	34467237.0
2011-05-11 13:00:00	SPY	ETF	134.41	134.4584	133.82	134.17	26329806.0
2011-05-11 14:00:00	SPY	ETF	134.17	134.339	133.86	134.151	25108659.0
2011-05-11 15:00:00	SPY	ETF	134.15	134.56	134.04	134.45	32239991.0
2011-05-11 16:00:00	SPY	ETF	134.45	135.9384	134.06	134.08	14116314.0
2011-05-11 17:00:00	SPY	ETF	134.08	134.11	133.95	134.0	1575412.0
2011-05-11 18:00:00	SPY	ETF	134.0	134.45	134.0	134.16	185790.0
2011-05-11 19:00:00	SPY	ETF	134.14	134.19	134.09	134.12	64356.0
2011-05-11 06:00:00	QQQ	ETF	59.29	59.29	59.25	59.25	4200.0
2011-05-11 07:00:00	QQQ	ETF	59.21	59.27	59.17	59.17	12400.0
2011-05-11 08:00:00	QQQ	ETF	59.19	59.2	59.11	59.14	1265433.0
2011-05-11 09:00:00	QQQ	ETF	59.14	59.31	59.04	59.21	5702559.0
2011-05-11 10:00:00	QQQ	ETF	59.2	59.28	59.07	59.16	5741685.0
2011-05-11 11:00:00	QQQ	ETF	59.155	59.2	58.88	58.9099	4046318.0
2011-05-11 12:00:00	QQQ	ETF	58.9	58.91	58.49	58.68	9269123.0
2011-05-11 13:00:00	QQQ	ETF	58.69	58.71	58.36	58.49	7821965.0
2011-05-11 14:00:00	QQQ	ETF	58.49	58.66	58.43	58.59	6311614.0
2011-05-11 15:00:00	QQQ	ETF	58.58	58.83	58.55	58.76	9352016.0
2011-05-11 16:00:00	QQQ	ETF	58.75	58.86	58.55	58.55	3684863.0
2011-05-11 17:00:00	QQQ	ETF	58.58	58.6	58.46	58.57	413476.0
2011-05-11 18:00:00	QQQ	ETF	58.58	58.75	58.54	58.62	54745.0
2011-05-11 19:00:00	QQQ	ETF	58.62	58.62	58.58	58.58	18080.0
2011-05-11 05:00:00	IWM	ETF	85.7	85.7	85.7	85.7	200.0
2011-05-11 06:00:00	IWM	ETF	85.69	85.69	85.69	85.69	350.0
2011-05-11 07:00:00	IWM	ETF	85.61	85.7	85.47	85.49	135600.0
2011-05-11 08:00:00	IWM	ETF	85.49	85.62	85.24	85.31	1060778.0
2011-05-11 09:00:00	IWM	ETF	85.32	85.39	84.94	85.09	8119305.0
2011-05-11 10:00:00	IWM	ETF	85.09	85.09	84.51	84.65	12313400.0
2011-05-11 11:00:00	IWM	ETF	84.66	84.84	84.35	84.41	3566911.0
2011-05-11 12:00:00	IWM	ETF	84.41	84.42	83.67	84.06	10348347.0
2011-05-11 13:00:00	IWM	ETF	84.07	84.1	83.55	83.765	9004621.0
2011-05-11 14:00:00	IWM	ETF	83.77	84.02	83.68	83.87	5435471.0
2011-05-11 15:00:00	IWM	ETF	83.86	84.18	83.84	83.99	14795205.0
2011-05-11 16:00:00	IWM	ETF	83.99	84.319	83.75	83.75	1887634.0
2011-05-11 17:00:00	IWM	ETF	83.78	85.527	83.66	83.71	4140170.0
2011-05-11 18:00:00	IWM	ETF	83.74	83.83	83.74	83.8	2331.0
2011-05-11 19:00:00	IWM	ETF	83.82	83.82	83.82	83.82	100.0
2011-05-11 04:00:00	DIA	ETF	127.46	127.46	127.46	127.46	200.0
2011-05-11 07:00:00	DIA	ETF	127.61	127.61	127.47	127.47	5900.0
2011-05-11 08:00:00	DIA	ETF	127.39	127.43	127.27	127.35	36938.0
2011-05-11 09:00:00	DIA	ETF	127.39	127.41	126.94	127.0	488263.0
2011-05-11 10:00:00	DIA	ETF	126.99	127.0	126.68	126.82	749072.0

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

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