PREVIEW / etf_5min / 2009-01-07

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-07.parquet
  size:    657 KB
  rows:    27,511

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-07 04:15:00	SPY	ETF	92.48	92.52	92.45	92.5	2300.0
2009-01-07 04:20:00	SPY	ETF	92.51	92.51	92.45	92.45	1000.0
2009-01-07 04:35:00	SPY	ETF	92.62	92.62	92.62	92.62	800.0
2009-01-07 05:00:00	SPY	ETF	92.62	92.62	92.62	92.62	100.0
2009-01-07 05:05:00	SPY	ETF	92.55	92.55	92.55	92.55	100.0
2009-01-07 05:20:00	SPY	ETF	92.84	92.84	92.84	92.84	1970.0
2009-01-07 05:30:00	SPY	ETF	92.73	92.73	92.73	92.73	100.0
2009-01-07 05:45:00	SPY	ETF	92.73	92.73	92.73	92.73	200.0
2009-01-07 05:55:00	SPY	ETF	92.8	92.8	92.77	92.77	1100.0
2009-01-07 06:00:00	SPY	ETF	92.73	92.73	92.73	92.73	600.0
2009-01-07 06:05:00	SPY	ETF	92.77	92.77	92.77	92.77	500.0
2009-01-07 06:10:00	SPY	ETF	92.81	92.81	92.81	92.81	100.0
2009-01-07 06:20:00	SPY	ETF	92.84	92.84	92.82	92.82	300.0
2009-01-07 06:25:00	SPY	ETF	92.88	92.88	92.88	92.88	100.0
2009-01-07 06:30:00	SPY	ETF	92.77	92.77	92.77	92.77	200.0
2009-01-07 06:35:00	SPY	ETF	92.82	92.82	92.79	92.79	10300.0
2009-01-07 06:40:00	SPY	ETF	92.79	92.8	92.79	92.8	10000.0
2009-01-07 06:45:00	SPY	ETF	92.77	92.77	92.75	92.77	800.0
2009-01-07 06:50:00	SPY	ETF	92.73	92.73	92.71	92.71	2600.0
2009-01-07 06:55:00	SPY	ETF	92.66	92.73	92.64	92.73	52230.0
2009-01-07 07:00:00	SPY	ETF	92.7	92.73	92.65	92.66	37094.0
2009-01-07 07:05:00	SPY	ETF	92.66	92.68	92.65	92.68	1915.0
2009-01-07 07:10:00	SPY	ETF	92.65	92.68	92.61	92.67	90609.0
2009-01-07 07:15:00	SPY	ETF	92.68	92.69	92.66	92.66	50919.0
2009-01-07 07:20:00	SPY	ETF	92.68	92.71	92.67	92.69	64213.0
2009-01-07 07:25:00	SPY	ETF	92.67	92.69	92.67	92.69	8737.0
2009-01-07 07:30:00	SPY	ETF	92.67	92.67	92.61	92.62	13107.0
2009-01-07 07:35:00	SPY	ETF	92.64	92.66	92.64	92.66	9669.0
2009-01-07 07:40:00	SPY	ETF	92.64	92.65	92.63	92.65	5513.0
2009-01-07 07:45:00	SPY	ETF	92.66	92.71	92.66	92.7	10475.0
2009-01-07 07:50:00	SPY	ETF	92.68	92.68	92.62	92.66	7857.0
2009-01-07 07:55:00	SPY	ETF	92.64	92.66	92.46	92.52	55510.0
2009-01-07 08:00:00	SPY	ETF	92.5	92.85	92.47	92.54	94180.0
2009-01-07 08:05:00	SPY	ETF	92.54	92.66	92.53	92.64	54287.0
2009-01-07 08:10:00	SPY	ETF	92.64	92.72	92.63	92.65	188752.0
2009-01-07 08:15:00	SPY	ETF	92.64	92.66	92.03	92.14	1024707.0
2009-01-07 08:20:00	SPY	ETF	92.15	92.28	92.04	92.06	321753.0
2009-01-07 08:25:00	SPY	ETF	92.07	92.11	91.94	92.0	240468.0
2009-01-07 08:30:00	SPY	ETF	92.0	92.15	91.95	92.08	246634.0
2009-01-07 08:35:00	SPY	ETF	92.09	92.09	91.91	91.93	273560.0
2009-01-07 08:40:00	SPY	ETF	91.93	92.13	91.88	92.08	253322.0
2009-01-07 08:45:00	SPY	ETF	92.08	92.34	92.06	92.26	265322.0
2009-01-07 08:50:00	SPY	ETF	92.26	92.35	92.25	92.3	93816.0
2009-01-07 08:55:00	SPY	ETF	92.3	92.35	92.11	92.17	343207.0
2009-01-07 09:00:00	SPY	ETF	92.17	92.18	91.61	91.76	2025753.0
2009-01-07 09:05:00	SPY	ETF	91.75	91.85	91.66	91.84	214663.0
2009-01-07 09:10:00	SPY	ETF	91.84	91.92	91.81	91.82	178428.0
2009-01-07 09:15:00	SPY	ETF	91.81	91.96	91.81	91.96	120128.0
2009-01-07 09:20:00	SPY	ETF	91.95	91.99	91.92	91.93	111164.0
2009-01-07 09:25:00	SPY	ETF	91.93	92.01	91.86	91.99	285969.0

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

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