PREVIEW / etf_5min / 2012-09-19

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-09-19.parquet
  size:    858 KB
  rows:    36,790

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-09-19 04:00:00	SPY	ETF	147.02	147.02	147.02	147.02	250.0
2012-09-19 04:05:00	SPY	ETF	147.04	147.06	147.04	147.06	1599.0
2012-09-19 04:30:00	SPY	ETF	146.93	146.93	146.93	146.93	899.0
2012-09-19 04:35:00	SPY	ETF	146.91	146.91	146.91	146.91	1000.0
2012-09-19 04:50:00	SPY	ETF	146.77	146.77	146.71	146.72	6250.0
2012-09-19 05:15:00	SPY	ETF	146.8	146.8	146.8	146.8	200.0
2012-09-19 05:30:00	SPY	ETF	146.81	146.81	146.81	146.81	145.0
2012-09-19 05:35:00	SPY	ETF	146.85	146.85	146.85	146.85	1000.0
2012-09-19 05:40:00	SPY	ETF	146.8	146.8	146.77	146.77	1100.0
2012-09-19 05:45:00	SPY	ETF	146.78	146.78	146.78	146.78	100.0
2012-09-19 05:50:00	SPY	ETF	146.77	146.77	146.77	146.77	2000.0
2012-09-19 05:55:00	SPY	ETF	146.75	146.76	146.75	146.76	3100.0
2012-09-19 06:00:00	SPY	ETF	146.69	146.69	146.69	146.69	500.0
2012-09-19 06:05:00	SPY	ETF	146.8	146.8	146.8	146.8	100.0
2012-09-19 06:15:00	SPY	ETF	146.74	146.77	146.74	146.77	1100.0
2012-09-19 06:20:00	SPY	ETF	146.77	146.77	146.77	146.77	2000.0
2012-09-19 06:35:00	SPY	ETF	146.77	146.8	146.74	146.77	4100.0
2012-09-19 06:40:00	SPY	ETF	146.77	146.77	146.77	146.77	10000.0
2012-09-19 06:45:00	SPY	ETF	146.77	146.82	146.77	146.82	16000.0
2012-09-19 06:50:00	SPY	ETF	146.81	146.82	146.79	146.79	3100.0
2012-09-19 06:55:00	SPY	ETF	146.75	146.78	146.75	146.75	7100.0
2012-09-19 07:05:00	SPY	ETF	146.75	146.75	146.75	146.75	100.0
2012-09-19 07:10:00	SPY	ETF	146.7	146.71	146.65	146.7	2333.0
2012-09-19 07:15:00	SPY	ETF	146.69	146.72	146.67	146.72	5685.0
2012-09-19 07:20:00	SPY	ETF	146.73	146.78	146.73	146.77	23700.0
2012-09-19 07:25:00	SPY	ETF	146.76	146.76	146.72	146.75	17250.0
2012-09-19 07:30:00	SPY	ETF	146.72	146.72	146.69	146.69	21400.0
2012-09-19 07:35:00	SPY	ETF	146.75	146.78	146.68	146.69	28500.0
2012-09-19 07:40:00	SPY	ETF	146.67	146.76	146.67	146.7	11795.0
2012-09-19 07:45:00	SPY	ETF	146.74	146.75	146.74	146.75	15000.0
2012-09-19 07:50:00	SPY	ETF	146.73	146.73	146.68	146.68	1900.0
2012-09-19 07:55:00	SPY	ETF	146.67	146.7	146.65	146.68	23450.0
2012-09-19 08:00:00	SPY	ETF	146.68	146.81	146.64	146.81	24570.0
2012-09-19 08:05:00	SPY	ETF	146.64	146.67	146.63	146.66	23340.0
2012-09-19 08:10:00	SPY	ETF	146.65	146.7	146.65	146.7	5200.0
2012-09-19 08:15:00	SPY	ETF	146.68	146.73	146.68	146.71	31995.0
2012-09-19 08:20:00	SPY	ETF	146.71	146.79	146.7	146.79	34467.0
2012-09-19 08:25:00	SPY	ETF	146.79	146.85	146.79	146.84	119064.0
2012-09-19 08:30:00	SPY	ETF	146.84	146.85	146.72	146.76	201124.0
2012-09-19 08:35:00	SPY	ETF	146.76	146.77	146.72	146.73	23023.0
2012-09-19 08:40:00	SPY	ETF	146.73	146.78	146.73	146.78	11600.0
2012-09-19 08:45:00	SPY	ETF	146.79	146.85	146.79	146.85	17469.0
2012-09-19 08:50:00	SPY	ETF	146.84	146.84	146.81	146.83	28163.0
2012-09-19 08:55:00	SPY	ETF	146.82	146.83	146.79	146.83	28461.0
2012-09-19 09:00:00	SPY	ETF	146.83	146.84	146.62	146.62	53625.0
2012-09-19 09:05:00	SPY	ETF	146.82	146.91	146.82	146.87	51540.0
2012-09-19 09:10:00	SPY	ETF	146.87	146.88	146.8	146.8	91213.0
2012-09-19 09:15:00	SPY	ETF	146.81	146.84	146.77	146.82	68981.0
2012-09-19 09:20:00	SPY	ETF	146.81	146.85	146.76	146.78	78800.0
2012-09-19 09:25:00	SPY	ETF	146.77	146.8	146.3855	146.79	83738.0

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

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