PREVIEW / etf_5min / 2013-04-19

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-19.parquet
  size:    922 KB
  rows:    39,081

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-04-19 04:00:00	SPY	ETF	154.75	154.75	154.71	154.71	10200.0
2013-04-19 04:05:00	SPY	ETF	154.73	154.73	154.73	154.73	300.0
2013-04-19 04:10:00	SPY	ETF	154.71	154.75	154.71	154.75	800.0
2013-04-19 04:20:00	SPY	ETF	154.75	154.75	154.73	154.75	2200.0
2013-04-19 04:30:00	SPY	ETF	154.75	154.75	154.75	154.75	1875.0
2013-04-19 04:35:00	SPY	ETF	154.82	154.89	154.82	154.89	600.0
2013-04-19 04:40:00	SPY	ETF	154.9	154.92	154.9	154.92	1200.0
2013-04-19 04:45:00	SPY	ETF	154.89	154.89	154.89	154.89	400.0
2013-04-19 04:50:00	SPY	ETF	154.88	154.9	154.88	154.9	400.0
2013-04-19 04:55:00	SPY	ETF	154.9	154.94	154.9	154.94	10200.0
2013-04-19 05:00:00	SPY	ETF	154.85	154.85	154.81	154.83	2500.0
2013-04-19 05:05:00	SPY	ETF	154.79	154.8	154.74	154.77	4200.0
2013-04-19 05:10:00	SPY	ETF	154.76	154.8	154.75	154.78	3000.0
2013-04-19 05:15:00	SPY	ETF	154.82	154.9	154.82	154.87	5400.0
2013-04-19 05:20:00	SPY	ETF	154.87	154.89	154.82	154.82	1800.0
2013-04-19 05:25:00	SPY	ETF	154.85	154.85	154.83	154.83	1000.0
2013-04-19 05:30:00	SPY	ETF	154.91	154.92	154.91	154.92	400.0
2013-04-19 05:35:00	SPY	ETF	154.92	154.94	154.92	154.94	600.0
2013-04-19 05:40:00	SPY	ETF	154.95	154.99	154.95	154.99	700.0
2013-04-19 05:45:00	SPY	ETF	154.97	154.97	154.97	154.97	100.0
2013-04-19 05:50:00	SPY	ETF	154.92	154.92	154.92	154.92	500.0
2013-04-19 05:55:00	SPY	ETF	154.95	154.95	154.91	154.92	1700.0
2013-04-19 06:00:00	SPY	ETF	154.89	154.97	154.89	154.97	1900.0
2013-04-19 06:05:00	SPY	ETF	154.98	154.98	154.95	154.95	14900.0
2013-04-19 06:10:00	SPY	ETF	154.94	155.0	154.94	155.0	800.0
2013-04-19 06:15:00	SPY	ETF	155.03	155.03	155.03	155.03	100.0
2013-04-19 06:20:00	SPY	ETF	154.93	154.93	154.92	154.92	600.0
2013-04-19 06:25:00	SPY	ETF	154.89	154.92	154.86	154.92	2000.0
2013-04-19 06:30:00	SPY	ETF	154.92	154.93	154.9	154.9	500.0
2013-04-19 06:35:00	SPY	ETF	154.9	154.92	154.9	154.9	500.0
2013-04-19 06:40:00	SPY	ETF	154.92	154.95	154.9	154.95	3900.0
2013-04-19 06:45:00	SPY	ETF	154.94	154.97	154.94	154.97	5500.0
2013-04-19 06:50:00	SPY	ETF	154.96	155.0	154.95	155.0	35500.0
2013-04-19 06:55:00	SPY	ETF	155.02	155.03	154.92	154.92	15100.0
2013-04-19 07:00:00	SPY	ETF	154.92	154.95	154.88	154.89	31300.0
2013-04-19 07:05:00	SPY	ETF	154.89	154.9	154.87	154.89	10200.0
2013-04-19 07:10:00	SPY	ETF	154.92	154.94	154.88	154.88	12100.0
2013-04-19 07:15:00	SPY	ETF	154.88	154.88	154.79	154.88	41698.0
2013-04-19 07:20:00	SPY	ETF	154.86	154.88	154.8	154.88	113029.0
2013-04-19 07:25:00	SPY	ETF	154.84	154.85	154.78	154.8	65600.0
2013-04-19 07:30:00	SPY	ETF	154.79	154.79	154.68	154.71	33361.0
2013-04-19 07:35:00	SPY	ETF	154.74	154.77	154.74	154.77	22250.0
2013-04-19 07:40:00	SPY	ETF	154.77	154.9	154.76	154.89	24584.0
2013-04-19 07:45:00	SPY	ETF	154.88	154.91	154.86	154.91	27844.0
2013-04-19 07:50:00	SPY	ETF	154.9	154.9	154.85	154.85	9300.0
2013-04-19 07:55:00	SPY	ETF	154.85	154.85	154.76	154.8	54120.0
2013-04-19 08:00:00	SPY	ETF	154.79	154.92	154.73	154.73	171890.0
2013-04-19 08:05:00	SPY	ETF	154.75	154.85	154.73	154.85	476150.0
2013-04-19 08:10:00	SPY	ETF	154.85	154.88	154.75	154.83	371145.0
2013-04-19 08:15:00	SPY	ETF	154.82	154.83	154.6	154.63	115812.0

> showing 50 of 39,081 rows — these rows as CSV

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