PREVIEW / etf_5min / 2007-07-27

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-27.parquet
  size:    423 KB
  rows:    20,198

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-27 04:05:00	SPY	ETF	148.4	148.4	148.4	148.4	13000.0
2007-07-27 04:15:00	SPY	ETF	148.2	148.2	148.2	148.2	1000.0
2007-07-27 04:25:00	SPY	ETF	148.51	148.52	148.4	148.52	5600.0
2007-07-27 04:30:00	SPY	ETF	148.52	148.52	148.52	148.52	1000.0
2007-07-27 04:35:00	SPY	ETF	148.52	148.52	148.52	148.52	600.0
2007-07-27 04:40:00	SPY	ETF	148.65	148.65	148.65	148.65	2000.0
2007-07-27 04:45:00	SPY	ETF	148.67	148.67	148.67	148.67	2000.0
2007-07-27 04:50:00	SPY	ETF	148.84	148.84	148.84	148.84	2700.0
2007-07-27 04:55:00	SPY	ETF	148.72	148.72	148.72	148.72	1000.0
2007-07-27 05:00:00	SPY	ETF	148.75	148.75	148.75	148.75	1500.0
2007-07-27 05:20:00	SPY	ETF	148.6	148.6	148.6	148.6	500.0
2007-07-27 05:55:00	SPY	ETF	148.4	148.4	148.4	148.4	5000.0
2007-07-27 06:25:00	SPY	ETF	148.17	148.17	148.17	148.17	600.0
2007-07-27 06:30:00	SPY	ETF	148.38	148.38	148.35	148.35	1500.0
2007-07-27 06:35:00	SPY	ETF	148.42	148.47	148.42	148.47	4300.0
2007-07-27 06:40:00	SPY	ETF	148.47	148.48	148.47	148.48	12500.0
2007-07-27 06:45:00	SPY	ETF	148.42	148.42	148.42	148.42	1000.0
2007-07-27 06:50:00	SPY	ETF	148.33	148.33	148.23	148.23	200.0
2007-07-27 06:55:00	SPY	ETF	148.01	148.1	147.99	148.08	94700.0
2007-07-27 07:00:00	SPY	ETF	148.1	148.1	147.88	147.93	284100.0
2007-07-27 07:05:00	SPY	ETF	147.87	147.87	147.66	147.74	212300.0
2007-07-27 07:10:00	SPY	ETF	147.75	147.75	147.5	147.6	570400.0
2007-07-27 07:15:00	SPY	ETF	147.63	147.7	147.1	147.4	799900.0
2007-07-27 07:20:00	SPY	ETF	147.37	147.48	147.18	147.2	829500.0
2007-07-27 07:25:00	SPY	ETF	147.16	147.3	146.98	147.03	960400.0
2007-07-27 07:30:00	SPY	ETF	147.03	147.2	147.0	147.08	641300.0
2007-07-27 07:35:00	SPY	ETF	147.08	147.34	147.08	147.29	504100.0
2007-07-27 07:40:00	SPY	ETF	147.31	147.42	147.18	147.24	238900.0
2007-07-27 07:45:00	SPY	ETF	147.2	147.2	147.01	147.08	114500.0
2007-07-27 07:50:00	SPY	ETF	147.01	147.3	146.95	147.3	590800.0
2007-07-27 07:55:00	SPY	ETF	147.3	147.3	146.92	147.07	352500.0
2007-07-27 08:00:00	SPY	ETF	147.33	147.81	146.96	147.33	4574100.0
2007-07-27 08:05:00	SPY	ETF	147.33	147.47	147.16	147.2	1043400.0
2007-07-27 08:10:00	SPY	ETF	147.19	147.3	147.07	147.09	932400.0
2007-07-27 08:15:00	SPY	ETF	147.09	147.21	146.98	147.1	950100.0
2007-07-27 08:20:00	SPY	ETF	147.07	148.12	146.95	147.08	750900.0
2007-07-27 08:25:00	SPY	ETF	147.09	147.2	146.93	147.15	828200.0
2007-07-27 08:30:00	SPY	ETF	147.19	147.57	147.03	147.17	5142700.0
2007-07-27 08:35:00	SPY	ETF	147.2	147.32	147.1	147.22	718500.0
2007-07-27 08:40:00	SPY	ETF	147.24	148.47	147.22	147.91	3107200.0
2007-07-27 08:45:00	SPY	ETF	147.88	148.16	147.82	147.82	3120800.0
2007-07-27 08:50:00	SPY	ETF	147.81	147.82	147.03	147.66	1722200.0
2007-07-27 08:55:00	SPY	ETF	147.69	147.76	147.64	147.69	653200.0
2007-07-27 09:00:00	SPY	ETF	147.65	148.0	147.65	147.98	700800.0
2007-07-27 09:05:00	SPY	ETF	148.0	148.14	147.9	147.93	1159500.0
2007-07-27 09:10:00	SPY	ETF	147.94	148.11	147.93	147.99	656500.0
2007-07-27 09:15:00	SPY	ETF	147.98	148.12	147.94	148.01	674400.0
2007-07-27 09:20:00	SPY	ETF	148.0	148.13	147.94	148.13	1296400.0
2007-07-27 09:25:00	SPY	ETF	148.12	148.26	148.12	148.26	958700.0
2007-07-27 09:30:00	SPY	ETF	148.21	148.26	147.81	148.09	6056796.0

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

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