PREVIEW / etf_5min / 2012-10-31

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-31.parquet
  size:    909 KB
  rows:    38,738

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-10-31 04:00:00	SPY	ETF	141.95	142.0	141.94	142.0	9395.0
2012-10-31 04:05:00	SPY	ETF	142.02	142.08	142.01	142.08	36600.0
2012-10-31 04:10:00	SPY	ETF	142.11	142.15	142.11	142.15	1600.0
2012-10-31 04:15:00	SPY	ETF	142.25	142.25	142.25	142.25	34900.0
2012-10-31 04:20:00	SPY	ETF	142.3	142.3	142.3	142.3	100.0
2012-10-31 04:25:00	SPY	ETF	142.31	142.31	142.31	142.31	12000.0
2012-10-31 04:30:00	SPY	ETF	142.3	142.3	142.3	142.3	125.0
2012-10-31 04:40:00	SPY	ETF	142.3	142.31	142.3	142.31	4100.0
2012-10-31 04:55:00	SPY	ETF	142.2	142.2	142.2	142.2	5000.0
2012-10-31 05:00:00	SPY	ETF	142.2	142.23	142.17	142.19	52904.0
2012-10-31 05:05:00	SPY	ETF	142.17	142.21	142.17	142.21	24000.0
2012-10-31 05:10:00	SPY	ETF	142.25	142.25	142.25	142.25	200.0
2012-10-31 05:20:00	SPY	ETF	142.28	142.31	142.28	142.31	2300.0
2012-10-31 05:35:00	SPY	ETF	142.305	142.305	142.305	142.305	500.0
2012-10-31 05:50:00	SPY	ETF	142.27	142.29	142.26	142.29	5100.0
2012-10-31 06:05:00	SPY	ETF	142.29	142.3	142.27	142.3	3200.0
2012-10-31 06:15:00	SPY	ETF	142.29	142.29	142.29	142.29	100.0
2012-10-31 06:25:00	SPY	ETF	142.26	142.26	142.26	142.26	600.0
2012-10-31 06:30:00	SPY	ETF	142.25	142.25	142.25	142.25	400.0
2012-10-31 06:35:00	SPY	ETF	142.24	142.25	142.205	142.23	1550.0
2012-10-31 06:40:00	SPY	ETF	142.24	142.25	142.24	142.25	1835.0
2012-10-31 06:45:00	SPY	ETF	142.275	142.35	142.275	142.32	2600.0
2012-10-31 06:50:00	SPY	ETF	142.28	142.28	142.21	142.21	15200.0
2012-10-31 06:55:00	SPY	ETF	142.28	142.28	142.21	142.23	201550.0
2012-10-31 07:00:00	SPY	ETF	142.22	142.28	142.16	142.16	28415.0
2012-10-31 07:05:00	SPY	ETF	142.13	142.15	142.09	142.12	31500.0
2012-10-31 07:10:00	SPY	ETF	142.12	142.16	142.09	142.16	3760.0
2012-10-31 07:15:00	SPY	ETF	142.14	142.25	142.14	142.24	28790.0
2012-10-31 07:20:00	SPY	ETF	142.2	142.26	142.2	142.25	16730.0
2012-10-31 07:25:00	SPY	ETF	142.25	142.25	142.25	142.25	100.0
2012-10-31 07:30:00	SPY	ETF	142.22	142.22	142.22	142.22	100.0
2012-10-31 07:35:00	SPY	ETF	142.25	142.26	142.25	142.25	7060.0
2012-10-31 07:40:00	SPY	ETF	142.22	142.23	142.12	142.12	26354.0
2012-10-31 07:45:00	SPY	ETF	142.12	142.12	142.1	142.1	11336.0
2012-10-31 07:50:00	SPY	ETF	142.11	142.15	142.11	142.15	12500.0
2012-10-31 07:55:00	SPY	ETF	142.15	142.15	142.12	142.14	20740.0
2012-10-31 08:00:00	SPY	ETF	142.14	142.21	140.55	142.12	313627.0
2012-10-31 08:05:00	SPY	ETF	142.1	142.12	142.04	142.04	10221.0
2012-10-31 08:10:00	SPY	ETF	142.04	142.06	141.8	142.03	131500.0
2012-10-31 08:15:00	SPY	ETF	142.03	142.13	142.01	142.12	19208.0
2012-10-31 08:20:00	SPY	ETF	142.1	142.11	142.02	142.05	16005.0
2012-10-31 08:25:00	SPY	ETF	142.03	142.03	141.94	141.97	33241.0
2012-10-31 08:30:00	SPY	ETF	141.97	142.01	141.96	141.98	13661.0
2012-10-31 08:35:00	SPY	ETF	141.98	142.0	141.95	141.96	29424.0
2012-10-31 08:40:00	SPY	ETF	141.96	141.97	141.93	141.93	27714.0
2012-10-31 08:45:00	SPY	ETF	141.94	142.02	141.93	141.98	10700.0
2012-10-31 08:50:00	SPY	ETF	141.97	142.26	141.92	142.03	383418.0
2012-10-31 08:55:00	SPY	ETF	142.02	142.03	141.97	141.98	24708.0
2012-10-31 09:00:00	SPY	ETF	141.98	141.98	141.87	141.87	64323.0
2012-10-31 09:05:00	SPY	ETF	141.87	141.96	141.84	141.93	76986.0

> showing 50 of 38,738 rows — these rows as CSV

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