PREVIEW / etf_30min / 2000-03-07

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-07.parquet
  size:    10 KB
  rows:    232

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
2000-03-07 09:30:00	SPY	ETF	140.0	140.1562	138.6562	138.75	1735100.0
2000-03-07 10:00:00	SPY	ETF	138.625	138.875	136.875	137.8438	1997800.0
2000-03-07 10:30:00	SPY	ETF	137.9688	138.5625	137.8125	137.875	792800.0
2000-03-07 11:00:00	SPY	ETF	137.7812	138.8125	137.7812	138.5	1924500.0
2000-03-07 11:30:00	SPY	ETF	138.625	139.1562	138.5	138.75	1236800.0
2000-03-07 12:00:00	SPY	ETF	138.75	139.0	137.875	138.0625	2900700.0
2000-03-07 12:30:00	SPY	ETF	138.1875	138.4062	137.7812	138.0	182600.0
2000-03-07 13:00:00	SPY	ETF	137.9062	138.125	137.4375	137.4375	929400.0
2000-03-07 13:30:00	SPY	ETF	137.375	137.875	136.875	136.9062	1416100.0
2000-03-07 14:00:00	SPY	ETF	137.125	138.0312	136.75	138.0	1328700.0
2000-03-07 14:30:00	SPY	ETF	138.0	138.0625	137.0938	137.5312	437400.0
2000-03-07 15:00:00	SPY	ETF	137.6562	137.7812	136.3125	136.3125	709200.0
2000-03-07 15:30:00	SPY	ETF	136.5312	136.5625	135.2188	136.0312	1731300.0
2000-03-07 16:00:00	SPY	ETF	135.9375	136.6875	135.3125	136.6875	1709400.0
2000-03-07 16:30:00	SPY	ETF	137.0625	137.0625	137.0312	137.0312	850000.0
2000-03-07 09:30:00	QQQ	ETF	113.8125	113.875	112.5	112.5312	3800200.0
2000-03-07 10:00:00	QQQ	ETF	112.5312	112.6875	110.0	111.1719	5246600.0
2000-03-07 10:30:00	QQQ	ETF	111.1719	112.25	111.0625	111.3125	4133400.0
2000-03-07 11:00:00	QQQ	ETF	111.4062	112.875	111.25	112.75	1777400.0
2000-03-07 11:30:00	QQQ	ETF	112.75	113.3125	112.6406	113.1562	1734200.0
2000-03-07 12:00:00	QQQ	ETF	113.125	113.375	112.1875	112.4375	1471600.0
2000-03-07 12:30:00	QQQ	ETF	112.3125	112.875	112.125	112.6562	1411200.0
2000-03-07 13:00:00	QQQ	ETF	112.625	112.8125	111.8125	111.8125	831800.0
2000-03-07 13:30:00	QQQ	ETF	111.8125	112.1562	110.625	110.75	3745800.0
2000-03-07 14:00:00	QQQ	ETF	110.9375	111.875	110.4375	111.875	4577200.0
2000-03-07 14:30:00	QQQ	ETF	111.875	111.9375	110.9531	111.625	2148200.0
2000-03-07 15:00:00	QQQ	ETF	111.625	111.9375	110.125	110.5	3131800.0
2000-03-07 15:30:00	QQQ	ETF	110.375	110.5	108.75	109.75	4539200.0
2000-03-07 16:00:00	QQQ	ETF	109.625	109.8125	109.3125	109.4375	839200.0
2000-03-07 16:30:00	QQQ	ETF	109.5	109.5	109.5	109.5	800.0
2000-03-07 17:00:00	QQQ	ETF	109.4375	110.0	109.4375	110.0	4800.0
2000-03-07 17:30:00	QQQ	ETF	110.0	110.0	110.0	110.0	200.0
2000-03-07 18:00:00	QQQ	ETF	110.0	110.25	110.0	110.25	1000.0
2000-03-07 09:30:00	DIA	ETF	101.4688	101.5312	99.6875	99.75	194400.0
2000-03-07 10:00:00	DIA	ETF	99.6875	99.9688	98.2812	99.375	405800.0
2000-03-07 10:30:00	DIA	ETF	99.3438	99.75	99.1875	99.4375	281400.0
2000-03-07 11:00:00	DIA	ETF	99.4375	99.75	99.375	99.5625	111800.0
2000-03-07 11:30:00	DIA	ETF	99.5938	100.0	99.4062	99.6562	115400.0
2000-03-07 12:00:00	DIA	ETF	99.6562	99.75	99.125	99.3125	57200.0
2000-03-07 12:30:00	DIA	ETF	99.3125	99.4062	99.125	99.1875	69900.0
2000-03-07 13:00:00	DIA	ETF	99.1562	99.2188	98.5625	98.5625	179200.0
2000-03-07 13:30:00	DIA	ETF	98.6875	99.125	98.375	98.5938	464400.0
2000-03-07 14:00:00	DIA	ETF	98.5625	99.375	98.4062	99.1875	156500.0
2000-03-07 14:30:00	DIA	ETF	99.2812	99.3125	98.875	99.125	282200.0
2000-03-07 15:00:00	DIA	ETF	99.1562	99.1875	98.1875	98.3125	352200.0
2000-03-07 15:30:00	DIA	ETF	98.4062	98.5625	97.5312	98.0312	1002100.0
2000-03-07 16:00:00	DIA	ETF	98.0938	98.0938	97.5625	97.5625	55400.0
2000-03-07 16:30:00	DIA	ETF	98.0	98.0	98.0	98.0	500.0
2000-03-07 17:00:00	DIA	ETF	98.0	98.0	98.0	98.0	100.0
2000-03-07 17:30:00	DIA	ETF	98.0	98.0	98.0	98.0	100.0

> showing 50 of 232 rows — these rows as CSV

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