PREVIEW / etf_5min / 2008-01-23

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-01-23.parquet
  size:    553 KB
  rows:    25,793

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
2008-01-23 04:05:00	SPY	ETF	130.04	130.04	130.04	130.04	1000.0
2008-01-23 04:10:00	SPY	ETF	130.04	130.22	130.04	130.22	2000.0
2008-01-23 04:20:00	SPY	ETF	130.11	130.11	130.11	130.11	2000.0
2008-01-23 04:35:00	SPY	ETF	129.7	129.7	129.34	129.63	4000.0
2008-01-23 04:40:00	SPY	ETF	129.71	129.71	129.71	129.71	1000.0
2008-01-23 04:50:00	SPY	ETF	129.71	129.71	129.71	129.71	100.0
2008-01-23 05:20:00	SPY	ETF	129.71	129.71	129.52	129.54	4700.0
2008-01-23 05:25:00	SPY	ETF	129.64	129.77	129.64	129.65	2300.0
2008-01-23 05:30:00	SPY	ETF	129.6	129.6	129.6	129.6	500.0
2008-01-23 05:45:00	SPY	ETF	129.52	129.52	129.52	129.52	100.0
2008-01-23 05:50:00	SPY	ETF	129.32	129.32	129.12	129.12	3200.0
2008-01-23 05:55:00	SPY	ETF	129.01	129.3	129.0	129.27	6600.0
2008-01-23 06:00:00	SPY	ETF	129.37	129.37	129.37	129.37	12500.0
2008-01-23 06:05:00	SPY	ETF	129.45	129.45	129.45	129.45	500.0
2008-01-23 06:10:00	SPY	ETF	129.37	129.37	129.3	129.3	2400.0
2008-01-23 06:15:00	SPY	ETF	129.27	129.27	128.62	128.62	66200.0
2008-01-23 06:20:00	SPY	ETF	128.52	128.55	128.2	128.46	196700.0
2008-01-23 06:25:00	SPY	ETF	128.39	128.43	128.32	128.35	330300.0
2008-01-23 06:30:00	SPY	ETF	128.34	128.85	128.32	128.85	37800.0
2008-01-23 06:40:00	SPY	ETF	128.52	128.68	128.42	128.42	26400.0
2008-01-23 06:45:00	SPY	ETF	128.42	128.42	128.4	128.4	48300.0
2008-01-23 06:50:00	SPY	ETF	128.4	128.55	128.32	128.55	126900.0
2008-01-23 07:00:00	SPY	ETF	128.8	128.92	128.7	128.73	161100.0
2008-01-23 07:05:00	SPY	ETF	128.74	128.91	128.67	128.9	170000.0
2008-01-23 07:10:00	SPY	ETF	128.9	129.12	128.85	129.04	203200.0
2008-01-23 07:15:00	SPY	ETF	128.98	129.3	128.92	129.3	250900.0
2008-01-23 07:20:00	SPY	ETF	129.35	129.47	129.12	129.22	38500.0
2008-01-23 07:25:00	SPY	ETF	129.2	129.2	129.0	129.15	101300.0
2008-01-23 07:30:00	SPY	ETF	129.15	129.31	129.12	129.12	181200.0
2008-01-23 07:35:00	SPY	ETF	129.12	129.12	128.96	129.02	52900.0
2008-01-23 07:40:00	SPY	ETF	129.02	129.04	128.74	128.74	165600.0
2008-01-23 07:45:00	SPY	ETF	128.72	128.76	128.28	128.29	217300.0
2008-01-23 07:50:00	SPY	ETF	128.28	128.68	128.25	128.68	344700.0
2008-01-23 07:55:00	SPY	ETF	128.67	128.75	128.3	128.35	212500.0
2008-01-23 08:00:00	SPY	ETF	128.98	130.92	128.38	128.75	1261500.0
2008-01-23 08:05:00	SPY	ETF	128.75	128.76	128.26	128.35	662000.0
2008-01-23 08:10:00	SPY	ETF	128.31	128.42	127.68	127.82	1557600.0
2008-01-23 08:15:00	SPY	ETF	127.82	127.83	127.09	127.12	1770200.0
2008-01-23 08:20:00	SPY	ETF	127.14	127.55	127.03	127.52	5170600.0
2008-01-23 08:25:00	SPY	ETF	127.52	127.74	127.23	127.53	2379500.0
2008-01-23 08:30:00	SPY	ETF	127.37	127.67	126.7	126.86	2553200.0
2008-01-23 08:35:00	SPY	ETF	126.86	127.03	126.02	127.02	4902200.0
2008-01-23 08:40:00	SPY	ETF	127.0	127.44	126.9	127.12	1638700.0
2008-01-23 08:45:00	SPY	ETF	127.11	128.33	126.95	126.95	989350.0
2008-01-23 08:50:00	SPY	ETF	126.95	127.53	126.95	127.31	733100.0
2008-01-23 08:55:00	SPY	ETF	127.31	127.54	127.08	127.11	843800.0
2008-01-23 09:00:00	SPY	ETF	127.08	127.5	127.04	127.45	571500.0
2008-01-23 09:05:00	SPY	ETF	127.44	127.8	127.31	127.55	937300.0
2008-01-23 09:10:00	SPY	ETF	127.57	127.63	126.94	126.96	1326890.0
2008-01-23 09:15:00	SPY	ETF	126.96	127.43	126.96	127.41	890000.0

> showing 50 of 25,793 rows — these rows as CSV

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