PREVIEW / etf_5min / 2011-11-02

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-11-02.parquet
  size:    900 KB
  rows:    37,382

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-11-02 04:00:00	SPY	ETF	123.63	123.75	123.6	123.75	10057.0
2011-11-02 04:05:00	SPY	ETF	123.85	124.05	123.85	124.05	1350.0
2011-11-02 04:10:00	SPY	ETF	124.08	124.15	124.05	124.08	6462.0
2011-11-02 04:15:00	SPY	ETF	124.14	124.18	124.01	124.18	3560.0
2011-11-02 04:20:00	SPY	ETF	124.18	124.25	124.15	124.15	2900.0
2011-11-02 04:30:00	SPY	ETF	123.83	123.83	123.83	123.83	100.0
2011-11-02 04:35:00	SPY	ETF	123.98	124.2	123.98	124.18	900.0
2011-11-02 04:40:00	SPY	ETF	124.17	124.17	124.09	124.09	400.0
2011-11-02 04:45:00	SPY	ETF	123.93	124.09	123.91	124.09	3760.0
2011-11-02 04:55:00	SPY	ETF	123.78	123.88	123.78	123.81	400.0
2011-11-02 05:00:00	SPY	ETF	124.0	124.08	124.0	124.08	30150.0
2011-11-02 05:10:00	SPY	ETF	123.83	123.83	123.75	123.75	300.0
2011-11-02 05:15:00	SPY	ETF	123.7	123.7	123.64	123.64	700.0
2011-11-02 05:25:00	SPY	ETF	123.54	123.54	123.45	123.48	8100.0
2011-11-02 05:30:00	SPY	ETF	123.5	123.5	123.4	123.4	5070.0
2011-11-02 05:35:00	SPY	ETF	123.4	123.4	123.25	123.25	9000.0
2011-11-02 05:40:00	SPY	ETF	123.25	123.25	123.25	123.25	200.0
2011-11-02 05:45:00	SPY	ETF	123.2	123.25	123.18	123.18	25000.0
2011-11-02 05:50:00	SPY	ETF	123.11	123.11	122.61	122.8	3160.0
2011-11-02 05:55:00	SPY	ETF	122.78	122.9	122.78	122.8	21000.0
2011-11-02 06:00:00	SPY	ETF	122.8	123.02	122.8	123.0	9300.0
2011-11-02 06:05:00	SPY	ETF	123.0	123.15	122.98	123.15	6846.0
2011-11-02 06:10:00	SPY	ETF	123.18	123.22	123.13	123.22	5900.0
2011-11-02 06:15:00	SPY	ETF	123.25	123.25	123.16	123.18	3260.0
2011-11-02 06:20:00	SPY	ETF	123.1	123.13	123.05	123.05	7000.0
2011-11-02 06:25:00	SPY	ETF	123.19	123.24	123.19	123.24	5400.0
2011-11-02 06:30:00	SPY	ETF	123.24	123.32	123.16	123.19	15400.0
2011-11-02 06:35:00	SPY	ETF	123.25	123.37	123.25	123.34	17100.0
2011-11-02 06:40:00	SPY	ETF	123.3	123.3	123.21	123.21	3500.0
2011-11-02 06:45:00	SPY	ETF	123.35	123.39	123.3	123.3	5100.0
2011-11-02 06:50:00	SPY	ETF	123.37	123.44	123.34	123.44	74691.0
2011-11-02 06:55:00	SPY	ETF	123.39	123.39	123.25	123.25	1500.0
2011-11-02 07:00:00	SPY	ETF	123.23	123.27	123.08	123.1	34750.0
2011-11-02 07:05:00	SPY	ETF	123.08	123.29	123.08	123.21	4210.0
2011-11-02 07:10:00	SPY	ETF	123.18	123.18	123.1	123.12	15700.0
2011-11-02 07:15:00	SPY	ETF	123.16	123.26	123.12	123.25	43600.0
2011-11-02 07:20:00	SPY	ETF	123.23	123.46	123.23	123.38	32100.0
2011-11-02 07:25:00	SPY	ETF	123.39	123.58	123.39	123.51	206550.0
2011-11-02 07:30:00	SPY	ETF	123.51	123.51	123.39	123.45	83600.0
2011-11-02 07:35:00	SPY	ETF	123.51	123.51	123.35	123.37	70500.0
2011-11-02 07:40:00	SPY	ETF	123.34	123.53	123.31	123.49	16190.0
2011-11-02 07:45:00	SPY	ETF	123.52	123.63	123.43	123.56	140732.0
2011-11-02 07:50:00	SPY	ETF	123.61	123.62	123.48	123.52	121350.0
2011-11-02 07:55:00	SPY	ETF	123.5	123.52	123.4	123.4	26912.0
2011-11-02 08:00:00	SPY	ETF	123.43	123.5796	123.39	123.51	133417.0
2011-11-02 08:05:00	SPY	ETF	123.5	123.73	123.5	123.71	139508.0
2011-11-02 08:10:00	SPY	ETF	123.67	124.04	123.56	123.64	249081.0
2011-11-02 08:15:00	SPY	ETF	123.7	123.84	123.69	123.74	504767.0
2011-11-02 08:20:00	SPY	ETF	123.74	123.76	123.53	123.59	382937.0
2011-11-02 08:25:00	SPY	ETF	123.6	123.7	123.46	123.68	488925.0

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

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