PREVIEW / etf_5min / 2009-08-07

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-07.parquet
  size:    757 KB
  rows:    30,938

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
2009-08-07 04:15:00	SPY	ETF	99.55	99.55	99.55	99.55	300.0
2009-08-07 04:20:00	SPY	ETF	99.57	99.57	99.57	99.57	1450.0
2009-08-07 04:25:00	SPY	ETF	99.55	99.55	99.55	99.55	100.0
2009-08-07 04:30:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 04:35:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 04:45:00	SPY	ETF	99.65	99.67	99.65	99.67	200.0
2009-08-07 04:55:00	SPY	ETF	99.54	99.54	99.54	99.54	500.0
2009-08-07 05:05:00	SPY	ETF	99.62	99.7	99.62	99.7	2200.0
2009-08-07 05:10:00	SPY	ETF	99.6	99.75	99.6	99.75	3500.0
2009-08-07 05:55:00	SPY	ETF	99.6	99.6	99.6	99.6	100.0
2009-08-07 06:00:00	SPY	ETF	99.5	99.5	99.48	99.48	400.0
2009-08-07 06:10:00	SPY	ETF	99.55	99.55	99.55	99.55	300.0
2009-08-07 06:15:00	SPY	ETF	99.5	99.5	99.5	99.5	100.0
2009-08-07 06:20:00	SPY	ETF	99.45	99.45	99.45	99.45	100.0
2009-08-07 06:25:00	SPY	ETF	99.5	99.5	99.5	99.5	10000.0
2009-08-07 06:30:00	SPY	ETF	99.51	99.51	99.51	99.51	500.0
2009-08-07 06:40:00	SPY	ETF	99.53	99.6	99.53	99.6	1200.0
2009-08-07 06:45:00	SPY	ETF	99.55	99.55	99.55	99.55	100.0
2009-08-07 06:50:00	SPY	ETF	99.5	99.55	99.5	99.55	2600.0
2009-08-07 06:55:00	SPY	ETF	99.55	99.55	99.55	99.55	5000.0
2009-08-07 07:00:00	SPY	ETF	99.57	99.63	99.56	99.63	25100.0
2009-08-07 07:05:00	SPY	ETF	99.6	99.75	99.6	99.64	95850.0
2009-08-07 07:10:00	SPY	ETF	99.65	99.67	99.63	99.64	28900.0
2009-08-07 07:15:00	SPY	ETF	99.64	99.64	99.58	99.58	29958.0
2009-08-07 07:20:00	SPY	ETF	99.6	99.68	99.6	99.68	61441.0
2009-08-07 07:25:00	SPY	ETF	99.64	99.69	99.62	99.62	94300.0
2009-08-07 07:30:00	SPY	ETF	99.62	99.72	99.61	99.72	63149.0
2009-08-07 07:35:00	SPY	ETF	99.67	99.7	99.67	99.7	13624.0
2009-08-07 07:40:00	SPY	ETF	99.68	99.72	99.66	99.72	82000.0
2009-08-07 07:45:00	SPY	ETF	99.72	99.79	99.7	99.77	87001.0
2009-08-07 07:50:00	SPY	ETF	99.77	99.87	99.76	99.77	69351.0
2009-08-07 07:55:00	SPY	ETF	99.78	99.82	99.78	99.8	28800.0
2009-08-07 08:00:00	SPY	ETF	99.79	99.9	99.79	99.85	189106.0
2009-08-07 08:05:00	SPY	ETF	99.86	99.89	99.79	99.84	221919.0
2009-08-07 08:10:00	SPY	ETF	99.85	99.86	99.76	99.77	221220.0
2009-08-07 08:15:00	SPY	ETF	99.77	99.83	99.75	99.8	267906.0
2009-08-07 08:20:00	SPY	ETF	99.79	99.87	99.78	99.87	211769.0
2009-08-07 08:25:00	SPY	ETF	99.87	99.95	99.72	99.85	529658.0
2009-08-07 08:30:00	SPY	ETF	99.97	100.83	99.88	100.69	4956102.0
2009-08-07 08:35:00	SPY	ETF	100.7	100.86	100.67	100.73	1767497.0
2009-08-07 08:40:00	SPY	ETF	100.73	100.93	100.69	100.79	2203062.0
2009-08-07 08:45:00	SPY	ETF	100.78	100.83	99.89	100.8	1328179.0
2009-08-07 08:50:00	SPY	ETF	100.8	100.87	100.73	100.76	833596.0
2009-08-07 08:55:00	SPY	ETF	100.76	100.79	100.7	100.74	410891.0
2009-08-07 09:00:00	SPY	ETF	100.73	100.99	100.73	100.96	806044.0
2009-08-07 09:05:00	SPY	ETF	100.96	101.17	100.96	101.13	1053359.0
2009-08-07 09:10:00	SPY	ETF	101.14	101.19	101.0	101.03	669531.0
2009-08-07 09:15:00	SPY	ETF	101.03	101.06	100.92	100.96	559006.0
2009-08-07 09:20:00	SPY	ETF	100.96	101.05	100.91	100.95	684135.0
2009-08-07 09:25:00	SPY	ETF	100.94	101.01	100.91	100.92	654606.0

> showing 50 of 30,938 rows — these rows as CSV

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