PREVIEW / etf_5min / 2012-10-18

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-10-18.parquet
  size:    843 KB
  rows:    35,554

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-18 04:00:00	SPY	ETF	146.1	146.1	146.02	146.03	500.0
2012-10-18 04:05:00	SPY	ETF	146.04	146.04	146.04	146.04	200.0
2012-10-18 04:10:00	SPY	ETF	146.04	146.04	146.04	146.04	100.0
2012-10-18 04:15:00	SPY	ETF	146.04	146.04	146.04	146.04	200.0
2012-10-18 04:25:00	SPY	ETF	146.04	146.04	146.04	146.04	100.0
2012-10-18 04:50:00	SPY	ETF	146.2	146.2	146.2	146.2	600.0
2012-10-18 05:35:00	SPY	ETF	146.18	146.2	146.18	146.2	2162.0
2012-10-18 05:40:00	SPY	ETF	146.26	146.26	146.21	146.21	900.0
2012-10-18 05:50:00	SPY	ETF	146.21	146.21	146.18	146.18	25500.0
2012-10-18 06:25:00	SPY	ETF	146.2	146.24	146.2	146.24	200.0
2012-10-18 06:30:00	SPY	ETF	146.21	146.21	146.21	146.21	300.0
2012-10-18 06:35:00	SPY	ETF	146.15	146.15	146.11	146.11	13400.0
2012-10-18 06:45:00	SPY	ETF	146.19	146.19	146.19	146.19	100.0
2012-10-18 06:50:00	SPY	ETF	146.14	146.16	146.14	146.16	400.0
2012-10-18 06:55:00	SPY	ETF	146.12	146.12	146.06	146.12	15200.0
2012-10-18 07:00:00	SPY	ETF	146.04	146.05	146.03	146.03	15616.0
2012-10-18 07:05:00	SPY	ETF	146.06	146.06	146.06	146.06	1500.0
2012-10-18 07:10:00	SPY	ETF	146.08	146.09	146.07	146.07	8300.0
2012-10-18 07:15:00	SPY	ETF	146.07	146.08	146.02	146.02	19383.0
2012-10-18 07:20:00	SPY	ETF	146.02	146.04	146.01	146.04	27094.0
2012-10-18 07:25:00	SPY	ETF	146.02	146.04	146.01	146.01	3750.0
2012-10-18 07:30:00	SPY	ETF	146.04	146.04	146.01	146.01	2625.0
2012-10-18 07:35:00	SPY	ETF	146.03	146.04	146.01	146.01	6545.0
2012-10-18 07:40:00	SPY	ETF	146.02	146.02	145.93	145.98	15441.0
2012-10-18 07:45:00	SPY	ETF	145.98	146.02	145.96	146.02	11125.0
2012-10-18 07:50:00	SPY	ETF	145.99	145.99	145.99	145.99	100.0
2012-10-18 07:55:00	SPY	ETF	145.97	146.0	145.97	146.0	14800.0
2012-10-18 08:00:00	SPY	ETF	146.0	146.07	145.98	146.06	43802.0
2012-10-18 08:05:00	SPY	ETF	146.07	146.11	146.06	146.11	37740.0
2012-10-18 08:10:00	SPY	ETF	146.12	146.12	146.1	146.11	19066.0
2012-10-18 08:15:00	SPY	ETF	146.11	146.14	146.09	146.12	38470.0
2012-10-18 08:20:00	SPY	ETF	146.12	146.14	146.12	146.14	7100.0
2012-10-18 08:25:00	SPY	ETF	146.12	146.28	146.1	146.28	103762.0
2012-10-18 08:30:00	SPY	ETF	146.28	146.28	145.88	145.92	442259.0
2012-10-18 08:35:00	SPY	ETF	145.91	145.93	145.83	145.86	483470.0
2012-10-18 08:40:00	SPY	ETF	145.87	145.88	145.84	145.88	40707.0
2012-10-18 08:45:00	SPY	ETF	145.89	145.92	145.88	145.92	20688.0
2012-10-18 08:50:00	SPY	ETF	145.92	145.93	145.83	145.86	97945.0
2012-10-18 08:55:00	SPY	ETF	145.86	146.1	145.81	145.84	46780.0
2012-10-18 09:00:00	SPY	ETF	145.83	145.85	145.8	145.81	46665.0
2012-10-18 09:05:00	SPY	ETF	145.8	145.81	145.73	145.77	118747.0
2012-10-18 09:10:00	SPY	ETF	145.77	145.78	145.75	145.76	85300.0
2012-10-18 09:15:00	SPY	ETF	145.75	145.82	145.74	145.82	69152.0
2012-10-18 09:20:00	SPY	ETF	145.82	145.84	145.8	145.81	28846.0
2012-10-18 09:25:00	SPY	ETF	145.81	145.83	145.79	145.83	210413.0
2012-10-18 09:30:00	SPY	ETF	145.82	145.88	145.76	145.83	2254077.0
2012-10-18 09:35:00	SPY	ETF	145.83	145.97	145.83	145.851	1725214.0
2012-10-18 09:40:00	SPY	ETF	145.86	145.91	145.75	145.88	1637261.0
2012-10-18 09:45:00	SPY	ETF	145.89	145.93	145.79	145.85	3527060.0
2012-10-18 09:50:00	SPY	ETF	145.84	145.89	145.81	145.83	2036535.0

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

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