PREVIEW / etf_5min / 2007-03-20

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-03-20.parquet
  size:    297 KB
  rows:    13,845

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-03-20 06:55:00	SPY	ETF	140.0	140.0	140.0	140.0	5000.0
2007-03-20 07:00:00	SPY	ETF	140.01	140.01	139.97	139.99	50100.0
2007-03-20 07:05:00	SPY	ETF	140.04	140.04	139.99	139.99	11800.0
2007-03-20 07:15:00	SPY	ETF	140.02	140.02	140.02	140.02	6500.0
2007-03-20 07:20:00	SPY	ETF	140.0	140.0	140.0	140.0	3500.0
2007-03-20 07:25:00	SPY	ETF	139.99	139.99	139.95	139.95	7200.0
2007-03-20 07:30:00	SPY	ETF	139.96	139.96	139.93	139.96	19500.0
2007-03-20 07:35:00	SPY	ETF	139.96	140.01	139.96	140.01	53900.0
2007-03-20 07:40:00	SPY	ETF	140.01	140.01	140.01	140.01	1200.0
2007-03-20 07:50:00	SPY	ETF	139.98	139.99	139.98	139.99	900.0
2007-03-20 07:55:00	SPY	ETF	139.99	140.0	139.98	139.99	9200.0
2007-03-20 08:00:00	SPY	ETF	139.97	140.09	139.97	140.09	37700.0
2007-03-20 08:05:00	SPY	ETF	140.09	140.09	140.0	140.02	136500.0
2007-03-20 08:10:00	SPY	ETF	140.04	140.07	140.02	140.07	132900.0
2007-03-20 08:15:00	SPY	ETF	140.04	140.08	140.04	140.08	8300.0
2007-03-20 08:20:00	SPY	ETF	140.06	140.17	140.06	140.16	66700.0
2007-03-20 08:25:00	SPY	ETF	140.14	140.14	140.09	140.09	125700.0
2007-03-20 08:30:00	SPY	ETF	140.12	140.39	140.11	140.31	1602000.0
2007-03-20 08:35:00	SPY	ETF	140.31	140.39	140.31	140.31	344400.0
2007-03-20 08:40:00	SPY	ETF	140.3	140.31	140.21	140.25	93100.0
2007-03-20 08:45:00	SPY	ETF	140.26	140.27	140.11	140.12	139700.0
2007-03-20 08:50:00	SPY	ETF	140.12	140.19	140.12	140.19	41400.0
2007-03-20 08:55:00	SPY	ETF	140.19	140.2	140.11	140.13	249400.0
2007-03-20 09:00:00	SPY	ETF	140.11	140.13	140.07	140.08	30600.0
2007-03-20 09:05:00	SPY	ETF	140.07	140.13	140.06	140.13	109000.0
2007-03-20 09:10:00	SPY	ETF	140.13	140.2	140.13	140.2	128800.0
2007-03-20 09:15:00	SPY	ETF	140.21	140.23	140.17	140.17	21000.0
2007-03-20 09:20:00	SPY	ETF	140.16	140.16	140.05	140.06	79100.0
2007-03-20 09:25:00	SPY	ETF	140.05	140.1	140.0	140.08	252500.0
2007-03-20 09:30:00	SPY	ETF	140.08	140.13	139.96	140.13	1153700.0
2007-03-20 09:35:00	SPY	ETF	140.14	140.22	140.08	140.14	1923942.0
2007-03-20 09:40:00	SPY	ETF	140.14	140.17	140.06	140.17	1031600.0
2007-03-20 09:45:00	SPY	ETF	140.19	140.32	140.18	140.23	1482900.0
2007-03-20 09:50:00	SPY	ETF	140.24	140.26	140.15	140.16	785800.0
2007-03-20 09:55:00	SPY	ETF	140.17	140.25	140.05	140.05	986300.0
2007-03-20 10:00:00	SPY	ETF	140.05	140.13	139.97	140.02	859700.0
2007-03-20 10:05:00	SPY	ETF	140.0328	140.16	140.01	140.16	718600.0
2007-03-20 10:10:00	SPY	ETF	140.16	140.28	140.16	140.23	1094200.0
2007-03-20 10:15:00	SPY	ETF	140.23	140.24	140.04	140.06	598600.0
2007-03-20 10:20:00	SPY	ETF	140.06	140.17	140.02	140.13	954100.0
2007-03-20 10:25:00	SPY	ETF	140.13	140.22	140.13	140.21	404800.0
2007-03-20 10:30:00	SPY	ETF	140.21	140.25	140.12	140.14	1562400.0
2007-03-20 10:35:00	SPY	ETF	140.14	140.24	140.14	140.18	644000.0
2007-03-20 10:40:00	SPY	ETF	140.18	140.38	140.18	140.36	2128100.0
2007-03-20 10:45:00	SPY	ETF	140.37	140.37	140.26	140.28	544400.0
2007-03-20 10:50:00	SPY	ETF	140.29	140.42	140.28	140.32	1310400.0
2007-03-20 10:55:00	SPY	ETF	140.33	140.38	140.3	140.3599	530100.0
2007-03-20 11:00:00	SPY	ETF	140.36	140.43	140.34	140.35	567358.0
2007-03-20 11:05:00	SPY	ETF	140.36	140.49	140.34	140.47	886800.0
2007-03-20 11:10:00	SPY	ETF	140.47	140.55	140.45	140.52	2686300.0

> showing 50 of 13,845 rows — these rows as CSV

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