PREVIEW / etf_5min / 2013-05-30

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-30.parquet
  size:    976 KB
  rows:    41,688

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-30 04:00:00	SPY	ETF	165.1	165.23	165.1	165.15	1400.0
2013-05-30 04:05:00	SPY	ETF	165.1	165.1	165.1	165.1	100.0
2013-05-30 04:10:00	SPY	ETF	165.02	165.02	165.02	165.02	100.0
2013-05-30 04:15:00	SPY	ETF	165.0	165.0	164.95	164.95	10100.0
2013-05-30 04:30:00	SPY	ETF	164.93	164.95	164.93	164.95	400.0
2013-05-30 04:35:00	SPY	ETF	164.95	164.97	164.95	164.97	200.0
2013-05-30 04:40:00	SPY	ETF	165.0	165.0	165.0	165.0	1625.0
2013-05-30 04:45:00	SPY	ETF	164.92	164.96	164.92	164.92	300.0
2013-05-30 04:50:00	SPY	ETF	164.94	164.94	164.87	164.87	300.0
2013-05-30 04:55:00	SPY	ETF	164.8	164.8	164.8	164.8	100.0
2013-05-30 05:00:00	SPY	ETF	164.85	164.85	164.85	164.85	100.0
2013-05-30 05:05:00	SPY	ETF	164.92	164.93	164.92	164.93	1300.0
2013-05-30 05:10:00	SPY	ETF	164.95	164.95	164.92	164.92	1200.0
2013-05-30 05:15:00	SPY	ETF	164.9	164.9	164.89	164.9	20700.0
2013-05-30 05:20:00	SPY	ETF	164.8	164.92	164.8	164.9	2700.0
2013-05-30 05:25:00	SPY	ETF	164.97	165.05	164.97	165.05	3400.0
2013-05-30 05:35:00	SPY	ETF	165.0	165.0	164.95	164.95	50700.0
2013-05-30 05:40:00	SPY	ETF	165.1	165.15	165.1	165.15	17100.0
2013-05-30 05:45:00	SPY	ETF	165.14	165.14	165.14	165.14	100.0
2013-05-30 05:50:00	SPY	ETF	165.15	165.15	165.11	165.12	600.0
2013-05-30 05:55:00	SPY	ETF	165.12	165.12	165.05	165.05	17900.0
2013-05-30 06:00:00	SPY	ETF	164.995	164.995	164.995	164.995	300.0
2013-05-30 06:05:00	SPY	ETF	165.05	165.05	165.05	165.05	1500.0
2013-05-30 06:10:00	SPY	ETF	164.98	164.98	164.95	164.95	17200.0
2013-05-30 06:15:00	SPY	ETF	164.9	164.9	164.88	164.88	300.0
2013-05-30 06:20:00	SPY	ETF	164.9	165.23	164.9	165.23	10300.0
2013-05-30 06:25:00	SPY	ETF	165.23	165.33	165.22	165.23	6450.0
2013-05-30 06:30:00	SPY	ETF	165.31	165.43	165.31	165.38	28300.0
2013-05-30 06:35:00	SPY	ETF	165.38	165.42	165.27	165.35	16500.0
2013-05-30 06:40:00	SPY	ETF	165.35	165.5	165.35	165.5	34835.0
2013-05-30 06:45:00	SPY	ETF	165.5	165.58	165.5	165.54	24825.0
2013-05-30 06:50:00	SPY	ETF	165.55	165.59	165.52	165.55	45550.0
2013-05-30 06:55:00	SPY	ETF	165.55	165.57	165.52	165.52	38300.0
2013-05-30 07:00:00	SPY	ETF	165.5	165.78	165.5	165.76	59584.0
2013-05-30 07:05:00	SPY	ETF	165.75	165.87	165.75	165.82	85488.0
2013-05-30 07:10:00	SPY	ETF	165.81	165.98	165.81	165.98	79350.0
2013-05-30 07:15:00	SPY	ETF	165.975	165.98	165.87	165.92	30300.0
2013-05-30 07:20:00	SPY	ETF	165.97	166.0	165.91	165.91	49748.0
2013-05-30 07:25:00	SPY	ETF	165.93	165.93	165.84	165.87	96400.0
2013-05-30 07:30:00	SPY	ETF	165.88	165.91	165.8	165.85	40073.0
2013-05-30 07:35:00	SPY	ETF	165.85	165.91	165.78	165.81	70550.0
2013-05-30 07:40:00	SPY	ETF	165.8	165.85	165.8	165.83	8050.0
2013-05-30 07:45:00	SPY	ETF	165.82	165.85	165.79	165.85	33550.0
2013-05-30 07:50:00	SPY	ETF	165.79	165.805	165.75	165.75	35150.0
2013-05-30 07:55:00	SPY	ETF	165.76	165.76	165.69	165.705	14525.0
2013-05-30 08:00:00	SPY	ETF	165.57	165.95	164.6	165.79	80335.0
2013-05-30 08:05:00	SPY	ETF	165.77	165.83	165.75	165.8	51145.0
2013-05-30 08:10:00	SPY	ETF	165.79	165.79	165.73	165.75	24105.0
2013-05-30 08:15:00	SPY	ETF	165.77	165.78	165.65	165.68	59263.0
2013-05-30 08:20:00	SPY	ETF	165.69	165.75	165.67	165.74	37868.0

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

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