PREVIEW / etf_5min / 2012-03-14

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-03-14.parquet
  size:    926 KB
  rows:    38,280

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-03-14 04:05:00	SPY	ETF	139.97	139.97	139.97	139.97	100.0
2012-03-14 04:10:00	SPY	ETF	139.97	140.06	139.96	139.96	1700.0
2012-03-14 04:25:00	SPY	ETF	139.93	139.93	139.93	139.93	260.0
2012-03-14 04:30:00	SPY	ETF	139.9	139.93	139.9	139.93	410.0
2012-03-14 04:35:00	SPY	ETF	139.98	140.0	139.98	140.0	5880.0
2012-03-14 04:40:00	SPY	ETF	140.03	140.03	140.0	140.0	7000.0
2012-03-14 04:45:00	SPY	ETF	139.99	139.99	139.99	139.99	1000.0
2012-03-14 04:50:00	SPY	ETF	140.0	140.0	140.0	140.0	5000.0
2012-03-14 04:55:00	SPY	ETF	140.02	140.03	140.02	140.03	1600.0
2012-03-14 05:00:00	SPY	ETF	140.06	140.1	140.06	140.1	5375.0
2012-03-14 05:05:00	SPY	ETF	140.09	140.1	140.09	140.1	600.0
2012-03-14 05:10:00	SPY	ETF	140.11	140.14	140.11	140.14	10300.0
2012-03-14 05:15:00	SPY	ETF	140.12	140.15	140.12	140.15	6700.0
2012-03-14 05:20:00	SPY	ETF	140.17	140.2	140.17	140.2	5000.0
2012-03-14 05:25:00	SPY	ETF	140.18	140.18	140.18	140.18	100.0
2012-03-14 05:30:00	SPY	ETF	140.15	140.15	140.08	140.08	5800.0
2012-03-14 05:35:00	SPY	ETF	140.12	140.15	140.12	140.15	8500.0
2012-03-14 05:45:00	SPY	ETF	140.11	140.11	140.1	140.11	30200.0
2012-03-14 05:50:00	SPY	ETF	140.11	140.14	140.11	140.13	1300.0
2012-03-14 05:55:00	SPY	ETF	140.13	140.17	140.13	140.17	5000.0
2012-03-14 06:00:00	SPY	ETF	140.15	140.15	140.15	140.15	3250.0
2012-03-14 06:05:00	SPY	ETF	140.17	140.2	140.17	140.2	12150.0
2012-03-14 06:10:00	SPY	ETF	140.19	140.21	140.18	140.2	10800.0
2012-03-14 06:20:00	SPY	ETF	140.21	140.23	140.21	140.23	500.0
2012-03-14 06:25:00	SPY	ETF	140.22	140.22	140.22	140.22	100.0
2012-03-14 06:30:00	SPY	ETF	140.24	140.33	140.24	140.32	26700.0
2012-03-14 06:35:00	SPY	ETF	140.34	140.36	140.32	140.35	17200.0
2012-03-14 06:40:00	SPY	ETF	140.36	140.36	140.33	140.33	1000.0
2012-03-14 06:45:00	SPY	ETF	140.35	140.35	140.32	140.33	6200.0
2012-03-14 06:50:00	SPY	ETF	140.33	140.35	140.32	140.32	16700.0
2012-03-14 06:55:00	SPY	ETF	140.32	140.37	140.32	140.37	36400.0
2012-03-14 07:00:00	SPY	ETF	140.37	140.39	140.35	140.38	25800.0
2012-03-14 07:05:00	SPY	ETF	140.33	140.34	140.3	140.32	12475.0
2012-03-14 07:10:00	SPY	ETF	140.31	140.34	140.31	140.31	30300.0
2012-03-14 07:15:00	SPY	ETF	140.34	140.37	140.27	140.27	12200.0
2012-03-14 07:20:00	SPY	ETF	140.3	140.31	140.26	140.29	11550.0
2012-03-14 07:25:00	SPY	ETF	140.29	140.31	140.25	140.29	12800.0
2012-03-14 07:30:00	SPY	ETF	140.27	140.27	140.18	140.19	29450.0
2012-03-14 07:35:00	SPY	ETF	140.19	140.25	140.19	140.19	46796.0
2012-03-14 07:40:00	SPY	ETF	140.2	140.2	140.14	140.18	50740.0
2012-03-14 07:45:00	SPY	ETF	140.17	140.18	140.06	140.06	65850.0
2012-03-14 07:50:00	SPY	ETF	140.07	140.09	140.06	140.07	8150.0
2012-03-14 07:55:00	SPY	ETF	140.07	140.07	140.01	140.01	20448.0
2012-03-14 08:00:00	SPY	ETF	140.02	140.21	139.99	140.21	936084.0
2012-03-14 08:05:00	SPY	ETF	140.02	140.12	140.02	140.07	44310.0
2012-03-14 08:10:00	SPY	ETF	140.06	140.1	140.03	140.1	62000.0
2012-03-14 08:15:00	SPY	ETF	140.08	140.12	140.04	140.04	50098.0
2012-03-14 08:20:00	SPY	ETF	140.07	140.1	140.0	140.01	105516.0
2012-03-14 08:25:00	SPY	ETF	140.01	140.1	140.01	140.09	71520.0
2012-03-14 08:30:00	SPY	ETF	140.09	140.09	139.98	140.01	152169.0

> showing 50 of 38,280 rows — these rows as CSV

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