PREVIEW / etf_5min / 2009-01-22

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-01-22.parquet
  size:    656 KB
  rows:    28,002

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-22 04:15:00	SPY	ETF	84.28	84.28	84.28	84.28	100.0
2009-01-22 04:20:00	SPY	ETF	84.22	84.22	84.15	84.15	200.0
2009-01-22 04:25:00	SPY	ETF	84.12	84.12	84.12	84.12	500.0
2009-01-22 04:30:00	SPY	ETF	84.16	84.16	84.07	84.07	400.0
2009-01-22 04:35:00	SPY	ETF	84.07	84.07	84.07	84.07	1500.0
2009-01-22 04:40:00	SPY	ETF	84.17	84.17	84.17	84.17	200.0
2009-01-22 04:45:00	SPY	ETF	84.26	84.26	84.26	84.26	400.0
2009-01-22 04:55:00	SPY	ETF	84.38	84.38	84.38	84.38	100.0
2009-01-22 05:00:00	SPY	ETF	84.17	84.17	84.17	84.17	100.0
2009-01-22 05:05:00	SPY	ETF	83.98	83.98	83.98	83.98	1300.0
2009-01-22 05:15:00	SPY	ETF	83.95	83.95	83.95	83.95	100.0
2009-01-22 05:35:00	SPY	ETF	84.1	84.1	83.95	83.95	300.0
2009-01-22 05:50:00	SPY	ETF	83.85	83.85	83.71	83.71	600.0
2009-01-22 05:55:00	SPY	ETF	83.7	83.7	83.7	83.7	400.0
2009-01-22 06:00:00	SPY	ETF	83.68	83.8	83.6	83.8	41199.0
2009-01-22 06:05:00	SPY	ETF	83.75	83.75	83.75	83.75	1000.0
2009-01-22 06:10:00	SPY	ETF	83.77	83.77	83.6	83.6	900.0
2009-01-22 06:15:00	SPY	ETF	83.51	83.51	83.33	83.41	7800.0
2009-01-22 06:20:00	SPY	ETF	83.49	83.56	83.49	83.56	5700.0
2009-01-22 06:25:00	SPY	ETF	83.45	83.45	83.35	83.35	1700.0
2009-01-22 06:30:00	SPY	ETF	83.35	83.35	83.25	83.33	3700.0
2009-01-22 06:35:00	SPY	ETF	83.3	83.3	83.3	83.3	100.0
2009-01-22 06:40:00	SPY	ETF	83.4	83.5	83.4	83.42	400.0
2009-01-22 06:45:00	SPY	ETF	83.54	83.54	83.47	83.47	5000.0
2009-01-22 06:50:00	SPY	ETF	83.54	83.54	83.52	83.52	1300.0
2009-01-22 06:55:00	SPY	ETF	83.56	83.56	83.53	83.53	3100.0
2009-01-22 07:00:00	SPY	ETF	83.72	83.72	83.66	83.7	59562.0
2009-01-22 07:05:00	SPY	ETF	83.7	83.82	83.7	83.77	354132.0
2009-01-22 07:10:00	SPY	ETF	83.82	83.82	83.68	83.71	139425.0
2009-01-22 07:15:00	SPY	ETF	83.73	83.74	83.67	83.67	16400.0
2009-01-22 07:20:00	SPY	ETF	83.69	83.71	83.68	83.68	6288.0
2009-01-22 07:25:00	SPY	ETF	83.68	83.85	83.68	83.78	14519.0
2009-01-22 07:30:00	SPY	ETF	83.8	83.86	83.76	83.79	26563.0
2009-01-22 07:35:00	SPY	ETF	83.79	83.86	83.78	83.85	13409.0
2009-01-22 07:40:00	SPY	ETF	83.83	83.83	83.73	83.73	88156.0
2009-01-22 07:45:00	SPY	ETF	83.75	83.87	83.72	83.85	65923.0
2009-01-22 07:50:00	SPY	ETF	83.76	83.85	83.75	83.8	10045.0
2009-01-22 07:55:00	SPY	ETF	83.8	83.8	83.7	83.72	26882.0
2009-01-22 08:00:00	SPY	ETF	83.72	84.07	83.55	83.75	552989.0
2009-01-22 08:05:00	SPY	ETF	83.72	83.72	83.62	83.63	49215.0
2009-01-22 08:10:00	SPY	ETF	83.63	84.01	83.55	83.64	187639.0
2009-01-22 08:15:00	SPY	ETF	83.64	83.69	83.53	83.57	83100.0
2009-01-22 08:20:00	SPY	ETF	83.56	83.58	83.48	83.49	95152.0
2009-01-22 08:25:00	SPY	ETF	83.48	83.7	83.48	83.63	168109.0
2009-01-22 08:30:00	SPY	ETF	83.6	83.6	83.25	83.3	612378.0
2009-01-22 08:35:00	SPY	ETF	83.31	83.6	83.28	83.44	379010.0
2009-01-22 08:40:00	SPY	ETF	83.45	83.45	83.3	83.39	142535.0
2009-01-22 08:45:00	SPY	ETF	83.4	83.44	83.01	83.04	939435.0
2009-01-22 08:50:00	SPY	ETF	83.04	83.25	82.98	83.07	1145094.0
2009-01-22 08:55:00	SPY	ETF	83.05	83.14	83.01	83.14	153814.0

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

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