PREVIEW / etf_5min / 2001-09-27

all etf 5-min files

  file:    by_date/etf_5min/2001/2001-09-27.parquet
  size:    34 KB
  rows:    1,331

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
2001-09-27 09:30:00	SPY	ETF	101.25	101.4	101.16	101.38	712600.0
2001-09-27 09:35:00	SPY	ETF	101.28	101.45	101.1	101.17	482800.0
2001-09-27 09:40:00	SPY	ETF	101.17	101.2	100.93	100.98	250500.0
2001-09-27 09:45:00	SPY	ETF	100.99	101.0	100.8	100.85	202600.0
2001-09-27 09:50:00	SPY	ETF	100.86	100.93	100.43	100.59	410900.0
2001-09-27 09:55:00	SPY	ETF	100.6	100.73	100.54	100.7	234800.0
2001-09-27 10:00:00	SPY	ETF	100.66	100.88	100.5	100.86	294100.0
2001-09-27 10:05:00	SPY	ETF	100.82	100.9	100.6	100.61	157100.0
2001-09-27 10:10:00	SPY	ETF	100.61	100.68	100.47	100.54	247500.0
2001-09-27 10:15:00	SPY	ETF	100.54	100.55	100.22	100.3	376100.0
2001-09-27 10:20:00	SPY	ETF	100.28	100.4	100.17	100.36	465500.0
2001-09-27 10:25:00	SPY	ETF	100.3	100.46	100.19	100.31	347600.0
2001-09-27 10:30:00	SPY	ETF	100.3	100.35	100.2	100.25	227000.0
2001-09-27 10:35:00	SPY	ETF	100.25	100.28	100.02	100.15	435100.0
2001-09-27 10:40:00	SPY	ETF	100.09	100.21	100.03	100.12	274100.0
2001-09-27 10:45:00	SPY	ETF	100.2	100.36	100.19	100.34	116000.0
2001-09-27 10:50:00	SPY	ETF	100.37	100.38	100.22	100.25	121800.0
2001-09-27 10:55:00	SPY	ETF	100.25	100.59	100.2	100.55	640700.0
2001-09-27 11:00:00	SPY	ETF	100.52	100.61	100.42	100.45	279300.0
2001-09-27 11:05:00	SPY	ETF	100.45	100.52	100.25	100.33	719200.0
2001-09-27 11:10:00	SPY	ETF	100.36	100.46	100.3	100.37	175600.0
2001-09-27 11:15:00	SPY	ETF	100.36	100.51	100.32	100.51	135800.0
2001-09-27 11:20:00	SPY	ETF	100.45	100.62	100.45	100.54	231000.0
2001-09-27 11:25:00	SPY	ETF	100.53	100.62	100.52	100.58	42600.0
2001-09-27 11:30:00	SPY	ETF	100.6	100.8	100.56	100.78	166200.0
2001-09-27 11:35:00	SPY	ETF	100.78	100.78	100.62	100.62	257700.0
2001-09-27 11:40:00	SPY	ETF	100.67	100.7	100.56	100.64	122500.0
2001-09-27 11:45:00	SPY	ETF	100.59	100.7	100.59	100.68	52000.0
2001-09-27 11:50:00	SPY	ETF	100.55	100.61	100.42	100.51	302000.0
2001-09-27 11:55:00	SPY	ETF	100.47	100.5	100.32	100.36	58200.0
2001-09-27 12:00:00	SPY	ETF	100.33	100.47	100.33	100.37	59200.0
2001-09-27 12:05:00	SPY	ETF	100.42	100.42	100.2	100.3	311300.0
2001-09-27 12:10:00	SPY	ETF	100.3	100.38	100.25	100.33	70900.0
2001-09-27 12:15:00	SPY	ETF	100.21	100.4	100.21	100.4	33400.0
2001-09-27 12:20:00	SPY	ETF	100.4	100.41	100.3	100.41	32600.0
2001-09-27 12:25:00	SPY	ETF	100.35	100.42	100.23	100.29	18800.0
2001-09-27 12:30:00	SPY	ETF	100.22	100.28	100.0	100.03	246900.0
2001-09-27 12:35:00	SPY	ETF	100.09	100.24	100.03	100.09	67700.0
2001-09-27 12:40:00	SPY	ETF	100.08	100.16	100.05	100.06	32400.0
2001-09-27 12:45:00	SPY	ETF	100.1	100.25	100.09	100.2	44200.0
2001-09-27 12:50:00	SPY	ETF	100.25	100.39	100.2	100.36	143700.0
2001-09-27 12:55:00	SPY	ETF	100.38	100.43	100.29	100.37	46000.0
2001-09-27 13:00:00	SPY	ETF	100.36	100.4	100.22	100.22	36300.0
2001-09-27 13:05:00	SPY	ETF	100.2	100.3	100.18	100.29	25300.0
2001-09-27 13:10:00	SPY	ETF	100.25	100.34	100.25	100.26	88300.0
2001-09-27 13:15:00	SPY	ETF	100.3	100.39	100.24	100.25	47800.0
2001-09-27 13:20:00	SPY	ETF	100.31	100.45	100.23	100.4	126500.0
2001-09-27 13:25:00	SPY	ETF	100.45	100.45	100.32	100.33	119500.0
2001-09-27 13:30:00	SPY	ETF	100.32	100.43	100.32	100.35	32800.0
2001-09-27 13:35:00	SPY	ETF	100.38	100.44	100.21	100.28	52300.0

> showing 50 of 1,331 rows — these rows as CSV

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