PREVIEW / etf_5min / 2013-10-09

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-10-09.parquet
  size:    1010 KB
  rows:    41,884

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
2013-10-09 04:00:00	SPY	ETF	165.98	166.0	165.96	165.98	12600.0
2013-10-09 04:05:00	SPY	ETF	165.95	165.98	165.91	165.93	7468.0
2013-10-09 04:10:00	SPY	ETF	165.95	166.12	165.95	166.12	2400.0
2013-10-09 04:15:00	SPY	ETF	166.09	166.09	166.02	166.02	1200.0
2013-10-09 04:20:00	SPY	ETF	166.01	166.01	165.98	165.98	1370.0
2013-10-09 04:25:00	SPY	ETF	165.98	165.98	165.95	165.95	1240.0
2013-10-09 04:30:00	SPY	ETF	165.93	165.96	165.91	165.95	9835.0
2013-10-09 04:35:00	SPY	ETF	165.98	165.99	165.93	165.98	900.0
2013-10-09 04:40:00	SPY	ETF	165.97	165.97	165.97	165.97	100.0
2013-10-09 04:45:00	SPY	ETF	165.95	165.97	165.93	165.97	900.0
2013-10-09 04:55:00	SPY	ETF	165.99	166.08	165.99	166.08	1600.0
2013-10-09 05:05:00	SPY	ETF	166.09	166.1	166.09	166.1	1300.0
2013-10-09 05:10:00	SPY	ETF	166.11	166.19	166.11	166.19	7100.0
2013-10-09 05:15:00	SPY	ETF	166.2	166.29	166.2	166.27	5600.0
2013-10-09 05:20:00	SPY	ETF	166.23	166.23	166.23	166.23	300.0
2013-10-09 05:25:00	SPY	ETF	166.25	166.27	166.25	166.27	400.0
2013-10-09 05:30:00	SPY	ETF	166.23	166.23	166.23	166.23	100.0
2013-10-09 05:35:00	SPY	ETF	166.23	166.23	166.19	166.19	1800.0
2013-10-09 05:50:00	SPY	ETF	166.17	166.17	166.17	166.17	119.0
2013-10-09 05:55:00	SPY	ETF	166.18	166.18	166.07	166.07	1200.0
2013-10-09 06:00:00	SPY	ETF	166.05	166.13	166.05	166.09	29700.0
2013-10-09 06:05:00	SPY	ETF	166.11	166.18	166.11	166.18	1479.0
2013-10-09 06:10:00	SPY	ETF	166.15	166.15	166.09	166.15	2000.0
2013-10-09 06:15:00	SPY	ETF	166.13	166.16	166.09	166.11	2400.0
2013-10-09 06:20:00	SPY	ETF	166.06	166.1	166.05	166.1	1600.0
2013-10-09 06:25:00	SPY	ETF	166.11	166.11	166.09	166.09	300.0
2013-10-09 06:30:00	SPY	ETF	166.09	166.09	166.05	166.05	1471.0
2013-10-09 06:35:00	SPY	ETF	166.05	166.14	166.05	166.14	6100.0
2013-10-09 06:40:00	SPY	ETF	166.15	166.17	166.15	166.15	4240.0
2013-10-09 06:45:00	SPY	ETF	166.15	166.16	166.09	166.09	4800.0
2013-10-09 06:50:00	SPY	ETF	166.11	166.16	166.11	166.16	10160.0
2013-10-09 06:55:00	SPY	ETF	166.16	166.18	166.12	166.12	5854.0
2013-10-09 07:00:00	SPY	ETF	166.15	166.25	166.15	166.23	45591.0
2013-10-09 07:05:00	SPY	ETF	166.22	166.26	166.18	166.21	36297.0
2013-10-09 07:10:00	SPY	ETF	166.21	166.21	166.16	166.16	18290.0
2013-10-09 07:15:00	SPY	ETF	166.16	166.165	166.15	166.15	31600.0
2013-10-09 07:20:00	SPY	ETF	166.16	166.16	166.08	166.14	11350.0
2013-10-09 07:25:00	SPY	ETF	166.12	166.14	166.09	166.14	49464.0
2013-10-09 07:30:00	SPY	ETF	166.11	166.11	166.01	166.08	112180.0
2013-10-09 07:35:00	SPY	ETF	166.08	166.08	166.03	166.03	110610.0
2013-10-09 07:40:00	SPY	ETF	166.03	166.06	165.93	165.94	47927.0
2013-10-09 07:45:00	SPY	ETF	165.94	165.96	165.9	165.92	20936.0
2013-10-09 07:50:00	SPY	ETF	165.94	165.95	165.93	165.93	9000.0
2013-10-09 07:55:00	SPY	ETF	165.95	165.97	165.9	165.9	157300.0
2013-10-09 08:00:00	SPY	ETF	166.25	166.25	165.73	165.75	169325.0
2013-10-09 08:05:00	SPY	ETF	165.76	165.8	165.73	165.8	28000.0
2013-10-09 08:10:00	SPY	ETF	165.8	165.91	165.7	165.91	90444.0
2013-10-09 08:15:00	SPY	ETF	165.9	165.97	165.86	165.96	44758.0
2013-10-09 08:20:00	SPY	ETF	165.94	166.03	165.93	165.99	115673.0
2013-10-09 08:25:00	SPY	ETF	166.0	166.05	165.98	166.0	45411.0

> showing 50 of 41,884 rows — these rows as CSV

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