PREVIEW / etf_30min / 2012-02-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-07.parquet
  size:    289 KB
  rows:    9,775

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
2012-02-07 04:00:00	SPY	ETF	134.25	134.25	134.16	134.19	8000.0
2012-02-07 04:30:00	SPY	ETF	134.32	134.37	134.32	134.37	7500.0
2012-02-07 05:00:00	SPY	ETF	134.39	134.39	134.26	134.28	5690.0
2012-02-07 05:30:00	SPY	ETF	134.29	134.29	134.18	134.18	5400.0
2012-02-07 06:00:00	SPY	ETF	134.2	134.24	134.15	134.21	29900.0
2012-02-07 06:30:00	SPY	ETF	134.17	134.17	134.01	134.01	93750.0
2012-02-07 07:00:00	SPY	ETF	134.0	134.0	133.77	133.93	185337.0
2012-02-07 07:30:00	SPY	ETF	133.92	134.0	133.88	133.91	125950.0
2012-02-07 08:00:00	SPY	ETF	133.93	134.06	133.84	134.0	227692.0
2012-02-07 08:30:00	SPY	ETF	134.01	134.28	133.93	134.09	1335397.0
2012-02-07 09:00:00	SPY	ETF	134.08	134.23	134.01	134.16	670821.0
2012-02-07 09:30:00	SPY	ETF	134.17	134.29	133.78	133.93	17437498.0
2012-02-07 10:00:00	SPY	ETF	133.93	134.17	133.64	134.05	13154023.0
2012-02-07 10:30:00	SPY	ETF	134.04	134.59	134.03	134.56	12790105.0
2012-02-07 11:00:00	SPY	ETF	134.5675	134.81	134.53	134.81	10799697.0
2012-02-07 11:30:00	SPY	ETF	134.81	134.82	134.62	134.66	9916362.0
2012-02-07 12:00:00	SPY	ETF	134.66	134.8	134.65	134.69	5070730.0
2012-02-07 12:30:00	SPY	ETF	134.7	134.8	134.66	134.79	2590532.0
2012-02-07 13:00:00	SPY	ETF	134.78	134.89	134.61	134.72	9342599.0
2012-02-07 13:30:00	SPY	ETF	134.7355	134.87	134.65	134.8126	4392635.0
2012-02-07 14:00:00	SPY	ETF	134.82	134.85	134.67	134.71	4750400.0
2012-02-07 14:30:00	SPY	ETF	134.7	134.8	134.55	134.59	5354554.0
2012-02-07 15:00:00	SPY	ETF	134.59	135.0	134.59	134.97	8519542.0
2012-02-07 15:30:00	SPY	ETF	134.97	135.02	134.76	134.78	17751296.0
2012-02-07 16:00:00	SPY	ETF	134.77	134.94	134.6	134.91	7212195.0
2012-02-07 16:30:00	SPY	ETF	134.91	134.91	134.774	134.89	2771483.0
2012-02-07 17:00:00	SPY	ETF	134.88	134.9	134.81	134.81	171943.0
2012-02-07 17:30:00	SPY	ETF	134.81	134.83	134.1	134.83	323049.0
2012-02-07 18:00:00	SPY	ETF	134.8	134.86	134.77	134.81	30705.0
2012-02-07 18:30:00	SPY	ETF	134.787	134.79	134.72	134.73	122790.0
2012-02-07 19:00:00	SPY	ETF	134.73	134.8	134.72	134.8	17300.0
2012-02-07 19:30:00	SPY	ETF	134.81	134.85	134.8	134.85	96175.0
2012-02-07 04:00:00	QQQ	ETF	61.94	61.96	61.94	61.96	200.0
2012-02-07 06:00:00	QQQ	ETF	61.96	61.98	61.96	61.97	30700.0
2012-02-07 06:30:00	QQQ	ETF	61.94	61.94	61.88	61.88	55079.0
2012-02-07 07:00:00	QQQ	ETF	61.85	61.85	61.77	61.79	5200.0
2012-02-07 07:30:00	QQQ	ETF	61.8	61.86	61.8	61.8	15544.0
2012-02-07 08:00:00	QQQ	ETF	61.82	61.87	61.78	61.86	37643.0
2012-02-07 08:30:00	QQQ	ETF	61.85	61.95	61.85	61.9	106744.0
2012-02-07 09:00:00	QQQ	ETF	61.9	61.94	61.87	61.94	138634.0
2012-02-07 09:30:00	QQQ	ETF	61.94	62.01	61.7293	61.86	7233477.0
2012-02-07 10:00:00	QQQ	ETF	61.85	61.92	61.67	61.856	3030876.0
2012-02-07 10:30:00	QQQ	ETF	61.85	62.13	61.83	62.11	3022537.0
2012-02-07 11:00:00	QQQ	ETF	62.12	62.22	62.09	62.22	1992528.0
2012-02-07 11:30:00	QQQ	ETF	62.22	62.24	62.11	62.16	3800356.0
2012-02-07 12:00:00	QQQ	ETF	62.16	62.25	62.15	62.176	1856757.0
2012-02-07 12:30:00	QQQ	ETF	62.18	62.22	62.16	62.21	531990.0
2012-02-07 13:00:00	QQQ	ETF	62.21	62.23	62.06	62.11	2203266.0
2012-02-07 13:30:00	QQQ	ETF	62.115	62.18	62.09	62.1496	1503902.0
2012-02-07 14:00:00	QQQ	ETF	62.15	62.162	62.1	62.12	1647766.0

> showing 50 of 9,775 rows — these rows as CSV

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