PREVIEW / etf_5min / 2012-08-17

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-17.parquet
  size:    778 KB
  rows:    33,189

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-08-17 04:00:00	SPY	ETF	141.99	141.99	141.8	141.8	345.0
2012-08-17 05:00:00	SPY	ETF	141.89	141.89	141.89	141.89	200.0
2012-08-17 05:10:00	SPY	ETF	141.89	141.89	141.89	141.89	200.0
2012-08-17 05:45:00	SPY	ETF	141.92	141.92	141.92	141.92	1000.0
2012-08-17 05:55:00	SPY	ETF	141.91	141.91	141.91	141.91	200.0
2012-08-17 06:00:00	SPY	ETF	141.87	141.87	141.87	141.87	100.0
2012-08-17 06:10:00	SPY	ETF	141.82	141.82	141.82	141.82	200.0
2012-08-17 06:25:00	SPY	ETF	141.87	141.88	141.87	141.88	15000.0
2012-08-17 06:30:00	SPY	ETF	141.87	141.88	141.87	141.88	5830.0
2012-08-17 06:50:00	SPY	ETF	141.76	141.76	141.76	141.76	1100.0
2012-08-17 06:55:00	SPY	ETF	141.75	141.77	141.74	141.77	5900.0
2012-08-17 07:00:00	SPY	ETF	141.78	141.78	141.78	141.78	1000.0
2012-08-17 07:05:00	SPY	ETF	141.83	141.83	141.83	141.83	400.0
2012-08-17 07:10:00	SPY	ETF	141.83	141.83	141.8	141.8	11560.0
2012-08-17 07:15:00	SPY	ETF	141.81	141.81	141.73	141.73	15605.0
2012-08-17 07:20:00	SPY	ETF	141.77	141.78	141.72	141.72	54400.0
2012-08-17 07:25:00	SPY	ETF	141.74	141.78	141.74	141.78	6600.0
2012-08-17 07:30:00	SPY	ETF	141.8	141.85	141.78	141.78	1900.0
2012-08-17 07:35:00	SPY	ETF	141.85	141.85	141.85	141.85	200.0
2012-08-17 07:40:00	SPY	ETF	141.88	141.88	141.88	141.88	4000.0
2012-08-17 07:45:00	SPY	ETF	141.84	141.84	141.83	141.84	3500.0
2012-08-17 07:50:00	SPY	ETF	141.84	141.84	141.79	141.79	14800.0
2012-08-17 07:55:00	SPY	ETF	141.8	141.83	141.72	141.77	29650.0
2012-08-17 08:00:00	SPY	ETF	141.77	141.77	141.74	141.77	57347.0
2012-08-17 08:05:00	SPY	ETF	141.75	141.77	141.73	141.74	30012.0
2012-08-17 08:10:00	SPY	ETF	141.77	141.81	141.75	141.76	19193.0
2012-08-17 08:15:00	SPY	ETF	141.76	141.88	141.76	141.86	50365.0
2012-08-17 08:20:00	SPY	ETF	141.86	141.87	141.82	141.83	90200.0
2012-08-17 08:25:00	SPY	ETF	141.82	141.83	141.77	141.81	16945.0
2012-08-17 08:30:00	SPY	ETF	141.8	141.84	141.79	141.8	16723.0
2012-08-17 08:35:00	SPY	ETF	141.8	141.84	141.8	141.82	16097.0
2012-08-17 08:40:00	SPY	ETF	141.82	141.87	141.78	141.8	33900.0
2012-08-17 08:45:00	SPY	ETF	141.8	141.84	141.8	141.84	10972.0
2012-08-17 08:50:00	SPY	ETF	141.83	141.88	141.81	141.82	153085.0
2012-08-17 08:55:00	SPY	ETF	141.83	141.86	141.82	141.86	5400.0
2012-08-17 09:00:00	SPY	ETF	141.86	141.89	141.83	141.87	22430.0
2012-08-17 09:05:00	SPY	ETF	141.87	141.9	141.87	141.87	63085.0
2012-08-17 09:10:00	SPY	ETF	141.86	141.92	141.86	141.91	62090.0
2012-08-17 09:15:00	SPY	ETF	141.92	141.99	141.9	141.98	100337.0
2012-08-17 09:20:00	SPY	ETF	141.97	142.07	141.95	142.05	306351.0
2012-08-17 09:25:00	SPY	ETF	142.05	142.26	142.02	142.24	576482.0
2012-08-17 09:30:00	SPY	ETF	142.23	142.25	142.04	142.09	3634973.0
2012-08-17 09:35:00	SPY	ETF	142.09	142.12	142.0	142.03	2682762.0
2012-08-17 09:40:00	SPY	ETF	142.03	142.05	141.95	141.959	1670870.0
2012-08-17 09:45:00	SPY	ETF	141.951	142.06	141.89	142.03	1783225.0
2012-08-17 09:50:00	SPY	ETF	142.03	142.0786	141.99	142.02	1056474.0
2012-08-17 09:55:00	SPY	ETF	142.06	142.13	142.02	142.13	2944137.0
2012-08-17 10:00:00	SPY	ETF	142.13	142.15	141.92	142.0	2768097.0
2012-08-17 10:05:00	SPY	ETF	142.0	142.095	141.9979	142.09	1297260.0
2012-08-17 10:10:00	SPY	ETF	142.08	142.128	142.01	142.0173	807987.0

> showing 50 of 33,189 rows — these rows as CSV

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