PREVIEW / etf_5min / 2013-05-17

all etf 5-min files

  file:    by_date/etf_5min/2013/2013-05-17.parquet
  size:    977 KB
  rows:    41,167

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-17 04:00:00	SPY	ETF	165.7	165.7	165.58	165.61	1850.0
2013-05-17 04:15:00	SPY	ETF	165.56	165.56	165.56	165.56	1300.0
2013-05-17 04:35:00	SPY	ETF	165.43	165.49	165.43	165.49	400.0
2013-05-17 04:40:00	SPY	ETF	165.54	165.54	165.54	165.54	1500.0
2013-05-17 04:55:00	SPY	ETF	165.49	165.49	165.49	165.49	10000.0
2013-05-17 05:05:00	SPY	ETF	165.58	165.58	165.58	165.58	200.0
2013-05-17 05:10:00	SPY	ETF	165.58	165.58	165.58	165.58	250.0
2013-05-17 05:15:00	SPY	ETF	165.64	165.64	165.64	165.64	300.0
2013-05-17 05:20:00	SPY	ETF	165.71	165.71	165.7	165.7	400.0
2013-05-17 05:25:00	SPY	ETF	165.7	165.73	165.7	165.73	1975.0
2013-05-17 05:30:00	SPY	ETF	165.73	165.73	165.7	165.7	1375.0
2013-05-17 05:35:00	SPY	ETF	165.7	165.88	165.7	165.88	11900.0
2013-05-17 05:40:00	SPY	ETF	165.86	165.86	165.78	165.81	5735.0
2013-05-17 05:45:00	SPY	ETF	165.81	165.85	165.79	165.85	53725.0
2013-05-17 05:50:00	SPY	ETF	165.85	165.85	165.85	165.85	800.0
2013-05-17 05:55:00	SPY	ETF	165.76	165.76	165.76	165.76	10000.0
2013-05-17 06:00:00	SPY	ETF	165.78	165.78	165.75	165.76	13300.0
2013-05-17 06:05:00	SPY	ETF	165.83	165.9	165.83	165.86	4000.0
2013-05-17 06:15:00	SPY	ETF	165.78	165.78	165.72	165.72	7000.0
2013-05-17 06:20:00	SPY	ETF	165.68	165.71	165.67	165.69	1600.0
2013-05-17 06:30:00	SPY	ETF	165.69	165.78	165.67	165.78	11600.0
2013-05-17 06:35:00	SPY	ETF	165.81	165.81	165.76	165.76	200.0
2013-05-17 06:40:00	SPY	ETF	165.72	165.77	165.72	165.77	5100.0
2013-05-17 06:45:00	SPY	ETF	165.79	165.86	165.79	165.86	10700.0
2013-05-17 06:50:00	SPY	ETF	165.81	165.81	165.8	165.8	200.0
2013-05-17 06:55:00	SPY	ETF	165.77	165.77	165.76	165.76	30400.0
2013-05-17 07:00:00	SPY	ETF	165.755	165.8	165.72	165.76	58553.0
2013-05-17 07:05:00	SPY	ETF	165.75	165.75	165.72	165.75	9695.0
2013-05-17 07:10:00	SPY	ETF	165.75	165.78	165.73	165.75	14700.0
2013-05-17 07:15:00	SPY	ETF	165.75	165.77	165.72	165.73	4175.0
2013-05-17 07:20:00	SPY	ETF	165.76	165.76	165.73	165.73	500.0
2013-05-17 07:25:00	SPY	ETF	165.73	165.76	165.71	165.75	18615.0
2013-05-17 07:30:00	SPY	ETF	165.75	165.77	165.7	165.77	35080.0
2013-05-17 07:35:00	SPY	ETF	165.78	165.81	165.74	165.76	50400.0
2013-05-17 07:40:00	SPY	ETF	165.75	165.79	165.75	165.79	4800.0
2013-05-17 07:45:00	SPY	ETF	165.75	165.76	165.68	165.74	8750.0
2013-05-17 07:50:00	SPY	ETF	165.74	165.74	165.67	165.7	78950.0
2013-05-17 07:55:00	SPY	ETF	165.74	165.78	165.74	165.78	12200.0
2013-05-17 08:00:00	SPY	ETF	165.78	166.02	165.73	165.84	62138.0
2013-05-17 08:05:00	SPY	ETF	165.83	165.89	165.8	165.88	11943.0
2013-05-17 08:10:00	SPY	ETF	165.89	165.89	165.83	165.83	25550.0
2013-05-17 08:15:00	SPY	ETF	165.81	165.9	165.81	165.9	8500.0
2013-05-17 08:20:00	SPY	ETF	165.89	165.92	165.84	165.84	43935.0
2013-05-17 08:25:00	SPY	ETF	165.84	165.88	165.82	165.86	44084.0
2013-05-17 08:30:00	SPY	ETF	165.85	165.86	165.81	165.81	47442.0
2013-05-17 08:35:00	SPY	ETF	165.82	165.88	165.8	165.85	66385.0
2013-05-17 08:40:00	SPY	ETF	165.85	165.92	165.85	165.91	46905.0
2013-05-17 08:45:00	SPY	ETF	165.92	165.94	165.9	165.94	40785.0
2013-05-17 08:50:00	SPY	ETF	165.94	166.03	165.93	166.0	111741.0
2013-05-17 08:55:00	SPY	ETF	166.0	166.02	165.3257	165.97	3094360.0

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

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