PREVIEW / etf_5min / 2012-04-10

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-10.parquet
  size:    986 KB
  rows:    40,151

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-04-10 04:15:00	SPY	ETF	138.24	138.24	138.24	138.24	800.0
2012-04-10 04:20:00	SPY	ETF	138.31	138.39	138.31	138.39	1000.0
2012-04-10 04:40:00	SPY	ETF	138.5	138.5	138.5	138.5	1000.0
2012-04-10 04:45:00	SPY	ETF	138.44	138.44	138.44	138.44	100.0
2012-04-10 04:50:00	SPY	ETF	138.39	138.42	138.39	138.42	700.0
2012-04-10 05:00:00	SPY	ETF	138.37	138.38	138.37	138.38	600.0
2012-04-10 05:05:00	SPY	ETF	138.4	138.4	138.4	138.4	1505.0
2012-04-10 05:15:00	SPY	ETF	138.29	138.29	138.29	138.29	299.0
2012-04-10 05:55:00	SPY	ETF	138.42	138.42	138.42	138.42	2500.0
2012-04-10 06:00:00	SPY	ETF	138.37	138.37	138.37	138.37	2500.0
2012-04-10 06:20:00	SPY	ETF	138.19	138.19	138.19	138.19	100.0
2012-04-10 06:25:00	SPY	ETF	138.35	138.35	138.35	138.35	5000.0
2012-04-10 06:30:00	SPY	ETF	138.27	138.27	138.27	138.27	5000.0
2012-04-10 06:40:00	SPY	ETF	138.39	138.4	138.39	138.4	5000.0
2012-04-10 06:45:00	SPY	ETF	138.4	138.4	138.4	138.4	1000.0
2012-04-10 06:50:00	SPY	ETF	138.25	138.26	138.22	138.26	10900.0
2012-04-10 07:00:00	SPY	ETF	138.16	138.23	138.15	138.22	27430.0
2012-04-10 07:05:00	SPY	ETF	138.21	138.21	138.2	138.2	1800.0
2012-04-10 07:10:00	SPY	ETF	138.2	138.22	138.17	138.22	12600.0
2012-04-10 07:15:00	SPY	ETF	138.22	138.22	138.2	138.2	2400.0
2012-04-10 07:20:00	SPY	ETF	138.23	138.23	138.18	138.18	5000.0
2012-04-10 07:25:00	SPY	ETF	138.18	138.18	138.1	138.13	3450.0
2012-04-10 07:30:00	SPY	ETF	138.12	138.12	137.94	137.99	86154.0
2012-04-10 07:35:00	SPY	ETF	137.99	138.04	137.97	138.0	66908.0
2012-04-10 07:40:00	SPY	ETF	138.01	138.06	138.0	138.06	10300.0
2012-04-10 07:45:00	SPY	ETF	138.06	138.11	138.05	138.11	11925.0
2012-04-10 07:50:00	SPY	ETF	138.1	138.13	138.07	138.13	22592.0
2012-04-10 07:55:00	SPY	ETF	138.11	138.2	138.11	138.2	7500.0
2012-04-10 08:00:00	SPY	ETF	138.23	138.26	138.09	138.21	35665.0
2012-04-10 08:05:00	SPY	ETF	138.01	138.26	138.01	138.23	349178.0
2012-04-10 08:10:00	SPY	ETF	138.23	138.24	138.15	138.19	48301.0
2012-04-10 08:15:00	SPY	ETF	138.19	138.19	138.09	138.15	60871.0
2012-04-10 08:20:00	SPY	ETF	138.15	138.15	138.04	138.05	52200.0
2012-04-10 08:25:00	SPY	ETF	138.07	138.15	138.05	138.15	24052.0
2012-04-10 08:30:00	SPY	ETF	138.15	138.22	138.14	138.16	55710.0
2012-04-10 08:35:00	SPY	ETF	138.15	138.18	138.12	138.17	26803.0
2012-04-10 08:40:00	SPY	ETF	138.18	138.18	138.05	138.08	113425.0
2012-04-10 08:45:00	SPY	ETF	138.08	138.13	138.02	138.09	100440.0
2012-04-10 08:50:00	SPY	ETF	138.1	138.12	138.04	138.05	78730.0
2012-04-10 08:55:00	SPY	ETF	138.04	138.1	138.04	138.06	122146.0
2012-04-10 09:00:00	SPY	ETF	138.06	138.09	137.98	137.99	112636.0
2012-04-10 09:05:00	SPY	ETF	137.98	138.01	137.9	137.94	306499.0
2012-04-10 09:10:00	SPY	ETF	137.94	137.94	137.8346	137.9	285033.0
2012-04-10 09:15:00	SPY	ETF	137.9	137.97	137.9	137.94	133869.0
2012-04-10 09:20:00	SPY	ETF	137.94	138.02	137.94	137.99	109088.0
2012-04-10 09:25:00	SPY	ETF	137.99	138.03	137.94	137.95	392185.0
2012-04-10 09:30:00	SPY	ETF	137.95	138.19	137.83	138.15	3686058.0
2012-04-10 09:35:00	SPY	ETF	138.15	138.25	138.11	138.24	2249463.0
2012-04-10 09:40:00	SPY	ETF	138.2322	138.34	138.22	138.28	1668724.0
2012-04-10 09:45:00	SPY	ETF	138.28	138.29	138.16	138.172	2316397.0

> showing 50 of 40,151 rows — these rows as CSV

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