PREVIEW / etf_5min / 2009-01-13

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-13.parquet
  size:    622 KB
  rows:    26,827

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-13 04:15:00	SPY	ETF	86.55	86.64	86.55	86.6	2700.0
2009-01-13 04:20:00	SPY	ETF	86.52	86.52	86.52	86.52	100.0
2009-01-13 04:25:00	SPY	ETF	86.56	86.56	86.49	86.49	2000.0
2009-01-13 04:30:00	SPY	ETF	86.68	86.68	86.68	86.68	1500.0
2009-01-13 04:35:00	SPY	ETF	86.72	86.72	86.72	86.72	100.0
2009-01-13 04:55:00	SPY	ETF	86.72	86.72	86.72	86.72	100.0
2009-01-13 05:00:00	SPY	ETF	86.5	86.5	86.5	86.5	100.0
2009-01-13 05:10:00	SPY	ETF	86.52	86.52	86.52	86.52	1500.0
2009-01-13 05:20:00	SPY	ETF	86.65	86.65	86.65	86.65	100.0
2009-01-13 05:25:00	SPY	ETF	86.66	86.66	86.61	86.61	4000.0
2009-01-13 05:30:00	SPY	ETF	86.54	86.54	86.54	86.54	1000.0
2009-01-13 05:35:00	SPY	ETF	86.46	86.46	86.46	86.46	10000.0
2009-01-13 05:40:00	SPY	ETF	86.44	86.44	86.43	86.43	400.0
2009-01-13 05:45:00	SPY	ETF	86.33	86.37	86.08	86.08	600.0
2009-01-13 05:50:00	SPY	ETF	86.2	86.2	86.15	86.15	480.0
2009-01-13 05:55:00	SPY	ETF	86.34	86.34	86.25	86.25	2700.0
2009-01-13 06:00:00	SPY	ETF	86.24	86.29	86.15	86.22	3500.0
2009-01-13 06:05:00	SPY	ETF	86.27	86.27	86.27	86.27	100.0
2009-01-13 06:10:00	SPY	ETF	86.23	86.25	86.2	86.2	300.0
2009-01-13 06:15:00	SPY	ETF	86.26	86.26	86.26	86.26	500.0
2009-01-13 06:20:00	SPY	ETF	86.28	86.33	86.28	86.33	3310.0
2009-01-13 06:25:00	SPY	ETF	86.36	86.41	86.36	86.41	2100.0
2009-01-13 06:30:00	SPY	ETF	86.37	86.41	86.36	86.38	6546.0
2009-01-13 06:35:00	SPY	ETF	86.41	86.41	86.33	86.33	2400.0
2009-01-13 06:45:00	SPY	ETF	86.38	86.41	86.38	86.41	2800.0
2009-01-13 06:50:00	SPY	ETF	86.4	86.5	86.4	86.5	1000.0
2009-01-13 06:55:00	SPY	ETF	86.38	86.38	86.34	86.34	2300.0
2009-01-13 07:00:00	SPY	ETF	86.39	86.54	86.39	86.53	22400.0
2009-01-13 07:05:00	SPY	ETF	86.58	86.78	86.58	86.75	25700.0
2009-01-13 07:10:00	SPY	ETF	86.73	86.77	86.7	86.73	117383.0
2009-01-13 07:15:00	SPY	ETF	86.78	86.78	86.68	86.68	7407.0
2009-01-13 07:20:00	SPY	ETF	86.66	86.7	86.66	86.7	12111.0
2009-01-13 07:25:00	SPY	ETF	86.66	86.76	86.63	86.76	42250.0
2009-01-13 07:30:00	SPY	ETF	86.75	86.76	86.6	86.6	17837.0
2009-01-13 07:35:00	SPY	ETF	86.63	86.72	86.63	86.65	21400.0
2009-01-13 07:40:00	SPY	ETF	86.72	86.72	86.66	86.7	59700.0
2009-01-13 07:45:00	SPY	ETF	86.7	86.72	86.7	86.72	2431.0
2009-01-13 07:50:00	SPY	ETF	86.72	86.85	86.72	86.79	123188.0
2009-01-13 07:55:00	SPY	ETF	86.79	86.82	86.62	86.65	44848.0
2009-01-13 08:00:00	SPY	ETF	86.65	86.69	86.5	86.56	416185.0
2009-01-13 08:05:00	SPY	ETF	86.55	86.58	86.49	86.56	44230.0
2009-01-13 08:10:00	SPY	ETF	86.56	86.61	86.5	86.56	66409.0
2009-01-13 08:15:00	SPY	ETF	86.55	86.55	86.38	86.47	89686.0
2009-01-13 08:20:00	SPY	ETF	86.47	86.56	86.45	86.51	171126.0
2009-01-13 08:25:00	SPY	ETF	86.52	86.66	86.4503	86.4503	124873.0
2009-01-13 08:30:00	SPY	ETF	86.63	86.84	86.63	86.75	508826.0
2009-01-13 08:35:00	SPY	ETF	86.76	87.059	86.75	86.88	525944.0
2009-01-13 08:40:00	SPY	ETF	86.88	86.93	86.8	86.86	178669.0
2009-01-13 08:45:00	SPY	ETF	86.87	87.01	86.86	86.97	141481.0
2009-01-13 08:50:00	SPY	ETF	86.93	87.0	86.8	86.85	156090.0

> showing 50 of 26,827 rows — these rows as CSV

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