PREVIEW / etf_5min / 2011-10-19

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-10-19.parquet
  size:    874 KB
  rows:    35,983

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-10-19 04:00:00	SPY	ETF	122.02	122.29	122.02	122.29	10300.0
2011-10-19 04:05:00	SPY	ETF	122.14	122.14	122.14	122.14	7300.0
2011-10-19 04:10:00	SPY	ETF	122.34	122.34	122.09	122.09	5800.0
2011-10-19 04:15:00	SPY	ETF	122.09	122.09	121.92	122.07	11160.0
2011-10-19 04:20:00	SPY	ETF	122.16	122.16	122.16	122.16	100.0
2011-10-19 04:25:00	SPY	ETF	122.22	122.22	122.22	122.22	200.0
2011-10-19 04:40:00	SPY	ETF	122.18	122.19	122.18	122.19	650.0
2011-10-19 04:45:00	SPY	ETF	122.29	122.29	122.21	122.29	400.0
2011-10-19 04:50:00	SPY	ETF	122.24	122.24	122.24	122.24	200.0
2011-10-19 04:55:00	SPY	ETF	122.31	122.41	122.31	122.41	300.0
2011-10-19 05:05:00	SPY	ETF	122.62	122.62	122.62	122.62	100.0
2011-10-19 05:10:00	SPY	ETF	122.95	122.95	122.95	122.95	200.0
2011-10-19 05:15:00	SPY	ETF	122.88	122.88	122.88	122.88	100.0
2011-10-19 05:25:00	SPY	ETF	122.81	122.81	122.81	122.81	10000.0
2011-10-19 05:30:00	SPY	ETF	122.89	122.9	122.89	122.9	200.0
2011-10-19 05:35:00	SPY	ETF	122.98	123.04	122.98	123.04	5100.0
2011-10-19 05:40:00	SPY	ETF	123.01	123.01	122.96	122.96	600.0
2011-10-19 05:45:00	SPY	ETF	122.97	122.97	122.9	122.9	20200.0
2011-10-19 05:50:00	SPY	ETF	123.01	123.01	122.98	122.98	5150.0
2011-10-19 05:55:00	SPY	ETF	123.11	123.11	123.11	123.11	150.0
2011-10-19 06:00:00	SPY	ETF	123.1	123.16	123.1	123.16	12360.0
2011-10-19 06:05:00	SPY	ETF	123.1	123.1	122.91	122.91	11600.0
2011-10-19 06:10:00	SPY	ETF	123.0	123.0	122.94	122.94	3800.0
2011-10-19 06:15:00	SPY	ETF	122.86	122.86	122.86	122.86	100.0
2011-10-19 06:25:00	SPY	ETF	122.91	122.91	122.8	122.8	58000.0
2011-10-19 06:35:00	SPY	ETF	122.83	122.88	122.83	122.87	300.0
2011-10-19 06:40:00	SPY	ETF	122.96	123.0	122.96	123.0	1800.0
2011-10-19 06:45:00	SPY	ETF	123.0	123.2	123.0	123.2	17600.0
2011-10-19 06:50:00	SPY	ETF	123.12	123.28	123.12	123.21	34625.0
2011-10-19 06:55:00	SPY	ETF	123.15	123.2	123.12	123.2	5100.0
2011-10-19 07:00:00	SPY	ETF	123.15	123.15	123.05	123.11	20000.0
2011-10-19 07:05:00	SPY	ETF	123.11	123.19	123.11	123.14	21590.0
2011-10-19 07:10:00	SPY	ETF	123.09	123.11	123.02	123.03	22650.0
2011-10-19 07:15:00	SPY	ETF	123.05	123.1	123.01	123.02	28200.0
2011-10-19 07:20:00	SPY	ETF	123.05	123.07	122.91	122.94	61115.0
2011-10-19 07:25:00	SPY	ETF	122.98	122.99	122.89	122.93	5968.0
2011-10-19 07:30:00	SPY	ETF	122.93	122.93	122.81	122.83	4828.0
2011-10-19 07:35:00	SPY	ETF	122.83	122.83	122.69	122.69	22550.0
2011-10-19 07:40:00	SPY	ETF	122.7	122.81	122.67	122.75	61950.0
2011-10-19 07:45:00	SPY	ETF	122.84	122.84	122.54	122.57	34410.0
2011-10-19 07:50:00	SPY	ETF	122.54	122.61	122.46	122.58	107750.0
2011-10-19 07:55:00	SPY	ETF	122.58	122.59	122.46	122.5	63010.0
2011-10-19 08:00:00	SPY	ETF	122.47	122.63	122.16	122.59	233094.0
2011-10-19 08:05:00	SPY	ETF	122.59	122.59	122.49	122.55	89350.0
2011-10-19 08:10:00	SPY	ETF	122.56	122.61	122.16	122.61	65440.0
2011-10-19 08:15:00	SPY	ETF	122.62	122.62	122.49	122.5	30359.0
2011-10-19 08:20:00	SPY	ETF	122.5	122.52	122.4	122.43	48173.0
2011-10-19 08:25:00	SPY	ETF	122.43	122.49	122.29	122.41	183433.0
2011-10-19 08:30:00	SPY	ETF	122.49	122.72	122.49	122.58	726641.0
2011-10-19 08:35:00	SPY	ETF	122.59	122.84	122.59	122.78	323856.0

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

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