PREVIEW / etf_5min / 2012-04-26

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-26.parquet
  size:    861 KB
  rows:    35,655

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-04-26 04:00:00	SPY	ETF	139.42	139.66	139.42	139.6	3328.0
2012-04-26 04:05:00	SPY	ETF	139.6	139.6	139.6	139.6	500.0
2012-04-26 04:10:00	SPY	ETF	139.59	139.59	139.59	139.59	500.0
2012-04-26 04:15:00	SPY	ETF	139.59	139.59	139.5	139.5	1000.0
2012-04-26 04:20:00	SPY	ETF	139.54	139.54	139.54	139.54	300.0
2012-04-26 04:30:00	SPY	ETF	139.65	139.65	139.65	139.65	100.0
2012-04-26 04:55:00	SPY	ETF	139.42	139.42	139.4	139.4	500.0
2012-04-26 05:00:00	SPY	ETF	139.39	139.39	139.39	139.39	1000.0
2012-04-26 05:10:00	SPY	ETF	139.37	139.37	139.37	139.37	100.0
2012-04-26 05:15:00	SPY	ETF	139.43	139.43	139.43	139.43	200.0
2012-04-26 05:30:00	SPY	ETF	139.19	139.19	139.06	139.06	500.0
2012-04-26 05:40:00	SPY	ETF	139.12	139.12	139.12	139.12	2400.0
2012-04-26 06:00:00	SPY	ETF	139.08	139.08	138.98	138.99	22800.0
2012-04-26 06:05:00	SPY	ETF	139.04	139.04	139.04	139.04	1500.0
2012-04-26 06:10:00	SPY	ETF	139.12	139.12	139.12	139.12	2000.0
2012-04-26 06:15:00	SPY	ETF	139.1	139.1	139.04	139.04	480.0
2012-04-26 06:20:00	SPY	ETF	139.05	139.05	139.03	139.03	800.0
2012-04-26 06:30:00	SPY	ETF	138.96	138.96	138.9	138.95	12200.0
2012-04-26 06:35:00	SPY	ETF	138.91	138.91	138.89	138.9	2700.0
2012-04-26 06:40:00	SPY	ETF	139.04	139.04	138.94	138.94	11100.0
2012-04-26 06:45:00	SPY	ETF	139.02	139.02	139.02	139.02	100.0
2012-04-26 06:55:00	SPY	ETF	139.02	139.07	139.02	139.07	1000.0
2012-04-26 07:00:00	SPY	ETF	139.07	139.07	139.0	139.0	6250.0
2012-04-26 07:05:00	SPY	ETF	139.02	139.09	139.0	139.01	7275.0
2012-04-26 07:10:00	SPY	ETF	139.07	139.09	139.07	139.07	20200.0
2012-04-26 07:15:00	SPY	ETF	139.07	139.07	139.05	139.05	1100.0
2012-04-26 07:20:00	SPY	ETF	139.03	139.03	138.98	139.0	3900.0
2012-04-26 07:25:00	SPY	ETF	139.01	139.05	139.0	139.04	29107.0
2012-04-26 07:30:00	SPY	ETF	139.01	139.08	139.01	139.08	26600.0
2012-04-26 07:35:00	SPY	ETF	139.1	139.17	139.1	139.17	16600.0
2012-04-26 07:40:00	SPY	ETF	139.15	139.19	139.13	139.14	33900.0
2012-04-26 07:45:00	SPY	ETF	139.1	139.13	139.05	139.13	14399.0
2012-04-26 07:50:00	SPY	ETF	139.13	139.13	139.1	139.1	11600.0
2012-04-26 07:55:00	SPY	ETF	139.13	139.19	139.13	139.19	2930.0
2012-04-26 08:00:00	SPY	ETF	139.19	139.24	139.0	139.2	159582.0
2012-04-26 08:05:00	SPY	ETF	139.22	139.22	139.16	139.18	163950.0
2012-04-26 08:10:00	SPY	ETF	139.18	139.18	139.08	139.11	123500.0
2012-04-26 08:15:00	SPY	ETF	139.1	139.11	139.0	139.05	191150.0
2012-04-26 08:20:00	SPY	ETF	139.06	139.1	138.99	139.03	105262.0
2012-04-26 08:25:00	SPY	ETF	139.06	139.06	138.92	139.0	28330.0
2012-04-26 08:30:00	SPY	ETF	138.9	139.07	138.75	138.85	727763.0
2012-04-26 08:35:00	SPY	ETF	138.85	138.89	138.7	138.73	215677.0
2012-04-26 08:40:00	SPY	ETF	138.73	138.83	138.72	138.77	134165.0
2012-04-26 08:45:00	SPY	ETF	138.76	138.76	138.62	138.7	262246.0
2012-04-26 08:50:00	SPY	ETF	138.7	138.81	138.68	138.75	173071.0
2012-04-26 08:55:00	SPY	ETF	138.76	138.88	138.76	138.86	149047.0
2012-04-26 09:00:00	SPY	ETF	138.85	138.86	138.75	138.8	844900.0
2012-04-26 09:05:00	SPY	ETF	138.8	138.84	138.77	138.79	100596.0
2012-04-26 09:10:00	SPY	ETF	138.8	138.87	138.77	138.77	173483.0
2012-04-26 09:15:00	SPY	ETF	138.79	138.85	138.76	138.84	115795.0

> showing 50 of 35,655 rows — these rows as CSV

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