PREVIEW / etf_5min / 2010-08-02

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-08-02.parquet
  size:    805 KB
  rows:    34,052

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
2010-08-02 04:00:00	SPY	ETF	110.99	111.42	110.99	111.42	1410.0
2010-08-02 04:05:00	SPY	ETF	111.42	111.42	111.42	111.42	6000.0
2010-08-02 04:15:00	SPY	ETF	111.44	111.48	111.44	111.48	200.0
2010-08-02 04:20:00	SPY	ETF	111.55	111.55	111.55	111.55	100.0
2010-08-02 04:25:00	SPY	ETF	111.57	111.6	111.57	111.6	5100.0
2010-08-02 04:30:00	SPY	ETF	111.6	111.6	111.56	111.56	1500.0
2010-08-02 04:35:00	SPY	ETF	111.52	111.52	111.52	111.52	100.0
2010-08-02 04:45:00	SPY	ETF	111.56	111.56	111.56	111.56	100.0
2010-08-02 04:50:00	SPY	ETF	111.6	111.62	111.6	111.62	1175.0
2010-08-02 04:55:00	SPY	ETF	111.56	111.56	111.56	111.56	200.0
2010-08-02 05:00:00	SPY	ETF	111.57	111.57	111.57	111.57	700.0
2010-08-02 05:10:00	SPY	ETF	111.6	111.6	111.6	111.6	100.0
2010-08-02 05:25:00	SPY	ETF	111.56	111.56	111.56	111.56	200.0
2010-08-02 05:30:00	SPY	ETF	111.56	111.56	111.56	111.56	200.0
2010-08-02 05:45:00	SPY	ETF	111.63	111.64	111.63	111.64	700.0
2010-08-02 05:55:00	SPY	ETF	111.65	111.7	111.65	111.7	3000.0
2010-08-02 06:05:00	SPY	ETF	111.65	111.65	111.65	111.65	100.0
2010-08-02 06:15:00	SPY	ETF	111.6	111.6	111.6	111.6	100.0
2010-08-02 06:20:00	SPY	ETF	111.56	111.57	111.56	111.57	2600.0
2010-08-02 06:25:00	SPY	ETF	111.57	111.57	111.56	111.57	3100.0
2010-08-02 06:40:00	SPY	ETF	111.61	111.62	111.61	111.62	10000.0
2010-08-02 06:45:00	SPY	ETF	111.62	111.62	111.59	111.59	1600.0
2010-08-02 06:50:00	SPY	ETF	111.59	111.64	111.59	111.64	10901.0
2010-08-02 06:55:00	SPY	ETF	111.6	111.6	111.57	111.57	200.0
2010-08-02 07:00:00	SPY	ETF	111.57	111.67	111.57	111.62	254202.0
2010-08-02 07:05:00	SPY	ETF	111.62	111.7	111.62	111.67	133136.0
2010-08-02 07:10:00	SPY	ETF	111.65	111.7	111.65	111.69	133700.0
2010-08-02 07:15:00	SPY	ETF	111.72	111.78	111.72	111.76	47733.0
2010-08-02 07:20:00	SPY	ETF	111.75	111.75	111.64	111.64	14880.0
2010-08-02 07:25:00	SPY	ETF	111.65	111.7	111.64	111.7	7550.0
2010-08-02 07:30:00	SPY	ETF	111.71	111.74	111.69	111.7	14600.0
2010-08-02 07:35:00	SPY	ETF	111.69	111.7	111.64	111.69	30780.0
2010-08-02 07:40:00	SPY	ETF	111.7	111.75	111.66	111.66	128960.0
2010-08-02 07:45:00	SPY	ETF	111.66	111.72	111.66	111.7	15700.0
2010-08-02 07:50:00	SPY	ETF	111.69	111.69	111.65	111.65	11700.0
2010-08-02 07:55:00	SPY	ETF	111.65	111.67	111.61	111.64	10637.0
2010-08-02 08:00:00	SPY	ETF	111.64	111.67	111.15	111.66	169304.0
2010-08-02 08:05:00	SPY	ETF	111.65	111.65	111.58	111.61	198828.0
2010-08-02 08:10:00	SPY	ETF	111.62	111.64	111.57	111.58	132637.0
2010-08-02 08:15:00	SPY	ETF	111.59	111.61	111.57	111.59	91386.0
2010-08-02 08:20:00	SPY	ETF	111.59	111.61	111.55	111.58	99264.0
2010-08-02 08:25:00	SPY	ETF	111.58	111.7	111.58	111.64	132930.0
2010-08-02 08:30:00	SPY	ETF	111.64	111.66	111.59	111.6	98725.0
2010-08-02 08:35:00	SPY	ETF	111.6	111.62	111.6	111.61	39810.0
2010-08-02 08:40:00	SPY	ETF	111.61	111.74	111.61	111.72	255385.0
2010-08-02 08:45:00	SPY	ETF	111.72	111.73	111.66	111.71	422146.0
2010-08-02 08:50:00	SPY	ETF	111.72	111.73	110.27	111.68	142610.0
2010-08-02 08:55:00	SPY	ETF	111.69	111.74	111.65	111.67	97114.0
2010-08-02 09:00:00	SPY	ETF	111.68	111.78	111.62	111.77	203378.0
2010-08-02 09:05:00	SPY	ETF	111.77	111.9	111.75	111.86	613609.0

> showing 50 of 34,052 rows — these rows as CSV

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