PREVIEW / etf_5min / 2009-07-06

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-06.parquet
  size:    662 KB
  rows:    28,289

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-07-06 04:15:00	SPY	ETF	88.88	89.03	88.88	89.03	2526.0
2009-07-06 04:25:00	SPY	ETF	89.07	89.07	89.07	89.07	300.0
2009-07-06 04:35:00	SPY	ETF	88.93	88.95	88.91	88.95	500.0
2009-07-06 04:45:00	SPY	ETF	88.89	88.89	88.89	88.89	100.0
2009-07-06 04:50:00	SPY	ETF	88.92	88.92	88.92	88.92	500.0
2009-07-06 05:00:00	SPY	ETF	88.92	88.92	88.92	88.92	1000.0
2009-07-06 05:10:00	SPY	ETF	89.03	89.03	89.03	89.03	100.0
2009-07-06 05:15:00	SPY	ETF	89.01	89.01	89.01	89.01	200.0
2009-07-06 05:40:00	SPY	ETF	88.92	88.92	88.92	88.92	100.0
2009-07-06 05:55:00	SPY	ETF	88.88	88.88	88.88	88.88	2500.0
2009-07-06 06:00:00	SPY	ETF	88.89	88.89	88.88	88.89	17500.0
2009-07-06 06:05:00	SPY	ETF	88.84	88.88	88.81	88.88	2300.0
2009-07-06 06:10:00	SPY	ETF	88.88	88.91	88.88	88.9	10100.0
2009-07-06 06:15:00	SPY	ETF	88.88	88.88	88.88	88.88	400.0
2009-07-06 06:30:00	SPY	ETF	88.86	88.88	88.84	88.84	3200.0
2009-07-06 06:35:00	SPY	ETF	88.89	88.89	88.89	88.89	1000.0
2009-07-06 06:40:00	SPY	ETF	88.89	88.89	88.87	88.87	1600.0
2009-07-06 06:45:00	SPY	ETF	88.81	88.82	88.78	88.82	1200.0
2009-07-06 06:50:00	SPY	ETF	88.8	88.8	88.76	88.76	6300.0
2009-07-06 06:55:00	SPY	ETF	88.75	88.76	88.71	88.76	7200.0
2009-07-06 07:00:00	SPY	ETF	88.79	88.83	88.78	88.81	47750.0
2009-07-06 07:05:00	SPY	ETF	88.85	88.88	88.81	88.86	8500.0
2009-07-06 07:10:00	SPY	ETF	88.83	88.83	88.8	88.81	8400.0
2009-07-06 07:15:00	SPY	ETF	88.81	88.95	88.81	88.95	50734.0
2009-07-06 07:20:00	SPY	ETF	88.97	89.0	88.96	89.0	120625.0
2009-07-06 07:25:00	SPY	ETF	89.0	89.06	89.0	89.05	66000.0
2009-07-06 07:30:00	SPY	ETF	89.05	89.05	88.95	88.95	24700.0
2009-07-06 07:35:00	SPY	ETF	88.95	88.96	88.91	88.92	4400.0
2009-07-06 07:40:00	SPY	ETF	88.92	88.92	88.85	88.85	12600.0
2009-07-06 07:45:00	SPY	ETF	88.88	88.96	88.87	88.95	23178.0
2009-07-06 07:50:00	SPY	ETF	88.95	88.96	88.93	88.93	71200.0
2009-07-06 07:55:00	SPY	ETF	88.94	89.03	88.94	89.03	66800.0
2009-07-06 08:00:00	SPY	ETF	89.03	89.53	89.0	89.04	786705.0
2009-07-06 08:05:00	SPY	ETF	89.04	89.08	89.02	89.04	65439.0
2009-07-06 08:10:00	SPY	ETF	89.04	89.04	88.95	88.97	173522.0
2009-07-06 08:15:00	SPY	ETF	88.96	88.98	88.95	88.98	50118.0
2009-07-06 08:20:00	SPY	ETF	88.97	89.4	88.97	89.01	118145.0
2009-07-06 08:25:00	SPY	ETF	89.02	89.1	89.01	89.1	153368.0
2009-07-06 08:30:00	SPY	ETF	89.1	89.12	89.05	89.07	574145.0
2009-07-06 08:35:00	SPY	ETF	89.08	90.0	89.03	89.05	172567.0
2009-07-06 08:40:00	SPY	ETF	89.06	89.354	89.0	89.01	132586.0
2009-07-06 08:45:00	SPY	ETF	89.01	89.03	88.97	89.01	163580.0
2009-07-06 08:50:00	SPY	ETF	89.02	89.06	89.02	89.05	80111.0
2009-07-06 08:55:00	SPY	ETF	89.05	89.07	89.05	89.07	78233.0
2009-07-06 09:00:00	SPY	ETF	89.08	89.09	89.0	89.0	255462.0
2009-07-06 09:05:00	SPY	ETF	89.0	89.01	88.93	88.94	457093.0
2009-07-06 09:10:00	SPY	ETF	88.93	88.98	88.92	88.95	127026.0
2009-07-06 09:15:00	SPY	ETF	88.95	88.98	88.94	88.96	99068.0
2009-07-06 09:20:00	SPY	ETF	88.96	89.0	88.96	88.99	102154.0
2009-07-06 09:25:00	SPY	ETF	88.99	89.6752	88.92	88.94	774955.0

> showing 50 of 28,289 rows — these rows as CSV

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