PREVIEW / etf_5min / 2012-08-06

all etf 5-min files

  file:    by_date/etf_5min/2012/2012-08-06.parquet
  size:    812 KB
  rows:    35,350

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-06 04:00:00	SPY	ETF	139.42	139.42	139.42	139.42	940.0
2012-08-06 04:15:00	SPY	ETF	139.38	139.38	139.38	139.38	300.0
2012-08-06 04:30:00	SPY	ETF	139.63	139.63	139.63	139.63	200.0
2012-08-06 04:40:00	SPY	ETF	139.65	139.65	139.65	139.65	100.0
2012-08-06 05:15:00	SPY	ETF	139.75	139.77	139.75	139.75	2100.0
2012-08-06 06:00:00	SPY	ETF	139.8	139.8	139.8	139.8	300.0
2012-08-06 06:15:00	SPY	ETF	139.78	139.78	139.73	139.73	5100.0
2012-08-06 06:25:00	SPY	ETF	139.76	139.76	139.7	139.7	300.0
2012-08-06 06:40:00	SPY	ETF	139.75	139.75	139.75	139.75	500.0
2012-08-06 07:00:00	SPY	ETF	139.75	139.76	139.75	139.75	1400.0
2012-08-06 07:05:00	SPY	ETF	139.75	139.75	139.75	139.75	6400.0
2012-08-06 07:10:00	SPY	ETF	139.77	139.8	139.77	139.8	800.0
2012-08-06 07:15:00	SPY	ETF	139.78	139.83	139.78	139.83	1525.0
2012-08-06 07:20:00	SPY	ETF	139.77	139.78	139.73	139.73	6550.0
2012-08-06 07:25:00	SPY	ETF	139.73	139.8	139.73	139.8	7400.0
2012-08-06 07:30:00	SPY	ETF	139.8	139.86	139.8	139.84	27350.0
2012-08-06 07:35:00	SPY	ETF	139.84	139.89	139.84	139.87	4558.0
2012-08-06 07:40:00	SPY	ETF	139.88	139.89	139.85	139.87	93250.0
2012-08-06 07:45:00	SPY	ETF	139.85	139.87	139.84	139.86	7327.0
2012-08-06 07:50:00	SPY	ETF	139.86	139.88	139.86	139.86	2725.0
2012-08-06 07:55:00	SPY	ETF	139.86	139.88	139.86	139.87	17025.0
2012-08-06 08:00:00	SPY	ETF	139.87	139.87	139.8	139.86	29885.0
2012-08-06 08:05:00	SPY	ETF	139.86	139.86	139.75	139.79	68750.0
2012-08-06 08:10:00	SPY	ETF	139.8	139.89	139.79	139.86	79762.0
2012-08-06 08:15:00	SPY	ETF	139.87	139.89	139.84	139.84	45700.0
2012-08-06 08:20:00	SPY	ETF	139.82	139.84	139.81	139.81	272100.0
2012-08-06 08:25:00	SPY	ETF	139.82	139.82	139.75	139.78	71734.0
2012-08-06 08:30:00	SPY	ETF	139.78	139.82	139.74	139.79	124227.0
2012-08-06 08:35:00	SPY	ETF	139.8	139.81	139.73	139.76	82699.0
2012-08-06 08:40:00	SPY	ETF	139.77	139.81	139.73	139.76	30991.0
2012-08-06 08:45:00	SPY	ETF	139.74	139.77	139.73	139.73	91263.0
2012-08-06 08:50:00	SPY	ETF	139.73	139.8	139.72	139.79	38611.0
2012-08-06 08:55:00	SPY	ETF	139.78	139.79	139.74	139.78	7700.0
2012-08-06 09:00:00	SPY	ETF	139.77	139.8	139.73	139.73	62855.0
2012-08-06 09:05:00	SPY	ETF	139.73	139.79	139.73	139.77	41880.0
2012-08-06 09:10:00	SPY	ETF	139.77	139.8	139.73	139.79	61125.0
2012-08-06 09:15:00	SPY	ETF	139.78	139.81	139.77	139.77	44073.0
2012-08-06 09:20:00	SPY	ETF	139.77	139.79	139.74	139.75	58904.0
2012-08-06 09:25:00	SPY	ETF	139.75	139.76	139.71	139.72	352006.0
2012-08-06 09:30:00	SPY	ETF	139.72	139.74	139.58	139.69	2943591.0
2012-08-06 09:35:00	SPY	ETF	139.69	139.93	139.65	139.86	2239626.0
2012-08-06 09:40:00	SPY	ETF	139.86	139.96	139.7901	139.93	2121093.0
2012-08-06 09:45:00	SPY	ETF	139.93	140.07	139.93	140.0675	2570178.0
2012-08-06 09:50:00	SPY	ETF	140.06	140.13	139.98	140.01	2054803.0
2012-08-06 09:55:00	SPY	ETF	140.02	140.03	139.93	139.97	1354185.0
2012-08-06 10:00:00	SPY	ETF	139.98	140.08	139.95	140.045	1471450.0
2012-08-06 10:05:00	SPY	ETF	140.05	140.13	140.04	140.1	1494251.0
2012-08-06 10:10:00	SPY	ETF	140.09	140.12	139.98	139.99	1570580.0
2012-08-06 10:15:00	SPY	ETF	139.985	140.02	139.89	140.0	2097099.0
2012-08-06 10:20:00	SPY	ETF	140.01	140.06	139.9475	139.954	978270.0

> showing 50 of 35,350 rows — these rows as CSV

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