PREVIEW / etf_5min / 2007-08-27

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-27.parquet
  size:    318 KB
  rows:    16,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
2007-08-27 04:15:00	SPY	ETF	147.85	147.85	147.85	147.85	100.0
2007-08-27 06:45:00	SPY	ETF	147.86	147.86	147.86	147.86	600.0
2007-08-27 06:50:00	SPY	ETF	147.86	147.86	147.86	147.86	2000.0
2007-08-27 06:55:00	SPY	ETF	147.86	147.86	147.86	147.86	500.0
2007-08-27 07:00:00	SPY	ETF	147.9	147.9	147.83	147.83	40300.0
2007-08-27 07:05:00	SPY	ETF	147.89	147.91	147.87	147.87	14700.0
2007-08-27 07:10:00	SPY	ETF	147.91	147.99	147.89	147.99	10100.0
2007-08-27 07:15:00	SPY	ETF	147.99	148.0	147.96	147.96	11200.0
2007-08-27 07:20:00	SPY	ETF	147.99	148.01	147.96	147.96	10700.0
2007-08-27 07:25:00	SPY	ETF	147.96	147.96	147.9	147.96	35200.0
2007-08-27 07:30:00	SPY	ETF	147.96	147.96	147.92	147.96	4300.0
2007-08-27 07:35:00	SPY	ETF	148.01	148.01	148.01	148.01	3300.0
2007-08-27 07:40:00	SPY	ETF	148.0	148.01	147.96	147.96	31100.0
2007-08-27 07:45:00	SPY	ETF	148.02	148.02	148.01	148.01	5800.0
2007-08-27 07:50:00	SPY	ETF	148.0	148.1	147.95	148.07	19300.0
2007-08-27 07:55:00	SPY	ETF	148.07	148.08	148.01	148.01	23100.0
2007-08-27 08:00:00	SPY	ETF	148.06	148.06	148.0	148.0	35000.0
2007-08-27 08:05:00	SPY	ETF	148.01	148.03	147.98	147.98	10800.0
2007-08-27 08:10:00	SPY	ETF	148.0	148.0	147.88	147.91	99600.0
2007-08-27 08:15:00	SPY	ETF	147.91	147.91	147.88	147.89	364400.0
2007-08-27 08:20:00	SPY	ETF	147.92	147.92	147.84	147.84	35900.0
2007-08-27 08:25:00	SPY	ETF	147.87	147.9	147.81	147.88	83600.0
2007-08-27 08:30:00	SPY	ETF	147.88	147.92	147.87	147.91	31400.0
2007-08-27 08:35:00	SPY	ETF	147.92	147.93	147.89	147.89	9500.0
2007-08-27 08:40:00	SPY	ETF	147.88	147.91	147.85	147.91	249500.0
2007-08-27 08:45:00	SPY	ETF	147.92	147.93	147.9	147.93	120800.0
2007-08-27 08:50:00	SPY	ETF	147.92	147.92	147.88	147.9	6400.0
2007-08-27 08:55:00	SPY	ETF	147.88	147.95	147.8	147.89	143400.0
2007-08-27 09:00:00	SPY	ETF	147.89	147.89	147.84	147.86	32200.0
2007-08-27 09:05:00	SPY	ETF	147.86	147.88	147.85	147.86	51200.0
2007-08-27 09:10:00	SPY	ETF	147.88	147.9	147.84	147.9	185800.0
2007-08-27 09:15:00	SPY	ETF	147.89	147.89	147.85	147.88	69800.0
2007-08-27 09:20:00	SPY	ETF	147.88	147.94	147.88	147.93	29500.0
2007-08-27 09:25:00	SPY	ETF	147.94	147.94	147.85	147.86	158500.0
2007-08-27 09:30:00	SPY	ETF	147.85	147.91	147.65	147.76	2815020.0
2007-08-27 09:35:00	SPY	ETF	147.76	147.93	147.7	147.81	1701716.0
2007-08-27 09:40:00	SPY	ETF	147.81	147.83	147.63	147.74	1357300.0
2007-08-27 09:45:00	SPY	ETF	147.73	147.73	147.58	147.62	1784274.0
2007-08-27 09:50:00	SPY	ETF	147.62	147.815	147.46	147.64	2297860.0
2007-08-27 09:55:00	SPY	ETF	147.64	147.865	147.6	147.72	1292657.0
2007-08-27 10:00:00	SPY	ETF	147.71	147.9	147.43	147.54	3972833.0
2007-08-27 10:05:00	SPY	ETF	147.56	147.74	147.34	147.39	3466423.0
2007-08-27 10:10:00	SPY	ETF	147.39	147.665	147.35	147.48	1129700.0
2007-08-27 10:15:00	SPY	ETF	147.48	147.705	147.42	147.51	1928000.0
2007-08-27 10:20:00	SPY	ETF	147.51	147.791	147.41	147.46	1734100.0
2007-08-27 10:25:00	SPY	ETF	147.46	147.565	147.32	147.44	1703277.0
2007-08-27 10:30:00	SPY	ETF	147.45	147.49	147.35	147.43	543063.0
2007-08-27 10:35:00	SPY	ETF	147.42	147.43	147.25	147.35	1548980.0
2007-08-27 10:40:00	SPY	ETF	147.35	147.45	147.25	147.32	722800.0
2007-08-27 10:45:00	SPY	ETF	147.31	147.37	147.22	147.35	761599.0

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

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