PREVIEW / etf_5min / 2011-04-01

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-04-01.parquet
  size:    888 KB
  rows:    37,519

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-01 04:00:00	SPY	ETF	132.77	132.77	132.77	132.77	100.0
2011-04-01 04:05:00	SPY	ETF	132.83	132.83	132.83	132.83	6000.0
2011-04-01 04:10:00	SPY	ETF	132.8	132.81	132.8	132.8	6800.0
2011-04-01 04:15:00	SPY	ETF	132.84	132.84	132.84	132.84	100.0
2011-04-01 05:05:00	SPY	ETF	132.71	132.71	132.71	132.71	100.0
2011-04-01 05:10:00	SPY	ETF	132.7	132.7	132.7	132.7	700.0
2011-04-01 05:25:00	SPY	ETF	132.72	132.72	132.7	132.7	200.0
2011-04-01 05:35:00	SPY	ETF	132.75	132.75	132.75	132.75	650.0
2011-04-01 05:45:00	SPY	ETF	132.78	132.78	132.78	132.78	1200.0
2011-04-01 05:50:00	SPY	ETF	132.8	132.8	132.8	132.8	700.0
2011-04-01 06:00:00	SPY	ETF	132.85	132.85	132.85	132.85	2000.0
2011-04-01 06:05:00	SPY	ETF	132.8	132.8	132.8	132.8	500.0
2011-04-01 06:10:00	SPY	ETF	132.83	133.11	132.83	132.89	3450.0
2011-04-01 06:15:00	SPY	ETF	132.86	132.87	132.86	132.87	2500.0
2011-04-01 06:35:00	SPY	ETF	132.87	132.87	132.83	132.86	1500.0
2011-04-01 06:40:00	SPY	ETF	132.88	132.88	132.88	132.88	600.0
2011-04-01 06:55:00	SPY	ETF	132.93	132.93	132.93	132.93	500.0
2011-04-01 07:00:00	SPY	ETF	132.94	132.98	132.94	132.95	2300.0
2011-04-01 07:05:00	SPY	ETF	132.99	133.05	132.99	133.04	18700.0
2011-04-01 07:10:00	SPY	ETF	133.05	133.06	133.04	133.06	2475.0
2011-04-01 07:15:00	SPY	ETF	133.05	133.05	132.99	132.99	7150.0
2011-04-01 07:20:00	SPY	ETF	133.03	133.03	133.03	133.03	500.0
2011-04-01 07:25:00	SPY	ETF	133.03	133.03	132.99	132.99	20000.0
2011-04-01 07:30:00	SPY	ETF	133.08	133.08	133.03	133.04	88200.0
2011-04-01 07:35:00	SPY	ETF	133.06	133.1	132.96	132.96	768700.0
2011-04-01 07:40:00	SPY	ETF	132.99	133.01	132.98	132.98	175200.0
2011-04-01 07:45:00	SPY	ETF	132.99	132.99	132.98	132.99	25000.0
2011-04-01 07:50:00	SPY	ETF	133.04	133.07	133.04	133.05	19350.0
2011-04-01 07:55:00	SPY	ETF	133.04	133.04	133.01	133.04	44425.0
2011-04-01 08:00:00	SPY	ETF	133.01	133.05	132.51	133.03	829333.0
2011-04-01 08:05:00	SPY	ETF	133.02	133.05	133.01	133.04	31981.0
2011-04-01 08:10:00	SPY	ETF	133.04	133.09	132.62	133.04	134477.0
2011-04-01 08:15:00	SPY	ETF	133.04	133.17	133.04	133.12	238113.0
2011-04-01 08:20:00	SPY	ETF	133.12	133.15	133.03	133.09	94252.0
2011-04-01 08:25:00	SPY	ETF	133.07	133.15	133.05	133.14	303343.0
2011-04-01 08:30:00	SPY	ETF	133.15	133.33	133.1	133.24	2270252.0
2011-04-01 08:35:00	SPY	ETF	133.24	133.38	133.19	133.37	1487891.0
2011-04-01 08:40:00	SPY	ETF	133.35	133.44	133.29	133.31	658108.0
2011-04-01 08:45:00	SPY	ETF	133.31	133.33	133.25	133.26	365294.0
2011-04-01 08:50:00	SPY	ETF	133.24	133.35	132.59	133.27	827107.0
2011-04-01 08:55:00	SPY	ETF	133.27	133.33	132.59	133.26	209538.0
2011-04-01 09:00:00	SPY	ETF	133.28	133.36	133.28	133.34	96170.0
2011-04-01 09:05:00	SPY	ETF	133.34	133.36	132.51	133.34	153898.0
2011-04-01 09:10:00	SPY	ETF	133.33	133.39	133.32	133.39	328450.0
2011-04-01 09:15:00	SPY	ETF	133.38	133.49	133.38	133.42	320075.0
2011-04-01 09:20:00	SPY	ETF	133.43	133.46	133.35	133.38	415355.0
2011-04-01 09:25:00	SPY	ETF	133.37	133.44	132.59	133.41	589735.0
2011-04-01 09:30:00	SPY	ETF	133.41	133.46	133.29	133.29	4530215.0
2011-04-01 09:35:00	SPY	ETF	133.29	133.45	133.26	133.38	2214055.0
2011-04-01 09:40:00	SPY	ETF	133.375	133.45	133.23	133.27	2243053.0

> showing 50 of 37,519 rows — these rows as CSV

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