PREVIEW / etf_5min / 2011-07-21

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-21.parquet
  size:    881 KB
  rows:    36,960

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
2011-07-21 04:00:00	SPY	ETF	132.52	132.52	132.52	132.52	100.0
2011-07-21 04:30:00	SPY	ETF	132.64	132.64	132.64	132.64	100.0
2011-07-21 04:35:00	SPY	ETF	132.54	132.54	132.54	132.54	100.0
2011-07-21 04:45:00	SPY	ETF	132.6	132.6	132.6	132.6	100.0
2011-07-21 04:50:00	SPY	ETF	132.6	132.6	132.6	132.6	100.0
2011-07-21 05:00:00	SPY	ETF	132.6	132.6	132.26	132.26	1861.0
2011-07-21 05:10:00	SPY	ETF	132.57	132.57	132.57	132.57	200.0
2011-07-21 05:15:00	SPY	ETF	132.52	132.52	132.52	132.52	200.0
2011-07-21 05:20:00	SPY	ETF	132.21	132.21	132.21	132.21	1700.0
2011-07-21 05:25:00	SPY	ETF	132.2	132.2	132.16	132.17	400.0
2011-07-21 05:30:00	SPY	ETF	132.1	132.1	132.1	132.1	10550.0
2011-07-21 05:35:00	SPY	ETF	132.11	132.11	132.1	132.1	4650.0
2011-07-21 05:50:00	SPY	ETF	132.18	132.18	132.18	132.18	600.0
2011-07-21 06:00:00	SPY	ETF	132.19	132.19	132.14	132.19	9700.0
2011-07-21 06:05:00	SPY	ETF	132.21	132.21	132.05	132.14	5600.0
2011-07-21 06:10:00	SPY	ETF	132.17	132.18	132.17	132.18	5200.0
2011-07-21 06:15:00	SPY	ETF	132.07	132.15	132.05	132.15	5700.0
2011-07-21 06:20:00	SPY	ETF	132.2	132.2	132.2	132.2	40200.0
2011-07-21 06:45:00	SPY	ETF	132.2	132.2	132.2	132.2	25500.0
2011-07-21 06:50:00	SPY	ETF	132.21	132.25	132.21	132.22	700.0
2011-07-21 06:55:00	SPY	ETF	132.42	132.56	132.42	132.56	300.0
2011-07-21 07:00:00	SPY	ETF	132.61	132.74	132.6	132.68	29750.0
2011-07-21 07:05:00	SPY	ETF	132.72	132.82	132.68	132.68	84000.0
2011-07-21 07:10:00	SPY	ETF	132.68	132.74	132.68	132.69	71700.0
2011-07-21 07:15:00	SPY	ETF	132.68	132.74	132.68	132.7	22700.0
2011-07-21 07:20:00	SPY	ETF	132.7	132.7	132.6	132.66	32750.0
2011-07-21 07:25:00	SPY	ETF	132.67	132.77	132.65	132.77	5100.0
2011-07-21 07:30:00	SPY	ETF	132.75	132.79	132.7	132.7	63100.0
2011-07-21 07:35:00	SPY	ETF	132.72	132.72	132.57	132.58	28600.0
2011-07-21 07:40:00	SPY	ETF	132.64	132.7	132.59	132.7	10100.0
2011-07-21 07:45:00	SPY	ETF	132.7	132.71	132.62	132.65	6400.0
2011-07-21 07:50:00	SPY	ETF	132.68	132.85	132.68	132.85	841420.0
2011-07-21 07:55:00	SPY	ETF	132.81	133.0	132.79	133.0	280600.0
2011-07-21 08:00:00	SPY	ETF	132.98	132.99	132.9	132.9	667628.0
2011-07-21 08:05:00	SPY	ETF	132.92	132.98	132.87	132.89	1379200.0
2011-07-21 08:10:00	SPY	ETF	132.9	133.13	132.87	133.1	434865.0
2011-07-21 08:15:00	SPY	ETF	133.04	133.42	133.04	133.27	977820.0
2011-07-21 08:20:00	SPY	ETF	133.27	133.47	133.26	133.27	1016449.0
2011-07-21 08:25:00	SPY	ETF	133.27	133.36	133.24	133.25	428867.0
2011-07-21 08:30:00	SPY	ETF	133.25	133.6	133.09	133.49	1348424.0
2011-07-21 08:35:00	SPY	ETF	133.49	133.5	133.35	133.35	586716.0
2011-07-21 08:40:00	SPY	ETF	133.35	133.41	133.32	133.32	144709.0
2011-07-21 08:45:00	SPY	ETF	133.33	133.5	133.3	133.46	376326.0
2011-07-21 08:50:00	SPY	ETF	133.46	133.63	133.46	133.56	1211356.0
2011-07-21 08:55:00	SPY	ETF	133.55	133.63	133.48	133.5	532916.0
2011-07-21 09:00:00	SPY	ETF	133.5	133.58	133.48	133.49	333388.0
2011-07-21 09:05:00	SPY	ETF	133.49	133.5	133.37	133.38	270282.0
2011-07-21 09:10:00	SPY	ETF	133.38	133.42	133.34	133.4	79029.0
2011-07-21 09:15:00	SPY	ETF	133.39	133.51	133.39	133.48	188945.0
2011-07-21 09:20:00	SPY	ETF	133.48	133.55	133.41	133.5	374120.0

> showing 50 of 36,960 rows — these rows as CSV

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