PREVIEW / etf_5min / 2014-03-04

all etf 5-min files

  file:    by_date/etf_5min/2014/2014-03-04.parquet
  size:    1.0 MB
  rows:    44,710

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
2014-03-04 04:00:00	SPY	ETF	185.98	186.12	185.97	185.97	34683.0
2014-03-04 04:05:00	SPY	ETF	186.01	186.01	186.01	186.01	500.0
2014-03-04 04:10:00	SPY	ETF	186.02	186.08	186.02	186.05	8310.0
2014-03-04 04:15:00	SPY	ETF	185.97	185.97	185.97	185.97	150.0
2014-03-04 04:25:00	SPY	ETF	186.01	186.08	186.01	186.08	5942.0
2014-03-04 04:30:00	SPY	ETF	186.12	186.12	186.12	186.12	900.0
2014-03-04 04:35:00	SPY	ETF	186.08	186.08	186.08	186.08	1125.0
2014-03-04 04:40:00	SPY	ETF	186.04	186.08	186.04	186.08	1250.0
2014-03-04 04:45:00	SPY	ETF	186.04	186.05	186.04	186.05	243.0
2014-03-04 04:50:00	SPY	ETF	186.04	186.04	186.04	186.04	300.0
2014-03-04 04:55:00	SPY	ETF	186.05	186.05	186.05	186.05	185.0
2014-03-04 05:00:00	SPY	ETF	186.11	186.11	186.08	186.08	10600.0
2014-03-04 05:05:00	SPY	ETF	186.16	186.16	186.16	186.16	300.0
2014-03-04 05:10:00	SPY	ETF	186.13	186.13	186.13	186.13	188.0
2014-03-04 05:15:00	SPY	ETF	186.16	186.2	186.16	186.18	3200.0
2014-03-04 05:20:00	SPY	ETF	186.13	186.13	186.1	186.1	9528.0
2014-03-04 05:25:00	SPY	ETF	186.1	186.1	186.07	186.07	404.0
2014-03-04 05:30:00	SPY	ETF	186.1	186.16	186.1	186.16	1900.0
2014-03-04 05:35:00	SPY	ETF	186.15	186.16	186.13	186.13	1144.0
2014-03-04 05:40:00	SPY	ETF	186.07	186.07	186.07	186.07	1000.0
2014-03-04 05:45:00	SPY	ETF	186.05	186.5	186.05	186.5	15265.0
2014-03-04 05:50:00	SPY	ETF	186.47	186.74	186.47	186.74	14577.0
2014-03-04 05:55:00	SPY	ETF	186.76	186.87	186.67	186.74	17321.0
2014-03-04 06:00:00	SPY	ETF	186.74	186.9	186.68	186.68	41786.0
2014-03-04 06:05:00	SPY	ETF	186.7	186.72	186.62	186.72	30801.0
2014-03-04 06:10:00	SPY	ETF	186.73	186.85	186.72	186.85	22756.0
2014-03-04 06:15:00	SPY	ETF	186.83	186.87	186.81	186.81	3419.0
2014-03-04 06:20:00	SPY	ETF	186.76	186.85	186.76	186.85	800.0
2014-03-04 06:25:00	SPY	ETF	186.76	186.81	186.76	186.81	700.0
2014-03-04 06:30:00	SPY	ETF	186.83	186.85	186.79	186.81	16425.0
2014-03-04 06:35:00	SPY	ETF	186.88	186.99	186.8	186.8	18125.0
2014-03-04 06:40:00	SPY	ETF	186.78	186.85	186.69	186.69	29881.0
2014-03-04 06:45:00	SPY	ETF	186.74	186.75	186.66	186.66	43650.0
2014-03-04 06:50:00	SPY	ETF	186.74	186.78	186.69	186.76	116597.0
2014-03-04 06:55:00	SPY	ETF	186.75	186.75	186.66	186.69	26200.0
2014-03-04 07:00:00	SPY	ETF	186.71	186.9	186.69	186.9	30881.0
2014-03-04 07:05:00	SPY	ETF	186.88	186.96	186.88	186.91	51077.0
2014-03-04 07:10:00	SPY	ETF	186.93	186.96	186.89	186.93	167323.0
2014-03-04 07:15:00	SPY	ETF	186.95	187.07	186.95	187.07	82002.0
2014-03-04 07:20:00	SPY	ETF	187.06	187.07	186.91	186.91	45181.0
2014-03-04 07:25:00	SPY	ETF	186.89	186.89	186.85	186.86	60026.0
2014-03-04 07:30:00	SPY	ETF	186.86	186.91	186.85	186.86	47990.0
2014-03-04 07:35:00	SPY	ETF	186.84	186.92	186.84	186.92	36783.0
2014-03-04 07:40:00	SPY	ETF	186.88	186.91	186.83	186.83	231428.0
2014-03-04 07:45:00	SPY	ETF	186.83	186.86	186.83	186.85	35834.0
2014-03-04 07:50:00	SPY	ETF	186.87	186.91	186.83	186.83	49100.0
2014-03-04 07:55:00	SPY	ETF	186.84	186.84	186.76	186.77	83591.0
2014-03-04 08:00:00	SPY	ETF	186.77	187.07	186.21	186.74	248747.0
2014-03-04 08:05:00	SPY	ETF	186.72	186.76	185.1	186.75	271066.0
2014-03-04 08:10:00	SPY	ETF	186.75	186.77	186.54	186.58	223132.0

> showing 50 of 44,710 rows — these rows as CSV

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