PREVIEW / etf_5min / 2013-04-04

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-04-04.parquet
  size:    969 KB
  rows:    40,817

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-04-04 04:05:00	SPY	ETF	155.65	155.65	155.65	155.65	300.0
2013-04-04 04:10:00	SPY	ETF	155.62	155.65	155.62	155.65	600.0
2013-04-04 04:15:00	SPY	ETF	155.64	155.65	155.63	155.65	20100.0
2013-04-04 04:20:00	SPY	ETF	155.68	155.76	155.68	155.76	2600.0
2013-04-04 04:25:00	SPY	ETF	155.76	155.78	155.76	155.78	7500.0
2013-04-04 04:35:00	SPY	ETF	155.8	155.8	155.8	155.8	400.0
2013-04-04 04:40:00	SPY	ETF	155.81	155.81	155.81	155.81	100.0
2013-04-04 04:45:00	SPY	ETF	155.88	155.94	155.88	155.94	1400.0
2013-04-04 04:55:00	SPY	ETF	155.88	155.9	155.88	155.9	1400.0
2013-04-04 05:00:00	SPY	ETF	155.87	155.87	155.87	155.87	3100.0
2013-04-04 05:10:00	SPY	ETF	155.89	155.92	155.89	155.92	525.0
2013-04-04 05:15:00	SPY	ETF	155.96	155.98	155.96	155.98	500.0
2013-04-04 05:20:00	SPY	ETF	156.0	156.04	156.0	156.03	17500.0
2013-04-04 05:25:00	SPY	ETF	156.03	156.03	156.03	156.03	271.0
2013-04-04 05:30:00	SPY	ETF	156.02	156.02	155.99	155.99	7700.0
2013-04-04 05:35:00	SPY	ETF	155.98	156.04	155.98	156.04	900.0
2013-04-04 05:40:00	SPY	ETF	156.01	156.04	156.0	156.02	500.0
2013-04-04 05:45:00	SPY	ETF	156.03	156.03	156.03	156.03	200.0
2013-04-04 05:50:00	SPY	ETF	156.01	156.01	156.0	156.0	780.0
2013-04-04 05:55:00	SPY	ETF	156.0	156.0	156.0	156.0	300.0
2013-04-04 06:00:00	SPY	ETF	155.94	155.94	155.94	155.94	200.0
2013-04-04 06:05:00	SPY	ETF	155.95	155.95	155.91	155.95	3600.0
2013-04-04 06:10:00	SPY	ETF	155.94	155.97	155.94	155.97	2800.0
2013-04-04 06:15:00	SPY	ETF	155.92	155.97	155.91	155.97	6300.0
2013-04-04 06:20:00	SPY	ETF	155.93	155.93	155.93	155.93	100.0
2013-04-04 06:25:00	SPY	ETF	155.94	155.95	155.93	155.93	1000.0
2013-04-04 06:30:00	SPY	ETF	155.97	155.97	155.97	155.97	500.0
2013-04-04 06:35:00	SPY	ETF	155.92	155.92	155.86	155.86	7500.0
2013-04-04 06:40:00	SPY	ETF	155.76	155.79	155.76	155.79	18435.0
2013-04-04 06:45:00	SPY	ETF	155.81	155.92	155.81	155.92	3600.0
2013-04-04 06:50:00	SPY	ETF	155.89	155.89	155.83	155.86	75000.0
2013-04-04 06:55:00	SPY	ETF	155.79	155.79	155.79	155.79	265.0
2013-04-04 07:00:00	SPY	ETF	155.85	155.92	155.85	155.88	12960.0
2013-04-04 07:05:00	SPY	ETF	155.88	155.88	155.83	155.83	87000.0
2013-04-04 07:10:00	SPY	ETF	155.83	155.88	155.83	155.85	16600.0
2013-04-04 07:15:00	SPY	ETF	155.87	155.87	155.86	155.86	92919.0
2013-04-04 07:20:00	SPY	ETF	155.86	155.9	155.86	155.9	6940.0
2013-04-04 07:25:00	SPY	ETF	155.91	155.95	155.91	155.94	120200.0
2013-04-04 07:30:00	SPY	ETF	155.92	155.92	155.87	155.88	65625.0
2013-04-04 07:35:00	SPY	ETF	155.89	155.94	155.88	155.94	15300.0
2013-04-04 07:40:00	SPY	ETF	155.95	156.0	155.94	155.98	81900.0
2013-04-04 07:45:00	SPY	ETF	155.97	155.97	155.82	155.83	63525.0
2013-04-04 07:50:00	SPY	ETF	155.86	155.86	155.83	155.86	110100.0
2013-04-04 07:55:00	SPY	ETF	155.89	155.89	155.83	155.83	26500.0
2013-04-04 08:00:00	SPY	ETF	155.83	155.92	155.78	155.86	243240.0
2013-04-04 08:05:00	SPY	ETF	155.85	155.85	155.68	155.71	227399.0
2013-04-04 08:10:00	SPY	ETF	155.71	155.71	155.64	155.66	52131.0
2013-04-04 08:15:00	SPY	ETF	155.68	155.73	155.66	155.7	133611.0
2013-04-04 08:20:00	SPY	ETF	155.7	155.73	155.69	155.73	41750.0
2013-04-04 08:25:00	SPY	ETF	155.74	155.81	155.74	155.79	80975.0

> showing 50 of 40,817 rows — these rows as CSV

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