PREVIEW / etf_5min / 2007-11-02

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-11-02.parquet
  size:    419 KB
  rows:    20,425

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-11-02 04:15:00	SPY	ETF	151.01	151.01	151.01	151.01	100.0
2007-11-02 05:00:00	SPY	ETF	151.06	151.06	151.06	151.06	100.0
2007-11-02 05:25:00	SPY	ETF	151.11	151.11	151.11	151.11	3400.0
2007-11-02 06:35:00	SPY	ETF	150.82	150.94	150.82	150.94	13400.0
2007-11-02 06:45:00	SPY	ETF	150.86	150.86	150.79	150.79	9000.0
2007-11-02 06:55:00	SPY	ETF	150.81	150.81	150.81	150.81	2500.0
2007-11-02 07:00:00	SPY	ETF	150.8	150.8	150.61	150.62	88500.0
2007-11-02 07:05:00	SPY	ETF	150.68	150.72	150.61	150.68	12200.0
2007-11-02 07:10:00	SPY	ETF	150.68	150.71	150.68	150.71	63000.0
2007-11-02 07:15:00	SPY	ETF	150.67	150.67	150.53	150.6	71800.0
2007-11-02 07:20:00	SPY	ETF	150.61	150.61	150.34	150.46	365300.0
2007-11-02 07:25:00	SPY	ETF	150.51	150.51	150.33	150.34	134000.0
2007-11-02 07:30:00	SPY	ETF	150.38	150.49	150.36	150.49	68300.0
2007-11-02 07:35:00	SPY	ETF	150.54	150.56	150.49	150.51	56000.0
2007-11-02 07:40:00	SPY	ETF	150.53	150.88	150.52	150.88	379200.0
2007-11-02 07:45:00	SPY	ETF	150.9	150.92	150.77	150.9	243400.0
2007-11-02 07:50:00	SPY	ETF	150.84	150.86	150.82	150.84	60800.0
2007-11-02 07:55:00	SPY	ETF	150.85	150.98	150.85	150.87	62800.0
2007-11-02 08:00:00	SPY	ETF	151.17	151.17	150.42	150.86	854000.0
2007-11-02 08:05:00	SPY	ETF	150.86	150.97	150.86	150.95	206600.0
2007-11-02 08:10:00	SPY	ETF	150.98	151.12	150.97	151.05	921400.0
2007-11-02 08:15:00	SPY	ETF	151.06	151.13	150.85	150.89	462700.0
2007-11-02 08:20:00	SPY	ETF	150.9	150.99	150.88	150.9	240500.0
2007-11-02 08:25:00	SPY	ETF	150.89	150.9	150.81	150.89	234800.0
2007-11-02 08:30:00	SPY	ETF	150.72	152.0	150.56	151.84	8513000.0
2007-11-02 08:35:00	SPY	ETF	151.93	151.93	151.59	151.59	1379000.0
2007-11-02 08:40:00	SPY	ETF	151.59	151.7	151.31	151.61	2868300.0
2007-11-02 08:45:00	SPY	ETF	151.61	151.66	151.49	151.56	320600.0
2007-11-02 08:50:00	SPY	ETF	151.53	151.88	151.53	151.88	1819900.0
2007-11-02 08:55:00	SPY	ETF	151.87	151.9	151.47	151.77	2415000.0
2007-11-02 09:00:00	SPY	ETF	151.76	151.95	151.71	151.9	1751200.0
2007-11-02 09:05:00	SPY	ETF	151.95	151.95	151.8	151.8	494050.0
2007-11-02 09:10:00	SPY	ETF	151.78	151.82	151.66	151.7	280900.0
2007-11-02 09:15:00	SPY	ETF	151.71	151.79	151.69	151.7	189000.0
2007-11-02 09:20:00	SPY	ETF	151.7	151.7	151.65	151.67	81700.0
2007-11-02 09:25:00	SPY	ETF	151.67	151.7	151.54	151.54	180500.0
2007-11-02 09:30:00	SPY	ETF	151.53	151.56	151.12	151.18	10467620.0
2007-11-02 09:35:00	SPY	ETF	151.18	151.52	150.68	150.99	8133298.0
2007-11-02 09:40:00	SPY	ETF	150.99	151.3	150.98	151.18	10010614.0
2007-11-02 09:45:00	SPY	ETF	151.18	151.19	150.32	150.367	7664331.0
2007-11-02 09:50:00	SPY	ETF	150.37	150.48	149.64	149.65	13434597.0
2007-11-02 09:55:00	SPY	ETF	149.65	150.11	149.6	150.06	12176380.0
2007-11-02 10:00:00	SPY	ETF	150.05	150.23	149.63	149.82	5697971.0
2007-11-02 10:05:00	SPY	ETF	149.83	150.01	149.39	149.96	8381021.0
2007-11-02 10:10:00	SPY	ETF	149.96	150.18	149.82	149.94	5162413.0
2007-11-02 10:15:00	SPY	ETF	149.94	150.1	149.52	149.55	3615042.0
2007-11-02 10:20:00	SPY	ETF	149.55	150.03	149.5	149.96	3872542.0
2007-11-02 10:25:00	SPY	ETF	149.98	150.28	149.89	150.23	3657720.0
2007-11-02 10:30:00	SPY	ETF	150.23	150.5	150.0	150.45	6463351.0
2007-11-02 10:35:00	SPY	ETF	150.44	150.5	149.9534	150.29	4773986.0

> showing 50 of 20,425 rows — these rows as CSV

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