PREVIEW / etf_5min / 2011-07-14

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-14.parquet
  size:    896 KB
  rows:    36,635

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-07-14 04:00:00	SPY	ETF	131.85	131.9	131.85	131.88	807.0
2011-07-14 04:15:00	SPY	ETF	131.92	131.94	131.92	131.94	380.0
2011-07-14 04:20:00	SPY	ETF	131.93	132.01	131.93	132.01	1900.0
2011-07-14 04:25:00	SPY	ETF	132.03	132.03	132.03	132.03	100.0
2011-07-14 04:30:00	SPY	ETF	132.09	132.16	132.09	132.16	740.0
2011-07-14 04:35:00	SPY	ETF	132.18	132.18	132.18	132.18	200.0
2011-07-14 04:45:00	SPY	ETF	132.2	132.2	132.2	132.2	307.0
2011-07-14 04:50:00	SPY	ETF	132.11	132.11	132.11	132.11	7500.0
2011-07-14 04:55:00	SPY	ETF	132.12	132.12	132.12	132.12	2500.0
2011-07-14 05:00:00	SPY	ETF	132.14	132.14	132.14	132.14	100.0
2011-07-14 05:10:00	SPY	ETF	132.14	132.14	132.14	132.14	395.0
2011-07-14 05:20:00	SPY	ETF	132.25	132.25	132.25	132.25	200.0
2011-07-14 05:25:00	SPY	ETF	132.2	132.27	132.14	132.17	800.0
2011-07-14 05:30:00	SPY	ETF	132.07	132.07	131.9	131.9	508.0
2011-07-14 05:35:00	SPY	ETF	132.01	132.03	131.99	131.99	800.0
2011-07-14 05:40:00	SPY	ETF	131.92	131.92	131.92	131.92	100.0
2011-07-14 05:45:00	SPY	ETF	131.92	131.92	131.92	131.92	100.0
2011-07-14 05:50:00	SPY	ETF	131.86	131.86	131.77	131.77	1100.0
2011-07-14 06:00:00	SPY	ETF	131.69	131.69	131.63	131.63	1450.0
2011-07-14 06:05:00	SPY	ETF	131.7	131.7	131.7	131.7	890.0
2011-07-14 06:10:00	SPY	ETF	131.75	132.24	131.75	131.88	7810.0
2011-07-14 06:15:00	SPY	ETF	131.8	131.82	131.8	131.82	500.0
2011-07-14 06:20:00	SPY	ETF	131.64	131.64	131.64	131.64	1500.0
2011-07-14 06:25:00	SPY	ETF	131.65	131.66	131.58	131.66	2400.0
2011-07-14 06:30:00	SPY	ETF	131.76	131.76	131.56	131.56	300.0
2011-07-14 06:35:00	SPY	ETF	131.7	131.7	131.7	131.7	1000.0
2011-07-14 06:40:00	SPY	ETF	131.67	131.67	131.57	131.6	4700.0
2011-07-14 06:45:00	SPY	ETF	131.6	131.64	131.6	131.63	400.0
2011-07-14 06:50:00	SPY	ETF	131.55	131.57	131.55	131.57	1560.0
2011-07-14 06:55:00	SPY	ETF	131.69	131.9	131.66	131.8	148300.0
2011-07-14 07:00:00	SPY	ETF	131.83	131.9	131.7	131.7	60000.0
2011-07-14 07:05:00	SPY	ETF	131.67	131.67	131.53	131.55	52110.0
2011-07-14 07:10:00	SPY	ETF	131.69	131.83	131.68	131.75	13900.0
2011-07-14 07:15:00	SPY	ETF	131.71	131.98	131.71	131.92	33620.0
2011-07-14 07:20:00	SPY	ETF	131.98	132.15	131.96	132.15	168105.0
2011-07-14 07:25:00	SPY	ETF	132.14	132.2	132.04	132.17	102300.0
2011-07-14 07:30:00	SPY	ETF	132.2	132.2	132.14	132.19	121520.0
2011-07-14 07:35:00	SPY	ETF	132.15	132.18	132.04	132.11	95827.0
2011-07-14 07:40:00	SPY	ETF	132.11	132.14	132.05	132.05	276700.0
2011-07-14 07:45:00	SPY	ETF	132.03	132.05	131.98	132.04	318700.0
2011-07-14 07:50:00	SPY	ETF	132.04	132.15	131.99	132.14	174400.0
2011-07-14 07:55:00	SPY	ETF	132.14	132.14	132.03	132.08	114007.0
2011-07-14 08:00:00	SPY	ETF	132.04	132.13	131.14	131.14	124443.0
2011-07-14 08:05:00	SPY	ETF	132.04	132.1	132.01	132.1	230100.0
2011-07-14 08:10:00	SPY	ETF	132.09	132.15	132.07	132.12	125236.0
2011-07-14 08:15:00	SPY	ETF	132.12	132.13	131.35	132.05	156277.0
2011-07-14 08:20:00	SPY	ETF	132.03	132.06	131.92	131.96	138836.0
2011-07-14 08:25:00	SPY	ETF	131.96	132.03	131.91	131.96	1009208.0
2011-07-14 08:30:00	SPY	ETF	131.98	132.23	131.94	131.98	692784.0
2011-07-14 08:35:00	SPY	ETF	132.02	132.14	131.98	132.11	155266.0

> showing 50 of 36,635 rows — these rows as CSV

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