PREVIEW / etf_5min / 2009-01-14

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-14.parquet
  size:    651 KB
  rows:    28,033

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-14 04:15:00	SPY	ETF	87.1	87.15	87.1	87.12	1400.0
2009-01-14 04:30:00	SPY	ETF	86.95	86.95	86.95	86.95	100.0
2009-01-14 04:35:00	SPY	ETF	86.8	86.8	86.8	86.8	200.0
2009-01-14 04:50:00	SPY	ETF	86.92	86.92	86.64	86.64	1013.0
2009-01-14 04:55:00	SPY	ETF	86.7	86.7	86.64	86.64	200.0
2009-01-14 05:00:00	SPY	ETF	86.61	86.61	86.49	86.51	1300.0
2009-01-14 05:05:00	SPY	ETF	86.55	86.6	86.55	86.6	400.0
2009-01-14 05:10:00	SPY	ETF	86.61	86.68	86.61	86.68	7600.0
2009-01-14 05:15:00	SPY	ETF	86.61	86.61	86.58	86.58	200.0
2009-01-14 05:20:00	SPY	ETF	86.52	86.61	86.52	86.61	200.0
2009-01-14 05:25:00	SPY	ETF	86.61	86.65	86.61	86.65	600.0
2009-01-14 05:30:00	SPY	ETF	86.66	86.73	86.66	86.73	380.0
2009-01-14 05:35:00	SPY	ETF	86.77	86.77	86.77	86.77	200.0
2009-01-14 05:40:00	SPY	ETF	86.85	86.85	86.84	86.84	700.0
2009-01-14 06:00:00	SPY	ETF	86.87	86.87	86.87	86.87	300.0
2009-01-14 06:05:00	SPY	ETF	86.93	86.93	86.9	86.9	500.0
2009-01-14 06:10:00	SPY	ETF	86.85	86.85	86.83	86.83	2000.0
2009-01-14 06:15:00	SPY	ETF	86.83	86.84	86.76	86.77	10000.0
2009-01-14 06:20:00	SPY	ETF	86.73	86.73	86.61	86.61	5780.0
2009-01-14 06:30:00	SPY	ETF	86.6	86.6	86.4	86.4	4700.0
2009-01-14 06:35:00	SPY	ETF	86.47	86.47	86.26	86.26	4550.0
2009-01-14 06:40:00	SPY	ETF	86.32	86.35	86.32	86.35	1600.0
2009-01-14 06:45:00	SPY	ETF	86.37	86.4	86.37	86.4	2600.0
2009-01-14 06:50:00	SPY	ETF	86.43	86.45	86.41	86.41	6100.0
2009-01-14 06:55:00	SPY	ETF	86.39	86.48	86.39	86.48	8436.0
2009-01-14 07:00:00	SPY	ETF	86.49	86.62	86.49	86.61	229004.0
2009-01-14 07:05:00	SPY	ETF	86.63	86.64	86.54	86.61	75943.0
2009-01-14 07:10:00	SPY	ETF	86.62	86.64	86.53	86.54	95399.0
2009-01-14 07:15:00	SPY	ETF	86.53	86.56	86.49	86.54	100949.0
2009-01-14 07:20:00	SPY	ETF	86.53	86.58	86.51	86.54	17374.0
2009-01-14 07:25:00	SPY	ETF	86.57	86.6	86.53	86.55	22316.0
2009-01-14 07:30:00	SPY	ETF	86.55	86.6	86.54	86.57	17558.0
2009-01-14 07:35:00	SPY	ETF	86.56	86.62	86.53	86.62	29090.0
2009-01-14 07:40:00	SPY	ETF	86.63	86.63	86.5	86.5	46235.0
2009-01-14 07:45:00	SPY	ETF	86.5	86.53	86.46	86.48	172732.0
2009-01-14 07:50:00	SPY	ETF	86.48	86.52	86.47	86.5	89783.0
2009-01-14 07:55:00	SPY	ETF	86.5	86.52	86.34	86.38	173776.0
2009-01-14 08:00:00	SPY	ETF	86.38	86.575	86.24	86.25	696413.0
2009-01-14 08:05:00	SPY	ETF	86.25	86.28	86.17	86.24	123739.0
2009-01-14 08:10:00	SPY	ETF	86.24	86.24	85.97	86.03	396463.0
2009-01-14 08:15:00	SPY	ETF	86.05	86.06	85.85	85.93	430365.0
2009-01-14 08:20:00	SPY	ETF	85.93	86.08	85.85	86.07	160634.0
2009-01-14 08:25:00	SPY	ETF	86.08	86.19	86.08	86.12	127701.0
2009-01-14 08:30:00	SPY	ETF	86.07	86.12	85.72	85.79	974203.0
2009-01-14 08:35:00	SPY	ETF	85.8	85.93	85.71	85.76	525522.0
2009-01-14 08:40:00	SPY	ETF	85.77	85.96	85.7	85.92	687817.0
2009-01-14 08:45:00	SPY	ETF	85.92	85.92	85.63	85.68	414379.0
2009-01-14 08:50:00	SPY	ETF	85.69	85.7	85.53	85.6	438516.0
2009-01-14 08:55:00	SPY	ETF	85.61	85.67	85.46	85.64	790284.0
2009-01-14 09:00:00	SPY	ETF	85.63	85.64	85.3	85.38	651789.0

> showing 50 of 28,033 rows — these rows as CSV

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