PREVIEW / etf_5min / 2013-01-14

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-01-14.parquet
  size:    884 KB
  rows:    39,282

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-01-14 04:00:00	SPY	ETF	147.23	147.31	147.23	147.28	606.0
2013-01-14 04:20:00	SPY	ETF	147.29	147.29	147.29	147.29	100.0
2013-01-14 04:25:00	SPY	ETF	147.37	147.37	147.37	147.37	62600.0
2013-01-14 04:35:00	SPY	ETF	147.45	147.45	147.45	147.45	19908.0
2013-01-14 04:40:00	SPY	ETF	147.41	147.41	147.41	147.41	25000.0
2013-01-14 04:50:00	SPY	ETF	147.3	147.3	147.3	147.3	300.0
2013-01-14 05:10:00	SPY	ETF	147.38	147.44	147.36	147.41	25500.0
2013-01-14 05:50:00	SPY	ETF	147.28	147.28	147.28	147.28	100.0
2013-01-14 05:55:00	SPY	ETF	147.22	147.22	147.22	147.22	9000.0
2013-01-14 06:00:00	SPY	ETF	147.22	147.22	147.22	147.22	100.0
2013-01-14 06:05:00	SPY	ETF	147.19	147.2	147.19	147.2	5000.0
2013-01-14 06:10:00	SPY	ETF	147.16	147.16	147.16	147.16	100.0
2013-01-14 06:15:00	SPY	ETF	147.21	147.21	147.21	147.21	6200.0
2013-01-14 06:20:00	SPY	ETF	147.2	147.2	147.2	147.2	300.0
2013-01-14 06:25:00	SPY	ETF	147.21	147.21	147.14	147.14	23230.0
2013-01-14 06:30:00	SPY	ETF	147.18	147.18	147.15	147.15	10300.0
2013-01-14 06:35:00	SPY	ETF	147.2	147.2	147.14	147.16	10200.0
2013-01-14 06:40:00	SPY	ETF	147.19	147.19	147.15	147.16	10500.0
2013-01-14 06:45:00	SPY	ETF	147.16	147.2	147.16	147.19	25700.0
2013-01-14 06:50:00	SPY	ETF	147.22	147.22	147.18	147.18	59000.0
2013-01-14 07:00:00	SPY	ETF	147.19	147.22	147.18	147.2	27921.0
2013-01-14 07:05:00	SPY	ETF	147.21	147.22	147.2	147.2	4200.0
2013-01-14 07:10:00	SPY	ETF	147.2	147.2	147.06	147.07	15100.0
2013-01-14 07:15:00	SPY	ETF	147.07	147.08	147.05	147.05	25382.0
2013-01-14 07:20:00	SPY	ETF	147.05	147.06	147.03	147.03	3600.0
2013-01-14 07:25:00	SPY	ETF	147.04	147.05	146.98	146.98	176293.0
2013-01-14 07:30:00	SPY	ETF	146.99	147.02	146.97	147.02	141117.0
2013-01-14 07:35:00	SPY	ETF	147.04	147.04	146.93	146.96	28300.0
2013-01-14 07:40:00	SPY	ETF	146.96	146.97	146.96	146.97	2846.0
2013-01-14 07:45:00	SPY	ETF	146.96	146.96	146.88	146.93	16849.0
2013-01-14 07:50:00	SPY	ETF	146.91	146.92	146.88	146.9	18255.0
2013-01-14 07:55:00	SPY	ETF	146.91	146.94	146.89	146.89	3800.0
2013-01-14 08:00:00	SPY	ETF	146.92	147.2	146.85	146.89	40457.0
2013-01-14 08:05:00	SPY	ETF	146.87	147.04	146.87	146.9	31578.0
2013-01-14 08:10:00	SPY	ETF	146.9	146.9	146.82	146.83	110164.0
2013-01-14 08:15:00	SPY	ETF	146.84	146.9	146.84	146.89	127522.0
2013-01-14 08:20:00	SPY	ETF	146.89	146.92	146.86	146.91	114200.0
2013-01-14 08:25:00	SPY	ETF	146.92	147.02	146.9	147.0	508198.0
2013-01-14 08:30:00	SPY	ETF	147.0	147.05	147.0	147.04	100224.0
2013-01-14 08:35:00	SPY	ETF	147.03	147.03	146.99	147.0	428078.0
2013-01-14 08:40:00	SPY	ETF	146.99	147.03	146.98	146.98	81831.0
2013-01-14 08:45:00	SPY	ETF	147.0	147.01	146.99	147.0	26997.0
2013-01-14 08:50:00	SPY	ETF	147.0	147.03	146.99	147.02	216465.0
2013-01-14 08:55:00	SPY	ETF	147.02	147.03	146.97	146.98	101115.0
2013-01-14 09:00:00	SPY	ETF	147.0	147.07	146.9	146.91	119639.0
2013-01-14 09:05:00	SPY	ETF	146.91	146.92	146.88	146.91	74374.0
2013-01-14 09:10:00	SPY	ETF	146.91	146.93	146.9	146.93	112630.0
2013-01-14 09:15:00	SPY	ETF	146.93	146.93	146.88	146.9	80348.0
2013-01-14 09:20:00	SPY	ETF	146.9	146.91	146.85	146.86	142307.0
2013-01-14 09:25:00	SPY	ETF	146.87	146.9	146.85	146.89	152129.0

> showing 50 of 39,282 rows — these rows as CSV

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