PREVIEW / etf_5min / 2009-01-27

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-27.parquet
  size:    638 KB
  rows:    27,858

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
2009-01-27 04:15:00	SPY	ETF	84.78	84.78	84.78	84.78	100.0
2009-01-27 04:20:00	SPY	ETF	84.73	84.73	84.73	84.73	500.0
2009-01-27 04:30:00	SPY	ETF	84.85	84.85	84.85	84.85	100.0
2009-01-27 05:00:00	SPY	ETF	84.33	84.33	84.33	84.33	100.0
2009-01-27 05:05:00	SPY	ETF	84.21	84.21	84.21	84.21	2188.0
2009-01-27 05:10:00	SPY	ETF	84.23	84.23	84.23	84.23	100.0
2009-01-27 06:10:00	SPY	ETF	84.14	84.14	84.14	84.14	1500.0
2009-01-27 06:30:00	SPY	ETF	83.95	83.98	83.92	83.92	3200.0
2009-01-27 06:40:00	SPY	ETF	83.88	83.91	83.8	83.8	18000.0
2009-01-27 06:50:00	SPY	ETF	83.95	84.03	83.95	83.97	1400.0
2009-01-27 06:55:00	SPY	ETF	83.93	83.93	83.91	83.91	600.0
2009-01-27 07:00:00	SPY	ETF	84.0	84.0	83.95	84.0	12300.0
2009-01-27 07:05:00	SPY	ETF	83.98	84.0	83.9	83.91	23400.0
2009-01-27 07:10:00	SPY	ETF	83.92	83.92	83.8	83.8	7369.0
2009-01-27 07:15:00	SPY	ETF	83.81	83.85	83.69	83.8	131166.0
2009-01-27 07:20:00	SPY	ETF	83.76	83.78	83.67	83.78	115178.0
2009-01-27 07:25:00	SPY	ETF	83.8	83.87	83.76	83.87	33399.0
2009-01-27 07:30:00	SPY	ETF	83.87	83.98	83.79	83.81	32569.0
2009-01-27 07:35:00	SPY	ETF	83.83	83.93	83.76	83.92	55376.0
2009-01-27 07:40:00	SPY	ETF	83.94	83.98	83.92	83.96	70707.0
2009-01-27 07:45:00	SPY	ETF	83.96	84.18	83.96	84.14	157115.0
2009-01-27 07:50:00	SPY	ETF	84.14	84.15	84.07	84.12	75600.0
2009-01-27 07:55:00	SPY	ETF	84.14	84.14	84.05	84.09	45075.0
2009-01-27 08:00:00	SPY	ETF	84.1	84.25	84.06	84.19	64449.0
2009-01-27 08:05:00	SPY	ETF	84.19	84.25	84.13	84.15	60034.0
2009-01-27 08:10:00	SPY	ETF	84.15	84.21	84.15	84.18	17093.0
2009-01-27 08:15:00	SPY	ETF	84.17	84.25	84.06	84.19	103978.0
2009-01-27 08:20:00	SPY	ETF	84.19	84.31	84.19	84.31	411638.0
2009-01-27 08:25:00	SPY	ETF	84.3	84.55	84.3	84.46	216015.0
2009-01-27 08:30:00	SPY	ETF	84.44	84.44	84.35	84.39	202018.0
2009-01-27 08:35:00	SPY	ETF	84.39	84.4	84.29	84.34	143553.0
2009-01-27 08:40:00	SPY	ETF	84.32	84.34	84.23	84.28	203955.0
2009-01-27 08:45:00	SPY	ETF	84.28	84.43	84.28	84.36	160905.0
2009-01-27 08:50:00	SPY	ETF	84.36	84.58	84.36	84.51	202572.0
2009-01-27 08:55:00	SPY	ETF	84.5	84.52	84.46	84.46	298165.0
2009-01-27 09:00:00	SPY	ETF	84.49	84.52	84.35	84.44	183799.0
2009-01-27 09:05:00	SPY	ETF	84.42	84.5	84.36	84.37	348859.0
2009-01-27 09:10:00	SPY	ETF	84.38	84.42	84.35	84.39	260870.0
2009-01-27 09:15:00	SPY	ETF	84.38	84.42	84.26	84.26	123793.0
2009-01-27 09:20:00	SPY	ETF	84.25	84.32	84.21	84.23	253329.0
2009-01-27 09:25:00	SPY	ETF	84.22	84.25	84.11	84.13	381547.0
2009-01-27 09:30:00	SPY	ETF	84.13	84.24	83.99	84.22	4894500.0
2009-01-27 09:35:00	SPY	ETF	84.22	84.8	84.19	84.76	5245445.0
2009-01-27 09:40:00	SPY	ETF	84.76	84.8	84.61	84.69	6226627.0
2009-01-27 09:45:00	SPY	ETF	84.69	84.85	84.45	84.51	4610348.0
2009-01-27 09:50:00	SPY	ETF	84.51	84.7	84.46	84.5125	3819152.0
2009-01-27 09:55:00	SPY	ETF	84.52	84.72	84.35	84.42	3556062.0
2009-01-27 10:00:00	SPY	ETF	84.44	84.55	84.03	84.2199	7445730.0
2009-01-27 10:05:00	SPY	ETF	84.21	84.22	83.62	83.77	6304056.0
2009-01-27 10:10:00	SPY	ETF	83.77	83.86	83.56	83.73	5396098.0

> showing 50 of 27,858 rows — these rows as CSV

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