PREVIEW / etf_5min / 2013-05-16

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-16.parquet
  size:    964 KB
  rows:    41,606

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-05-16 04:00:00	SPY	ETF	165.9	165.9	165.69	165.69	500.0
2013-05-16 04:05:00	SPY	ETF	165.62	165.62	165.62	165.62	200.0
2013-05-16 04:10:00	SPY	ETF	165.6	165.6	165.6	165.6	300.0
2013-05-16 04:20:00	SPY	ETF	165.65	165.65	165.65	165.65	1000.0
2013-05-16 04:25:00	SPY	ETF	165.6	165.6	165.57	165.57	1185.0
2013-05-16 04:35:00	SPY	ETF	165.68	165.68	165.68	165.68	2000.0
2013-05-16 04:40:00	SPY	ETF	165.79	165.79	165.79	165.79	200.0
2013-05-16 04:55:00	SPY	ETF	165.83	165.83	165.79	165.79	1100.0
2013-05-16 05:40:00	SPY	ETF	165.71	165.73	165.65	165.73	1400.0
2013-05-16 05:50:00	SPY	ETF	165.71	165.71	165.71	165.71	1300.0
2013-05-16 05:55:00	SPY	ETF	165.71	165.71	165.71	165.71	2100.0
2013-05-16 06:00:00	SPY	ETF	165.71	165.74	165.71	165.74	12620.0
2013-05-16 06:05:00	SPY	ETF	165.74	165.74	165.74	165.74	13100.0
2013-05-16 06:20:00	SPY	ETF	165.81	165.84	165.81	165.84	25170.0
2013-05-16 06:25:00	SPY	ETF	165.84	165.84	165.8	165.8	4400.0
2013-05-16 06:35:00	SPY	ETF	165.88	165.91	165.88	165.91	12990.0
2013-05-16 06:40:00	SPY	ETF	165.88	165.88	165.88	165.88	2000.0
2013-05-16 06:50:00	SPY	ETF	165.86	165.86	165.86	165.86	1300.0
2013-05-16 06:55:00	SPY	ETF	165.92	165.92	165.91	165.91	4200.0
2013-05-16 07:00:00	SPY	ETF	165.91	165.94	165.88	165.94	9603.0
2013-05-16 07:05:00	SPY	ETF	165.93	166.01	165.93	166.01	97390.0
2013-05-16 07:10:00	SPY	ETF	166.01	166.02	165.9	165.9	32775.0
2013-05-16 07:15:00	SPY	ETF	165.88	165.91	165.86	165.86	12650.0
2013-05-16 07:20:00	SPY	ETF	165.85	165.96	165.85	165.96	22440.0
2013-05-16 07:25:00	SPY	ETF	165.96	165.96	165.9	165.94	16400.0
2013-05-16 07:30:00	SPY	ETF	165.9	165.94	165.89	165.94	8800.0
2013-05-16 07:35:00	SPY	ETF	165.94	165.98	165.92	165.93	45680.0
2013-05-16 07:40:00	SPY	ETF	165.95	165.96	165.94	165.96	16300.0
2013-05-16 07:45:00	SPY	ETF	165.96	165.99	165.96	165.96	24690.0
2013-05-16 07:50:00	SPY	ETF	165.99	166.04	165.98	166.01	27470.0
2013-05-16 07:55:00	SPY	ETF	166.01	166.05	166.01	166.05	1494.0
2013-05-16 08:00:00	SPY	ETF	166.03	166.04	165.75	166.03	223066.0
2013-05-16 08:05:00	SPY	ETF	166.04	166.09	166.04	166.05	40980.0
2013-05-16 08:10:00	SPY	ETF	166.06	166.06	166.0	166.05	19095.0
2013-05-16 08:15:00	SPY	ETF	166.05	166.09	166.03	166.09	44090.0
2013-05-16 08:20:00	SPY	ETF	166.08	166.12	166.06	166.11	61136.0
2013-05-16 08:25:00	SPY	ETF	166.11	166.15	166.0	166.03	70941.0
2013-05-16 08:30:00	SPY	ETF	165.98	165.98	165.56	165.73	866923.0
2013-05-16 08:35:00	SPY	ETF	165.73	165.73	165.59	165.61	108895.0
2013-05-16 08:40:00	SPY	ETF	165.6	165.76	165.6	165.65	240444.0
2013-05-16 08:45:00	SPY	ETF	165.65	165.77	165.64	165.74	61025.0
2013-05-16 08:50:00	SPY	ETF	165.74	165.74	165.7	165.72	51324.0
2013-05-16 08:55:00	SPY	ETF	165.72	165.79	165.72	165.77	46445.0
2013-05-16 09:00:00	SPY	ETF	165.76	165.76	165.65	165.65	62223.0
2013-05-16 09:05:00	SPY	ETF	165.65	165.73	165.65	165.7	102105.0
2013-05-16 09:10:00	SPY	ETF	165.7	165.75	165.67	165.75	54659.0
2013-05-16 09:15:00	SPY	ETF	165.75	165.78	165.69	165.7	56053.0
2013-05-16 09:20:00	SPY	ETF	165.7	165.77	165.68	165.68	173489.0
2013-05-16 09:25:00	SPY	ETF	165.69	165.78	165.65	165.76	310218.0
2013-05-16 09:30:00	SPY	ETF	165.78	165.95	165.76	165.89	3018263.0

> showing 50 of 41,606 rows — these rows as CSV

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