PREVIEW / etf_1min / 2014-01-24

all etf 1-min files

  file:    by_date/etf_1min/2014/2014-01-24.parquet
  size:    2.9 MB
  rows:    142,353

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
2014-01-24 04:00:00	SPY	ETF	182.82	182.82	182.35	182.35	11134.0
2014-01-24 04:01:00	SPY	ETF	182.35	182.35	182.25	182.25	56360.0
2014-01-24 04:02:00	SPY	ETF	182.28	182.31	182.28	182.31	6100.0
2014-01-24 04:03:00	SPY	ETF	182.33	182.35	182.3	182.3	3025.0
2014-01-24 04:04:00	SPY	ETF	182.4	182.4	182.4	182.4	500.0
2014-01-24 04:05:00	SPY	ETF	182.39	182.39	182.35	182.35	2300.0
2014-01-24 04:07:00	SPY	ETF	182.4	182.4	182.39	182.39	1600.0
2014-01-24 04:08:00	SPY	ETF	182.39	182.39	182.35	182.35	2400.0
2014-01-24 04:09:00	SPY	ETF	182.33	182.33	182.31	182.31	1000.0
2014-01-24 04:10:00	SPY	ETF	182.28	182.28	182.25	182.25	2180.0
2014-01-24 04:11:00	SPY	ETF	182.28	182.28	182.23	182.23	2015.0
2014-01-24 04:12:00	SPY	ETF	182.28	182.29	182.25	182.28	3654.0
2014-01-24 04:13:00	SPY	ETF	182.28	182.33	182.28	182.29	4100.0
2014-01-24 04:14:00	SPY	ETF	182.33	182.33	182.31	182.31	2500.0
2014-01-24 04:15:00	SPY	ETF	182.28	182.28	182.28	182.28	500.0
2014-01-24 04:16:00	SPY	ETF	182.26	182.26	182.18	182.18	2171.0
2014-01-24 04:17:00	SPY	ETF	182.18	182.18	182.18	182.18	550.0
2014-01-24 04:18:00	SPY	ETF	182.22	182.22	182.18	182.18	1600.0
2014-01-24 04:20:00	SPY	ETF	182.19	182.19	182.18	182.18	603.0
2014-01-24 04:21:00	SPY	ETF	182.16	182.18	182.16	182.18	600.0
2014-01-24 04:24:00	SPY	ETF	182.18	182.23	182.18	182.23	11097.0
2014-01-24 04:27:00	SPY	ETF	182.25	182.25	182.25	182.25	500.0
2014-01-24 04:29:00	SPY	ETF	182.18	182.18	182.15	182.15	1310.0
2014-01-24 04:30:00	SPY	ETF	182.15	182.15	182.15	182.15	109.0
2014-01-24 04:32:00	SPY	ETF	182.1	182.1	182.1	182.1	100.0
2014-01-24 04:35:00	SPY	ETF	182.25	182.25	182.25	182.25	10000.0
2014-01-24 04:37:00	SPY	ETF	182.17	182.17	182.17	182.17	100.0
2014-01-24 04:38:00	SPY	ETF	182.17	182.17	182.17	182.17	100.0
2014-01-24 04:41:00	SPY	ETF	182.19	182.19	182.19	182.19	100.0
2014-01-24 04:43:00	SPY	ETF	182.21	182.21	182.21	182.21	194.0
2014-01-24 04:44:00	SPY	ETF	182.21	182.21	182.21	182.21	100.0
2014-01-24 04:45:00	SPY	ETF	182.26	182.26	182.26	182.26	177.0
2014-01-24 04:52:00	SPY	ETF	182.29	182.29	182.29	182.29	198.0
2014-01-24 04:55:00	SPY	ETF	182.32	182.32	182.32	182.32	200.0
2014-01-24 04:59:00	SPY	ETF	182.22	182.22	182.22	182.22	100.0
2014-01-24 05:03:00	SPY	ETF	182.07	182.07	182.07	182.07	175.0
2014-01-24 05:05:00	SPY	ETF	182.06	182.07	182.05	182.07	1064.0
2014-01-24 05:08:00	SPY	ETF	182.17	182.17	182.17	182.17	100.0
2014-01-24 05:12:00	SPY	ETF	182.07	182.07	182.07	182.07	1009.0
2014-01-24 05:15:00	SPY	ETF	182.04	182.05	182.04	182.05	255.0
2014-01-24 05:16:00	SPY	ETF	182.04	182.04	182.04	182.04	121.0
2014-01-24 05:17:00	SPY	ETF	182.05	182.05	182.05	182.05	7600.0
2014-01-24 05:21:00	SPY	ETF	182.05	182.05	182.05	182.05	500.0
2014-01-24 05:23:00	SPY	ETF	182.02	182.02	181.95	181.95	1495.0
2014-01-24 05:24:00	SPY	ETF	181.93	181.93	181.93	181.93	630.0
2014-01-24 05:26:00	SPY	ETF	181.94	181.95	181.91	181.91	2413.0
2014-01-24 05:28:00	SPY	ETF	181.9	181.9	181.87	181.88	15525.0
2014-01-24 05:29:00	SPY	ETF	181.88	181.88	181.88	181.88	1500.0
2014-01-24 05:30:00	SPY	ETF	181.88	181.88	181.88	181.88	500.0
2014-01-24 05:31:00	SPY	ETF	181.9	181.9	181.9	181.9	200.0

> showing 50 of 142,353 rows — these rows as CSV

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