PREVIEW / etf_5min / 2009-01-20

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-20.parquet
  size:    688 KB
  rows:    29,234

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-20 04:15:00	SPY	ETF	84.95	84.95	84.85	84.87	13600.0
2009-01-20 04:20:00	SPY	ETF	85.0	85.0	85.0	85.0	4000.0
2009-01-20 04:25:00	SPY	ETF	85.01	85.01	85.01	85.01	100.0
2009-01-20 04:30:00	SPY	ETF	84.98	84.98	84.98	84.98	100.0
2009-01-20 04:35:00	SPY	ETF	84.98	84.98	84.98	84.98	100.0
2009-01-20 04:40:00	SPY	ETF	84.9	84.9	84.9	84.9	400.0
2009-01-20 05:00:00	SPY	ETF	84.88	84.88	84.85	84.87	700.0
2009-01-20 05:05:00	SPY	ETF	84.88	84.88	84.82	84.82	10700.0
2009-01-20 05:10:00	SPY	ETF	84.8	84.8	84.45	84.45	5200.0
2009-01-20 05:25:00	SPY	ETF	84.5	84.5	84.4	84.5	4200.0
2009-01-20 05:35:00	SPY	ETF	84.56	84.56	84.45	84.45	564.0
2009-01-20 05:40:00	SPY	ETF	84.41	84.45	84.33	84.33	1200.0
2009-01-20 05:45:00	SPY	ETF	84.3	84.3	84.23	84.23	600.0
2009-01-20 05:50:00	SPY	ETF	84.35	84.35	84.2	84.23	2285.0
2009-01-20 05:55:00	SPY	ETF	84.23	84.23	84.2	84.2	600.0
2009-01-20 06:00:00	SPY	ETF	84.31	84.47	84.31	84.42	1850.0
2009-01-20 06:10:00	SPY	ETF	84.37	84.37	84.35	84.35	9700.0
2009-01-20 06:15:00	SPY	ETF	84.37	84.38	84.36	84.38	6000.0
2009-01-20 06:20:00	SPY	ETF	84.35	84.35	84.25	84.25	1900.0
2009-01-20 06:25:00	SPY	ETF	84.25	84.25	84.25	84.25	100.0
2009-01-20 06:30:00	SPY	ETF	84.21	84.21	84.06	84.06	27780.0
2009-01-20 06:35:00	SPY	ETF	84.06	84.15	84.01	84.15	2590.0
2009-01-20 06:40:00	SPY	ETF	84.12	84.12	83.92	84.05	5600.0
2009-01-20 06:45:00	SPY	ETF	84.03	84.09	84.0	84.09	2764.0
2009-01-20 06:50:00	SPY	ETF	84.05	84.15	84.05	84.15	300.0
2009-01-20 06:55:00	SPY	ETF	84.2	84.41	84.2	84.28	8838.0
2009-01-20 07:00:00	SPY	ETF	84.22	84.45	84.22	84.41	12138.0
2009-01-20 07:05:00	SPY	ETF	84.42	84.5	84.37	84.4	19152.0
2009-01-20 07:10:00	SPY	ETF	84.39	84.41	84.36	84.37	11976.0
2009-01-20 07:15:00	SPY	ETF	84.36	84.68	84.33	84.68	17831.0
2009-01-20 07:20:00	SPY	ETF	84.7	84.78	84.65	84.71	128320.0
2009-01-20 07:25:00	SPY	ETF	84.7	84.7	84.41	84.43	103663.0
2009-01-20 07:30:00	SPY	ETF	84.42	84.43	84.29	84.29	54665.0
2009-01-20 07:35:00	SPY	ETF	84.38	84.49	84.34	84.35	46700.0
2009-01-20 07:40:00	SPY	ETF	84.35	84.49	84.27	84.27	47752.0
2009-01-20 07:45:00	SPY	ETF	84.27	84.48	84.19	84.29	216525.0
2009-01-20 07:50:00	SPY	ETF	84.28	84.41	84.28	84.28	61647.0
2009-01-20 07:55:00	SPY	ETF	84.33	84.33	84.19	84.2	144908.0
2009-01-20 08:00:00	SPY	ETF	84.2	84.65	84.0	84.0	392607.0
2009-01-20 08:05:00	SPY	ETF	83.99	84.0	83.8	83.85	419801.0
2009-01-20 08:10:00	SPY	ETF	83.82	84.03	83.8	84.03	210633.0
2009-01-20 08:15:00	SPY	ETF	84.02	84.03	83.95	83.95	80731.0
2009-01-20 08:20:00	SPY	ETF	83.95	83.95	83.83	83.86	68460.0
2009-01-20 08:25:00	SPY	ETF	83.86	83.97	83.83	83.86	97062.0
2009-01-20 08:30:00	SPY	ETF	83.86	84.03	83.86	84.01	275923.0
2009-01-20 08:35:00	SPY	ETF	84.02	84.1	84.01	84.09	146063.0
2009-01-20 08:40:00	SPY	ETF	84.08	86.2969	83.95	84.02	862235.0
2009-01-20 08:45:00	SPY	ETF	84.01	84.16	83.99	84.09	381716.0
2009-01-20 08:50:00	SPY	ETF	84.11	84.31	84.11	84.24	157853.0
2009-01-20 08:55:00	SPY	ETF	84.23	84.32	84.16	84.16	217029.0

> showing 50 of 29,234 rows — these rows as CSV

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