PREVIEW / etf_5min / 2007-10-01

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-01.parquet
  size:    378 KB
  rows:    18,888

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
2007-10-01 05:30:00	SPY	ETF	152.75	152.75	152.75	152.75	30000.0
2007-10-01 05:35:00	SPY	ETF	152.72	152.72	152.67	152.67	16000.0
2007-10-01 05:45:00	SPY	ETF	152.68	152.68	152.68	152.68	1000.0
2007-10-01 06:00:00	SPY	ETF	152.71	152.71	152.71	152.71	2000.0
2007-10-01 06:20:00	SPY	ETF	152.85	152.85	152.85	152.85	10000.0
2007-10-01 06:45:00	SPY	ETF	152.88	152.88	152.88	152.88	3000.0
2007-10-01 06:55:00	SPY	ETF	152.95	152.97	152.95	152.97	75000.0
2007-10-01 07:00:00	SPY	ETF	152.91	152.91	152.51	152.55	637500.0
2007-10-01 07:05:00	SPY	ETF	152.62	152.65	152.6	152.62	113400.0
2007-10-01 07:10:00	SPY	ETF	152.6	152.6	152.55	152.57	30000.0
2007-10-01 07:15:00	SPY	ETF	152.55	152.58	152.4	152.4	124700.0
2007-10-01 07:20:00	SPY	ETF	152.41	152.46	152.38	152.43	122000.0
2007-10-01 07:25:00	SPY	ETF	152.43	152.48	152.41	152.48	13700.0
2007-10-01 07:30:00	SPY	ETF	152.52	152.56	152.48	152.48	46000.0
2007-10-01 07:35:00	SPY	ETF	152.48	152.51	152.4	152.41	53300.0
2007-10-01 07:40:00	SPY	ETF	152.43	152.52	152.43	152.51	40200.0
2007-10-01 07:45:00	SPY	ETF	152.51	152.51	152.43	152.49	15800.0
2007-10-01 07:50:00	SPY	ETF	152.51	152.52	152.46	152.52	16200.0
2007-10-01 07:55:00	SPY	ETF	152.49	152.51	152.44	152.5	19900.0
2007-10-01 08:00:00	SPY	ETF	152.47	152.55	152.47	152.53	41900.0
2007-10-01 08:05:00	SPY	ETF	152.53	152.53	152.48	152.48	141600.0
2007-10-01 08:10:00	SPY	ETF	152.45	152.47	152.4	152.46	147900.0
2007-10-01 08:15:00	SPY	ETF	152.45	152.58	152.45	152.56	145500.0
2007-10-01 08:20:00	SPY	ETF	152.57	152.6	152.55	152.57	166400.0
2007-10-01 08:25:00	SPY	ETF	152.57	152.59	152.54	152.55	173500.0
2007-10-01 08:30:00	SPY	ETF	152.6	152.68	152.6	152.66	79900.0
2007-10-01 08:35:00	SPY	ETF	152.65	152.65	152.29	152.63	64900.0
2007-10-01 08:40:00	SPY	ETF	152.62	152.63	152.56	152.59	44500.0
2007-10-01 08:45:00	SPY	ETF	152.58	152.63	152.58	152.63	27900.0
2007-10-01 08:50:00	SPY	ETF	152.65	152.66	152.59	152.63	89200.0
2007-10-01 08:55:00	SPY	ETF	152.64	152.65	152.63	152.64	16800.0
2007-10-01 09:00:00	SPY	ETF	152.64	152.67	152.61	152.61	30300.0
2007-10-01 09:05:00	SPY	ETF	152.6	152.66	152.6	152.65	42400.0
2007-10-01 09:10:00	SPY	ETF	152.65	152.71	152.63	152.64	93900.0
2007-10-01 09:15:00	SPY	ETF	152.65	152.66	152.6	152.62	66300.0
2007-10-01 09:20:00	SPY	ETF	152.63	152.64	152.59	152.6	112800.0
2007-10-01 09:25:00	SPY	ETF	152.6	152.62	152.58	152.61	59800.0
2007-10-01 09:30:00	SPY	ETF	152.6	152.78	152.5	152.77	2772600.0
2007-10-01 09:35:00	SPY	ETF	152.77	153.09	152.75	153.04	5860780.0
2007-10-01 09:40:00	SPY	ETF	153.04	153.1	152.94	153.08	2087500.0
2007-10-01 09:45:00	SPY	ETF	153.09	153.35	153.08	153.33	4893600.0
2007-10-01 09:50:00	SPY	ETF	153.33	153.331	153.17	153.21	1726900.0
2007-10-01 09:55:00	SPY	ETF	153.2	153.28	153.14	153.16	1510100.0
2007-10-01 10:00:00	SPY	ETF	153.16	153.47	153.12	153.31	3918900.0
2007-10-01 10:05:00	SPY	ETF	153.31	153.62	153.3	153.61	4861100.0
2007-10-01 10:10:00	SPY	ETF	153.6	153.64	153.47	153.53	2924100.0
2007-10-01 10:15:00	SPY	ETF	153.54	153.55	153.42	153.42	1592000.0
2007-10-01 10:20:00	SPY	ETF	153.42	153.56	153.42	153.54	1243100.0
2007-10-01 10:25:00	SPY	ETF	153.55	153.55	153.4	153.4	1534600.0
2007-10-01 10:30:00	SPY	ETF	153.4	153.46	153.33	153.43	2775800.0

> showing 50 of 18,888 rows — these rows as CSV

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