PREVIEW / etf_1hour / 2011-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-08.parquet
  size:    177 KB
  rows:    5,470

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-04-08 04:00:00	SPY	ETF	133.35	133.74	133.35	133.64	20300.0
2011-04-08 05:00:00	SPY	ETF	133.75	133.81	133.73	133.75	4450.0
2011-04-08 06:00:00	SPY	ETF	133.8	133.83	133.76	133.82	50700.0
2011-04-08 07:00:00	SPY	ETF	133.84	134.0	133.79	133.93	649170.0
2011-04-08 08:00:00	SPY	ETF	133.93	133.97	133.82	133.82	1005811.0
2011-04-08 09:00:00	SPY	ETF	133.83	133.99	133.5	133.6433	16098800.0
2011-04-08 10:00:00	SPY	ETF	133.65	133.73	133.28	133.29	19064133.0
2011-04-08 11:00:00	SPY	ETF	133.29	133.49	133.17	133.37	15575672.0
2011-04-08 12:00:00	SPY	ETF	133.36	133.43	133.1	133.18	7189711.0
2011-04-08 13:00:00	SPY	ETF	133.1816	133.27	133.1	133.22	8589802.0
2011-04-08 14:00:00	SPY	ETF	133.22	133.24	132.35	132.39	25001245.0
2011-04-08 15:00:00	SPY	ETF	132.39	132.96	132.31	132.85	36003577.0
2011-04-08 16:00:00	SPY	ETF	132.86	133.63	132.5562	132.75	17564913.0
2011-04-08 17:00:00	SPY	ETF	132.75	132.84	132.75	132.79	463140.0
2011-04-08 18:00:00	SPY	ETF	132.79	132.86	132.68	132.69	122643.0
2011-04-08 19:00:00	SPY	ETF	132.73	132.83	132.68	132.7	72129.0
2011-04-08 04:00:00	QQQ	ETF	57.38	57.38	57.38	57.38	780.0
2011-04-08 05:00:00	QQQ	ETF	57.41	57.41	57.4	57.4	400.0
2011-04-08 07:00:00	QQQ	ETF	57.41	57.48	57.36	57.45	154765.0
2011-04-08 08:00:00	QQQ	ETF	57.45	57.47	57.37	57.41	656068.0
2011-04-08 09:00:00	QQQ	ETF	57.42	57.57	57.21	57.31	4532704.0
2011-04-08 10:00:00	QQQ	ETF	57.31	57.37	57.08	57.15	6455494.0
2011-04-08 11:00:00	QQQ	ETF	57.1531	57.3	57.11	57.24	4383751.0
2011-04-08 12:00:00	QQQ	ETF	57.24	57.27	57.1	57.15	1314422.0
2011-04-08 13:00:00	QQQ	ETF	57.14	57.22	57.12	57.17	2989282.0
2011-04-08 14:00:00	QQQ	ETF	57.17	57.18	56.67	56.6799	6867542.0
2011-04-08 15:00:00	QQQ	ETF	56.67	57.01	56.65	56.95	7921297.0
2011-04-08 16:00:00	QQQ	ETF	56.94	57.01	56.91	56.98	1668206.0
2011-04-08 17:00:00	QQQ	ETF	56.98	57.17	56.97	56.99	71550.0
2011-04-08 18:00:00	QQQ	ETF	56.95	56.99	56.91	56.91	41534.0
2011-04-08 19:00:00	QQQ	ETF	56.92	56.98	56.91	56.94	1700.0
2011-04-08 04:00:00	IWM	ETF	85.18	85.18	85.15	85.15	1100.0
2011-04-08 05:00:00	IWM	ETF	85.18	85.18	85.18	85.18	400.0
2011-04-08 06:00:00	IWM	ETF	85.14	85.15	85.13	85.14	10000.0
2011-04-08 07:00:00	IWM	ETF	85.18	85.26	85.08	85.23	297670.0
2011-04-08 08:00:00	IWM	ETF	85.1	85.27	85.09	85.13	526868.0
2011-04-08 09:00:00	IWM	ETF	85.12	85.3599	84.88	85.02	6639263.0
2011-04-08 10:00:00	IWM	ETF	85.03	85.08	84.63	84.64	7001538.0
2011-04-08 11:00:00	IWM	ETF	84.6312	84.65	84.3601	84.4901	5112220.0
2011-04-08 12:00:00	IWM	ETF	84.49	84.6	84.34	84.38	2723879.0
2011-04-08 13:00:00	IWM	ETF	84.38	84.48	84.32	84.36	3532931.0
2011-04-08 14:00:00	IWM	ETF	84.35	84.38	83.63	83.63	9304825.0
2011-04-08 15:00:00	IWM	ETF	83.64	84.07	83.6	83.99	14015436.0
2011-04-08 16:00:00	IWM	ETF	84.0	84.74	83.84	83.87	2073846.0
2011-04-08 17:00:00	IWM	ETF	83.89	83.92	83.89	83.92	11021.0
2011-04-08 18:00:00	IWM	ETF	83.91	83.98	83.91	83.92	51195.0
2011-04-08 19:00:00	IWM	ETF	83.9	83.92	83.88	83.9	6805.0
2011-04-08 04:00:00	DIA	ETF	124.19	124.19	124.19	124.19	100.0
2011-04-08 05:00:00	DIA	ETF	124.27	124.28	124.27	124.28	200.0
2011-04-08 06:00:00	DIA	ETF	124.27	124.27	124.27	124.27	100.0

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

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