PREVIEW / etf_5min / 2007-10-24

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-24.parquet
  size:    431 KB
  rows:    20,408

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-10-24 04:30:00	SPY	ETF	150.88	150.88	150.88	150.88	2000.0
2007-10-24 05:40:00	SPY	ETF	151.01	151.01	151.01	151.01	17500.0
2007-10-24 05:45:00	SPY	ETF	150.98	150.98	150.98	150.98	1000.0
2007-10-24 06:05:00	SPY	ETF	150.97	151.0	150.97	151.0	200.0
2007-10-24 06:40:00	SPY	ETF	150.99	151.0	150.99	150.99	50000.0
2007-10-24 06:45:00	SPY	ETF	150.85	150.89	150.85	150.89	27000.0
2007-10-24 06:55:00	SPY	ETF	150.91	150.91	150.85	150.85	1000.0
2007-10-24 07:00:00	SPY	ETF	150.84	150.92	150.84	150.85	35300.0
2007-10-24 07:05:00	SPY	ETF	150.8	150.84	150.57	150.62	209100.0
2007-10-24 07:10:00	SPY	ETF	150.59	150.67	150.59	150.67	222500.0
2007-10-24 07:15:00	SPY	ETF	150.65	150.67	150.63	150.63	76300.0
2007-10-24 07:20:00	SPY	ETF	150.67	150.67	150.64	150.66	55900.0
2007-10-24 07:25:00	SPY	ETF	150.66	150.9	150.65	150.77	75100.0
2007-10-24 07:30:00	SPY	ETF	150.79	151.05	150.59	150.87	732400.0
2007-10-24 07:35:00	SPY	ETF	150.84	150.92	150.74	150.92	194800.0
2007-10-24 07:40:00	SPY	ETF	150.89	151.26	150.89	151.21	348400.0
2007-10-24 07:45:00	SPY	ETF	151.19	151.19	151.08	151.09	114700.0
2007-10-24 07:50:00	SPY	ETF	151.09	151.11	151.04	151.07	146000.0
2007-10-24 07:55:00	SPY	ETF	151.14	151.14	151.07	151.07	67600.0
2007-10-24 08:00:00	SPY	ETF	151.09	151.2	150.6	151.0	677000.0
2007-10-24 08:05:00	SPY	ETF	151.02	151.02	150.9	150.91	62100.0
2007-10-24 08:10:00	SPY	ETF	150.93	151.76	150.92	150.99	70600.0
2007-10-24 08:15:00	SPY	ETF	150.97	150.99	150.93	150.94	29200.0
2007-10-24 08:20:00	SPY	ETF	150.93	151.1	150.92	151.1	43200.0
2007-10-24 08:25:00	SPY	ETF	151.0	151.0	150.93	150.93	101200.0
2007-10-24 08:30:00	SPY	ETF	150.93	151.04	150.91	150.99	68700.0
2007-10-24 08:35:00	SPY	ETF	150.96	151.05	150.96	151.0	67800.0
2007-10-24 08:40:00	SPY	ETF	151.0	151.03	150.6	150.97	2029100.0
2007-10-24 08:45:00	SPY	ETF	150.97	151.05	150.96	151.02	365000.0
2007-10-24 08:50:00	SPY	ETF	151.01	151.09	151.0	151.09	29600.0
2007-10-24 08:55:00	SPY	ETF	151.09	151.19	151.05	151.15	162600.0
2007-10-24 09:00:00	SPY	ETF	151.15	151.19	151.11	151.14	465600.0
2007-10-24 09:05:00	SPY	ETF	151.15	151.29	151.15	151.25	563369.0
2007-10-24 09:10:00	SPY	ETF	151.26	151.27	151.19	151.2	93400.0
2007-10-24 09:15:00	SPY	ETF	151.22	151.24	151.18	151.22	361000.0
2007-10-24 09:20:00	SPY	ETF	151.21	151.29	151.18	151.2	647600.0
2007-10-24 09:25:00	SPY	ETF	151.2	151.21	151.13	151.2	1312504.0
2007-10-24 09:30:00	SPY	ETF	151.21	151.28	150.95	151.01	3657994.0
2007-10-24 09:35:00	SPY	ETF	151.01	151.2301	150.96	151.13	4741080.0
2007-10-24 09:40:00	SPY	ETF	151.14	151.48	151.13	151.35	3935400.0
2007-10-24 09:45:00	SPY	ETF	151.36	151.48	151.3	151.32	2322000.0
2007-10-24 09:50:00	SPY	ETF	151.33	151.46	151.28	151.41	1419200.0
2007-10-24 09:55:00	SPY	ETF	151.41	151.41	151.19	151.28	1299200.0
2007-10-24 10:00:00	SPY	ETF	151.29	151.3	150.76	150.96	7852100.0
2007-10-24 10:05:00	SPY	ETF	150.97	151.1	150.73	150.86	4161900.0
2007-10-24 10:10:00	SPY	ETF	150.86	150.87	150.51	150.63	4100200.0
2007-10-24 10:15:00	SPY	ETF	150.63	150.73	150.59	150.66	1975500.0
2007-10-24 10:20:00	SPY	ETF	150.66	150.91	150.63	150.89	3363700.0
2007-10-24 10:25:00	SPY	ETF	150.89	150.95	150.7	150.839	2257300.0
2007-10-24 10:30:00	SPY	ETF	150.83	150.99	150.76	150.82	1955300.0

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

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