PREVIEW / etf_5min / 2013-08-02

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-08-02.parquet
  size:    949 KB
  rows:    40,793

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-08-02 04:00:00	SPY	ETF	170.64	170.64	170.63	170.63	2020.0
2013-08-02 04:05:00	SPY	ETF	170.59	170.59	170.59	170.59	200.0
2013-08-02 04:20:00	SPY	ETF	170.64	170.64	170.64	170.64	100.0
2013-08-02 04:25:00	SPY	ETF	170.6	170.65	170.6	170.65	2100.0
2013-08-02 04:30:00	SPY	ETF	170.65	170.65	170.65	170.65	150.0
2013-08-02 05:00:00	SPY	ETF	170.61	170.61	170.59	170.59	1300.0
2013-08-02 05:05:00	SPY	ETF	170.58	170.58	170.58	170.58	4700.0
2013-08-02 05:10:00	SPY	ETF	170.58	170.58	170.58	170.58	2000.0
2013-08-02 05:30:00	SPY	ETF	170.54	170.54	170.54	170.54	400.0
2013-08-02 05:55:00	SPY	ETF	170.59	170.59	170.54	170.54	1300.0
2013-08-02 06:10:00	SPY	ETF	170.59	170.64	170.59	170.64	1600.0
2013-08-02 06:30:00	SPY	ETF	170.64	170.64	170.64	170.64	250.0
2013-08-02 06:40:00	SPY	ETF	170.72	170.72	170.72	170.72	300.0
2013-08-02 06:45:00	SPY	ETF	170.72	170.72	170.72	170.72	100.0
2013-08-02 06:50:00	SPY	ETF	170.68	170.68	170.65	170.65	1100.0
2013-08-02 06:55:00	SPY	ETF	170.63	170.63	170.63	170.63	11800.0
2013-08-02 07:00:00	SPY	ETF	170.62	170.66	170.58	170.66	10700.0
2013-08-02 07:05:00	SPY	ETF	170.7	170.72	170.68	170.68	2500.0
2013-08-02 07:10:00	SPY	ETF	170.68	170.68	170.68	170.68	1300.0
2013-08-02 07:15:00	SPY	ETF	170.71	170.71	170.7	170.7	3000.0
2013-08-02 07:20:00	SPY	ETF	170.69	170.69	170.68	170.68	700.0
2013-08-02 07:25:00	SPY	ETF	170.68	170.69	170.68	170.69	2300.0
2013-08-02 07:30:00	SPY	ETF	170.7	170.71	170.68	170.68	8100.0
2013-08-02 07:35:00	SPY	ETF	170.68	170.68	170.66	170.66	3400.0
2013-08-02 07:40:00	SPY	ETF	170.67	170.69	170.64	170.69	16700.0
2013-08-02 07:45:00	SPY	ETF	170.63	170.66	170.63	170.63	5100.0
2013-08-02 07:50:00	SPY	ETF	170.65	170.69	170.65	170.69	10200.0
2013-08-02 07:55:00	SPY	ETF	170.69	170.69	170.67	170.67	14600.0
2013-08-02 08:00:00	SPY	ETF	170.62	170.91	170.62	170.7	69868.0
2013-08-02 08:05:00	SPY	ETF	170.69	170.72	170.68	170.72	11868.0
2013-08-02 08:10:00	SPY	ETF	170.71	170.74	170.7	170.72	30150.0
2013-08-02 08:15:00	SPY	ETF	170.7	170.72	170.69	170.7	11900.0
2013-08-02 08:20:00	SPY	ETF	170.69	170.79	170.69	170.76	20600.0
2013-08-02 08:25:00	SPY	ETF	170.78	170.81	170.69	170.81	115639.0
2013-08-02 08:30:00	SPY	ETF	170.81	170.84	170.35	170.44	1400735.0
2013-08-02 08:35:00	SPY	ETF	170.43	170.58	170.39	170.41	258972.0
2013-08-02 08:40:00	SPY	ETF	170.41	170.44	170.31	170.37	536095.0
2013-08-02 08:45:00	SPY	ETF	170.38	170.42	170.3	170.31	153207.0
2013-08-02 08:50:00	SPY	ETF	170.31	170.32	170.07	170.16	425176.0
2013-08-02 08:55:00	SPY	ETF	170.17	170.31	170.17	170.28	151851.0
2013-08-02 09:00:00	SPY	ETF	170.28	170.6886	170.11	170.3	1143282.0
2013-08-02 09:05:00	SPY	ETF	170.3	170.32	170.22	170.3	93454.0
2013-08-02 09:10:00	SPY	ETF	170.28	170.49	170.28	170.45	170304.0
2013-08-02 09:15:00	SPY	ETF	170.46	170.49	170.38	170.39	103074.0
2013-08-02 09:20:00	SPY	ETF	170.39	170.43	170.37	170.39	82484.0
2013-08-02 09:25:00	SPY	ETF	170.4	170.4	170.26	170.27	273417.0
2013-08-02 09:30:00	SPY	ETF	170.28	170.39	170.2	170.34	3422630.0
2013-08-02 09:35:00	SPY	ETF	170.33	170.36	170.17	170.25	2280097.0
2013-08-02 09:40:00	SPY	ETF	170.2401	170.26	170.12	170.17	2160327.0
2013-08-02 09:45:00	SPY	ETF	170.181	170.19	170.05	170.11	2011458.0

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

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