PREVIEW / etf_5min / 2007-09-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-09-20.parquet
  size:    364 KB
  rows:    18,485

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-09-20 04:10:00	SPY	ETF	152.93	152.93	152.93	152.93	200.0
2007-09-20 04:20:00	SPY	ETF	152.9	152.9	152.9	152.9	3000.0
2007-09-20 06:20:00	SPY	ETF	152.75	152.78	152.75	152.78	3000.0
2007-09-20 06:25:00	SPY	ETF	152.72	152.72	152.72	152.72	700.0
2007-09-20 06:40:00	SPY	ETF	152.77	152.8	152.77	152.8	5000.0
2007-09-20 06:45:00	SPY	ETF	152.77	152.77	152.77	152.77	15000.0
2007-09-20 07:00:00	SPY	ETF	152.85	152.85	152.76	152.76	50200.0
2007-09-20 07:05:00	SPY	ETF	152.76	152.76	152.7	152.7	92800.0
2007-09-20 07:10:00	SPY	ETF	152.69	152.74	152.67	152.72	106600.0
2007-09-20 07:15:00	SPY	ETF	152.71	152.73	152.69	152.72	158300.0
2007-09-20 07:20:00	SPY	ETF	152.72	152.75	152.7	152.74	85600.0
2007-09-20 07:25:00	SPY	ETF	152.74	152.84	152.74	152.83	194600.0
2007-09-20 07:30:00	SPY	ETF	152.8	152.85	152.8	152.85	121500.0
2007-09-20 07:35:00	SPY	ETF	152.86	152.88	152.73	152.75	313100.0
2007-09-20 07:40:00	SPY	ETF	152.75	152.78	152.6	152.66	410600.0
2007-09-20 07:45:00	SPY	ETF	152.66	152.78	152.65	152.71	60500.0
2007-09-20 07:50:00	SPY	ETF	152.71	152.83	152.71	152.81	136400.0
2007-09-20 07:55:00	SPY	ETF	152.84	152.85	152.78	152.85	273000.0
2007-09-20 08:00:00	SPY	ETF	152.77	153.29	152.65	153.2	4159400.0
2007-09-20 08:05:00	SPY	ETF	153.2	153.2	153.0	153.07	351600.0
2007-09-20 08:10:00	SPY	ETF	153.09	153.1	152.88	152.92	301400.0
2007-09-20 08:15:00	SPY	ETF	152.89	152.99	152.86	152.99	461900.0
2007-09-20 08:20:00	SPY	ETF	152.97	153.05	152.91	152.97	454400.0
2007-09-20 08:25:00	SPY	ETF	152.97	153.05	152.81	152.85	737300.0
2007-09-20 08:30:00	SPY	ETF	152.86	153.1	152.84	153.07	609400.0
2007-09-20 08:35:00	SPY	ETF	153.09	153.18	152.74	153.14	1038700.0
2007-09-20 08:40:00	SPY	ETF	153.15	153.18	153.11	153.17	64100.0
2007-09-20 08:45:00	SPY	ETF	153.16	153.2	153.08	153.19	147500.0
2007-09-20 08:50:00	SPY	ETF	153.18	153.26	153.15	153.23	215900.0
2007-09-20 08:55:00	SPY	ETF	153.23	153.25	153.19	153.22	76700.0
2007-09-20 09:00:00	SPY	ETF	153.21	153.25	153.17	153.19	175500.0
2007-09-20 09:05:00	SPY	ETF	153.19	153.2	153.05	153.13	228300.0
2007-09-20 09:10:00	SPY	ETF	153.13	153.13	153.03	153.07	156600.0
2007-09-20 09:15:00	SPY	ETF	153.06	153.14	153.02	153.11	557923.0
2007-09-20 09:20:00	SPY	ETF	153.12	153.19	153.08	153.17	386300.0
2007-09-20 09:25:00	SPY	ETF	153.17	153.35	153.15	153.35	590463.0
2007-09-20 09:30:00	SPY	ETF	153.34	153.36	152.99	153.03	3942833.0
2007-09-20 09:35:00	SPY	ETF	153.03	153.16	153.0	153.04	2169658.0
2007-09-20 09:40:00	SPY	ETF	153.04	153.04	152.78	152.81	3031800.0
2007-09-20 09:45:00	SPY	ETF	152.81	152.97	152.77	152.88	2358900.0
2007-09-20 09:50:00	SPY	ETF	152.88	153.16	152.88	153.1	3046300.0
2007-09-20 09:55:00	SPY	ETF	153.09	153.14	153.01	153.01	1423500.0
2007-09-20 10:00:00	SPY	ETF	153.01	153.25	152.85	153.23	1756200.0
2007-09-20 10:05:00	SPY	ETF	153.23	153.41	153.19	153.27	2547100.0
2007-09-20 10:10:00	SPY	ETF	153.27	153.43	153.21	153.34	1591500.0
2007-09-20 10:15:00	SPY	ETF	153.34	153.36	153.16	153.16	950600.0
2007-09-20 10:20:00	SPY	ETF	153.15	153.29	153.13	153.18	1295600.0
2007-09-20 10:25:00	SPY	ETF	153.18	153.28	153.1	153.12	1315000.0
2007-09-20 10:30:00	SPY	ETF	153.13	153.2	152.98	153.05	1490800.0
2007-09-20 10:35:00	SPY	ETF	153.06	153.1	152.96	153.04	1421200.0

> showing 50 of 18,485 rows — these rows as CSV

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