PREVIEW / etf_5min / 2011-07-26

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-07-26.parquet
  size:    847 KB
  rows:    35,742

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
2011-07-26 04:00:00	SPY	ETF	134.01	134.16	134.01	134.16	300.0
2011-07-26 04:05:00	SPY	ETF	134.21	134.21	134.21	134.21	400.0
2011-07-26 04:10:00	SPY	ETF	134.16	134.16	134.16	134.16	1160.0
2011-07-26 04:15:00	SPY	ETF	134.16	134.16	134.16	134.16	235.0
2011-07-26 04:35:00	SPY	ETF	134.13	134.13	134.13	134.13	400.0
2011-07-26 04:55:00	SPY	ETF	134.11	134.11	134.07	134.07	625.0
2011-07-26 05:00:00	SPY	ETF	133.89	133.89	133.89	133.89	1100.0
2011-07-26 05:30:00	SPY	ETF	133.65	133.65	133.65	133.65	100.0
2011-07-26 06:00:00	SPY	ETF	133.8	133.86	133.8	133.86	400.0
2011-07-26 06:05:00	SPY	ETF	133.85	133.85	133.85	133.85	200.0
2011-07-26 06:10:00	SPY	ETF	133.86	133.86	133.86	133.86	200.0
2011-07-26 06:20:00	SPY	ETF	133.86	133.86	133.86	133.86	300.0
2011-07-26 06:30:00	SPY	ETF	133.89	133.89	133.89	133.89	100.0
2011-07-26 06:35:00	SPY	ETF	133.82	133.82	133.82	133.82	300.0
2011-07-26 06:40:00	SPY	ETF	133.77	133.77	133.77	133.77	100.0
2011-07-26 06:55:00	SPY	ETF	133.87	134.1	133.87	134.08	12300.0
2011-07-26 07:00:00	SPY	ETF	134.13	134.13	134.1	134.1	1600.0
2011-07-26 07:05:00	SPY	ETF	134.1	134.21	134.06	134.13	572300.0
2011-07-26 07:10:00	SPY	ETF	134.13	134.13	134.1	134.13	242566.0
2011-07-26 07:15:00	SPY	ETF	134.1	134.18	134.1	134.15	185500.0
2011-07-26 07:20:00	SPY	ETF	134.17	134.18	134.14	134.15	30400.0
2011-07-26 07:25:00	SPY	ETF	134.14	134.17	134.09	134.15	157470.0
2011-07-26 07:30:00	SPY	ETF	134.13	134.13	134.1	134.1	3550.0
2011-07-26 07:35:00	SPY	ETF	134.05	134.13	134.05	134.13	13400.0
2011-07-26 07:40:00	SPY	ETF	134.12	134.21	134.09	134.21	29690.0
2011-07-26 07:45:00	SPY	ETF	134.2	134.2	134.12	134.12	110591.0
2011-07-26 07:50:00	SPY	ETF	134.11	134.15	134.03	134.07	331427.0
2011-07-26 07:55:00	SPY	ETF	134.07	134.07	134.01	134.03	83950.0
2011-07-26 08:00:00	SPY	ETF	134.01	134.06	134.01	134.06	16652.0
2011-07-26 08:05:00	SPY	ETF	134.15	134.17	134.02	134.02	1246997.0
2011-07-26 08:10:00	SPY	ETF	134.03	134.06	134.03	134.05	63350.0
2011-07-26 08:15:00	SPY	ETF	134.05	134.07	134.04	134.07	119300.0
2011-07-26 08:20:00	SPY	ETF	134.07	134.1	134.06	134.08	174840.0
2011-07-26 08:25:00	SPY	ETF	134.07	134.15	134.06	134.15	183333.0
2011-07-26 08:30:00	SPY	ETF	134.14	134.19	134.09	134.09	100286.0
2011-07-26 08:35:00	SPY	ETF	134.1	134.15	134.07	134.09	564277.0
2011-07-26 08:40:00	SPY	ETF	134.08	134.09	134.02	134.04	45621.0
2011-07-26 08:45:00	SPY	ETF	134.04	134.07	134.01	134.06	43512.0
2011-07-26 08:50:00	SPY	ETF	134.06	134.1	134.04	134.06	26260.0
2011-07-26 08:55:00	SPY	ETF	134.06	134.07	133.95	133.96	75999.0
2011-07-26 09:00:00	SPY	ETF	133.95	133.97	133.9	133.93	92493.0
2011-07-26 09:05:00	SPY	ETF	133.93	133.94	133.84	133.85	79331.0
2011-07-26 09:10:00	SPY	ETF	133.86	133.94	133.78	133.81	196455.0
2011-07-26 09:15:00	SPY	ETF	133.81	133.81	133.74	133.8	161196.0
2011-07-26 09:20:00	SPY	ETF	133.8	133.92	133.79	133.88	902167.0
2011-07-26 09:25:00	SPY	ETF	133.87	133.88	133.75	133.75	254935.0
2011-07-26 09:30:00	SPY	ETF	133.74	133.91	133.65	133.7	4227356.0
2011-07-26 09:35:00	SPY	ETF	133.7	133.73	133.54	133.55	2834053.0
2011-07-26 09:40:00	SPY	ETF	133.55	133.78	133.49	133.5	2195196.0
2011-07-26 09:45:00	SPY	ETF	133.5	133.52	133.33	133.44	2939257.0

> showing 50 of 35,742 rows — these rows as CSV

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