PREVIEW / etf_5min / 2007-07-26

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-26.parquet
  size:    461 KB
  rows:    21,576

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-07-26 04:40:00	SPY	ETF	151.16	151.16	151.16	151.16	200.0
2007-07-26 04:50:00	SPY	ETF	151.22	151.29	151.22	151.26	6000.0
2007-07-26 04:55:00	SPY	ETF	151.25	151.25	151.25	151.25	100.0
2007-07-26 05:35:00	SPY	ETF	151.36	151.36	151.36	151.36	6000.0
2007-07-26 06:10:00	SPY	ETF	151.1	151.1	150.96	150.96	4700.0
2007-07-26 06:15:00	SPY	ETF	151.02	151.09	151.02	151.09	39800.0
2007-07-26 06:20:00	SPY	ETF	151.09	151.09	151.07	151.07	9500.0
2007-07-26 06:25:00	SPY	ETF	151.21	151.25	151.21	151.25	152300.0
2007-07-26 06:30:00	SPY	ETF	151.07	151.07	151.07	151.07	200.0
2007-07-26 06:35:00	SPY	ETF	151.11	151.17	151.11	151.14	52900.0
2007-07-26 06:45:00	SPY	ETF	151.04	151.04	151.03	151.03	50000.0
2007-07-26 06:50:00	SPY	ETF	151.06	151.06	151.06	151.06	3000.0
2007-07-26 06:55:00	SPY	ETF	150.96	150.97	150.96	150.97	4900.0
2007-07-26 07:00:00	SPY	ETF	150.94	151.02	150.94	150.98	205900.0
2007-07-26 07:05:00	SPY	ETF	150.95	150.95	150.5	150.82	498800.0
2007-07-26 07:10:00	SPY	ETF	150.82	150.88	150.66	150.66	280000.0
2007-07-26 07:15:00	SPY	ETF	150.68	150.69	150.3	150.32	960300.0
2007-07-26 07:20:00	SPY	ETF	150.41	150.61	150.36	150.5	254700.0
2007-07-26 07:25:00	SPY	ETF	150.45	150.5	150.4	150.48	22000.0
2007-07-26 07:30:00	SPY	ETF	150.51	150.52	149.84	149.84	650500.0
2007-07-26 07:35:00	SPY	ETF	149.89	150.17	149.77	150.14	1146900.0
2007-07-26 07:40:00	SPY	ETF	150.16	150.28	150.1	150.1	198400.0
2007-07-26 07:45:00	SPY	ETF	150.05	150.23	150.0	150.22	333800.0
2007-07-26 07:50:00	SPY	ETF	150.2	150.4	150.14	150.33	321900.0
2007-07-26 07:55:00	SPY	ETF	150.38	150.39	150.2	150.3	141200.0
2007-07-26 08:00:00	SPY	ETF	150.35	151.0	150.0	150.26	4191600.0
2007-07-26 08:05:00	SPY	ETF	150.25	150.52	150.25	150.48	921100.0
2007-07-26 08:10:00	SPY	ETF	150.49	150.55	150.43	150.46	692600.0
2007-07-26 08:15:00	SPY	ETF	150.47	150.52	150.44	150.48	1277000.0
2007-07-26 08:20:00	SPY	ETF	150.48	150.48	150.0	150.32	2418000.0
2007-07-26 08:25:00	SPY	ETF	150.32	150.49	150.26	150.44	318000.0
2007-07-26 08:30:00	SPY	ETF	150.44	150.44	150.15	150.19	1649000.0
2007-07-26 08:35:00	SPY	ETF	150.2	150.26	150.01	150.06	924400.0
2007-07-26 08:40:00	SPY	ETF	150.05	150.34	150.0	150.04	1903200.0
2007-07-26 08:45:00	SPY	ETF	150.02	150.21	149.93	150.1	2522300.0
2007-07-26 08:50:00	SPY	ETF	150.12	150.39	149.92	149.93	2247700.0
2007-07-26 08:55:00	SPY	ETF	149.92	150.26	149.87	149.88	1254900.0
2007-07-26 09:00:00	SPY	ETF	150.11	150.14	149.97	150.08	416300.0
2007-07-26 09:05:00	SPY	ETF	150.08	150.33	150.06	150.27	580100.0
2007-07-26 09:10:00	SPY	ETF	150.27	150.34	150.04	150.12	1306400.0
2007-07-26 09:15:00	SPY	ETF	150.08	150.19	149.9	150.15	709178.0
2007-07-26 09:20:00	SPY	ETF	150.08	150.27	150.08	150.27	176600.0
2007-07-26 09:25:00	SPY	ETF	150.26	150.33	150.13	150.13	447357.0
2007-07-26 09:30:00	SPY	ETF	150.19	150.43	149.94	149.97	5140783.0
2007-07-26 09:35:00	SPY	ETF	149.96	150.3	149.55	149.87	9456170.0
2007-07-26 09:40:00	SPY	ETF	149.87	149.93	149.53	149.9	6336362.0
2007-07-26 09:45:00	SPY	ETF	149.91	150.24	149.72	150.16	6692132.0
2007-07-26 09:50:00	SPY	ETF	150.15	150.44	150.04	150.09	6921375.0
2007-07-26 09:55:00	SPY	ETF	150.09	150.29	149.73	150.2	3586318.0
2007-07-26 10:00:00	SPY	ETF	150.2	150.26	149.65	150.09	7989126.0

> showing 50 of 21,576 rows — these rows as CSV

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