PREVIEW / etf_5min / 2012-04-02

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-04-02.parquet
  size:    910 KB
  rows:    37,729

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-02 04:00:00	SPY	ETF	141.12	141.27	141.12	141.27	1640.0
2012-04-02 04:05:00	SPY	ETF	141.2	141.27	141.2	141.26	8847.0
2012-04-02 04:20:00	SPY	ETF	141.13	141.13	141.13	141.13	400.0
2012-04-02 04:25:00	SPY	ETF	141.17	141.17	141.17	141.17	600.0
2012-04-02 04:30:00	SPY	ETF	141.06	141.06	141.06	141.06	100.0
2012-04-02 04:35:00	SPY	ETF	140.96	140.96	140.95	140.95	9100.0
2012-04-02 04:40:00	SPY	ETF	140.67	140.67	140.56	140.56	700.0
2012-04-02 04:45:00	SPY	ETF	140.57	140.73	140.54	140.73	17450.0
2012-04-02 04:50:00	SPY	ETF	140.74	140.74	140.74	140.74	200.0
2012-04-02 04:55:00	SPY	ETF	140.64	140.64	140.61	140.62	3200.0
2012-04-02 05:05:00	SPY	ETF	140.69	140.73	140.64	140.64	2600.0
2012-04-02 05:10:00	SPY	ETF	140.66	140.66	140.66	140.66	10200.0
2012-04-02 05:15:00	SPY	ETF	140.67	140.72	140.67	140.72	3500.0
2012-04-02 05:20:00	SPY	ETF	140.66	140.68	140.66	140.68	200.0
2012-04-02 05:25:00	SPY	ETF	140.76	140.78	140.76	140.76	1100.0
2012-04-02 05:30:00	SPY	ETF	140.73	140.82	140.73	140.82	2700.0
2012-04-02 05:40:00	SPY	ETF	140.78	140.78	140.78	140.78	180.0
2012-04-02 05:45:00	SPY	ETF	140.73	140.73	140.72	140.72	10000.0
2012-04-02 05:50:00	SPY	ETF	140.82	140.9	140.82	140.9	2200.0
2012-04-02 05:55:00	SPY	ETF	140.94	140.94	140.94	140.94	500.0
2012-04-02 06:00:00	SPY	ETF	140.92	140.92	140.84	140.84	1500.0
2012-04-02 06:05:00	SPY	ETF	140.9	140.9	140.86	140.86	5500.0
2012-04-02 06:15:00	SPY	ETF	140.86	140.86	140.86	140.86	200.0
2012-04-02 06:25:00	SPY	ETF	140.84	140.84	140.84	140.84	500.0
2012-04-02 06:35:00	SPY	ETF	140.81	140.81	140.76	140.76	3500.0
2012-04-02 06:40:00	SPY	ETF	140.78	140.78	140.78	140.78	200.0
2012-04-02 06:45:00	SPY	ETF	140.87	140.87	140.82	140.82	600.0
2012-04-02 06:50:00	SPY	ETF	140.82	140.82	140.72	140.74	9700.0
2012-04-02 06:55:00	SPY	ETF	140.71	140.72	140.68	140.68	15400.0
2012-04-02 07:00:00	SPY	ETF	140.66	140.76	140.66	140.76	11200.0
2012-04-02 07:05:00	SPY	ETF	140.74	140.8	140.73	140.76	17132.0
2012-04-02 07:10:00	SPY	ETF	140.8	140.82	140.8	140.82	16200.0
2012-04-02 07:15:00	SPY	ETF	140.79	140.84	140.79	140.8	22550.0
2012-04-02 07:20:00	SPY	ETF	140.8	140.8	140.75	140.78	5333.0
2012-04-02 07:25:00	SPY	ETF	140.79	140.79	140.71	140.71	33390.0
2012-04-02 07:30:00	SPY	ETF	140.71	140.78	140.7	140.78	47100.0
2012-04-02 07:35:00	SPY	ETF	140.75	140.76	140.72	140.72	10600.0
2012-04-02 07:40:00	SPY	ETF	140.74	140.74	140.64	140.65	46100.0
2012-04-02 07:45:00	SPY	ETF	140.66	140.66	140.6	140.6	44745.0
2012-04-02 07:50:00	SPY	ETF	140.6	140.63	140.55	140.6	72000.0
2012-04-02 07:55:00	SPY	ETF	140.61	140.66	140.6	140.65	52937.0
2012-04-02 08:00:00	SPY	ETF	140.67	140.71	140.61	140.64	736442.0
2012-04-02 08:05:00	SPY	ETF	140.64	140.81	140.55	140.81	79283.0
2012-04-02 08:10:00	SPY	ETF	140.6	140.6	140.55	140.59	82636.0
2012-04-02 08:15:00	SPY	ETF	140.59	140.59	140.5	140.57	18645.0
2012-04-02 08:20:00	SPY	ETF	140.57	140.59	140.55	140.58	53523.0
2012-04-02 08:25:00	SPY	ETF	140.59	140.7	140.59	140.7	24692.0
2012-04-02 08:30:00	SPY	ETF	140.69	140.72	140.67	140.69	45437.0
2012-04-02 08:35:00	SPY	ETF	140.7	140.72	140.67	140.71	52841.0
2012-04-02 08:40:00	SPY	ETF	140.71	140.74	140.68	140.72	51855.0

> showing 50 of 37,729 rows — these rows as CSV

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