PREVIEW / etf_30min / 2000-03-09

all etf 30-min files

  file:    by_date/etf_30min/2000/2000-03-09.parquet
  size:    10 KB
  rows:    215

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-09 09:30:00	SPY	ETF	137.25	137.25	136.125	136.3125	1164300.0
2000-03-09 10:00:00	SPY	ETF	136.1562	137.3125	136.1562	137.1875	282900.0
2000-03-09 10:30:00	SPY	ETF	137.125	138.375	137.0	138.2188	396500.0
2000-03-09 11:00:00	SPY	ETF	138.1562	138.25	137.6875	138.125	371800.0
2000-03-09 11:30:00	SPY	ETF	138.0938	138.5	137.8125	138.0	182100.0
2000-03-09 12:00:00	SPY	ETF	138.0625	138.8438	137.8125	138.5	575000.0
2000-03-09 12:30:00	SPY	ETF	138.375	138.8125	138.3125	138.4375	383200.0
2000-03-09 13:00:00	SPY	ETF	138.5312	138.625	138.1562	138.4688	352600.0
2000-03-09 13:30:00	SPY	ETF	138.5938	138.8438	138.1875	138.5	123200.0
2000-03-09 14:00:00	SPY	ETF	138.6562	138.8125	138.3438	138.75	84500.0
2000-03-09 14:30:00	SPY	ETF	138.7812	139.0	138.5312	138.6875	166500.0
2000-03-09 15:00:00	SPY	ETF	138.6875	139.9375	138.625	139.75	555500.0
2000-03-09 15:30:00	SPY	ETF	139.75	140.5938	139.6562	140.5938	337500.0
2000-03-09 16:00:00	SPY	ETF	140.625	140.875	140.5	140.875	481100.0
2000-03-09 09:30:00	QQQ	ETF	111.2188	111.6875	109.0938	109.5938	3335800.0
2000-03-09 10:00:00	QQQ	ETF	109.5	110.7812	109.25	110.75	4110400.0
2000-03-09 10:30:00	QQQ	ETF	110.75	111.9375	110.5781	111.9062	2615200.0
2000-03-09 11:00:00	QQQ	ETF	111.75	111.9375	111.125	111.4062	1264200.0
2000-03-09 11:30:00	QQQ	ETF	111.4062	111.9688	110.9062	111.2188	1564000.0
2000-03-09 12:00:00	QQQ	ETF	111.25	112.3438	111.2188	111.9375	2892600.0
2000-03-09 12:30:00	QQQ	ETF	111.9375	112.75	111.875	112.4375	2172200.0
2000-03-09 13:00:00	QQQ	ETF	112.5156	112.625	112.0	112.125	637600.0
2000-03-09 13:30:00	QQQ	ETF	112.25	112.7344	111.75	112.5938	2684400.0
2000-03-09 14:00:00	QQQ	ETF	112.5	112.5781	111.6875	112.4375	1206400.0
2000-03-09 14:30:00	QQQ	ETF	112.4062	112.8594	112.3906	112.7344	2089600.0
2000-03-09 15:00:00	QQQ	ETF	112.7188	113.875	112.6406	113.5	2374200.0
2000-03-09 15:30:00	QQQ	ETF	113.5	114.6875	113.3125	114.6875	2492800.0
2000-03-09 16:00:00	QQQ	ETF	114.3125	114.9375	114.3125	114.75	622400.0
2000-03-09 16:30:00	QQQ	ETF	115.0	115.0	115.0	115.0	1600.0
2000-03-09 17:00:00	QQQ	ETF	115.0	115.0	115.0	115.0	600.0
2000-03-09 17:30:00	QQQ	ETF	114.5	114.75	114.5	114.75	3000.0
2000-03-09 18:00:00	QQQ	ETF	115.0	115.0	115.0	115.0	600.0
2000-03-09 09:30:00	DIA	ETF	98.8438	98.8438	97.3125	97.5625	173100.0
2000-03-09 10:00:00	DIA	ETF	97.5625	98.3438	97.4375	98.25	194900.0
2000-03-09 10:30:00	DIA	ETF	98.25	99.0	98.2188	98.5312	77700.0
2000-03-09 11:00:00	DIA	ETF	98.5312	98.6875	98.2188	98.4375	92500.0
2000-03-09 11:30:00	DIA	ETF	98.5625	98.7188	98.25	98.4375	75600.0
2000-03-09 12:00:00	DIA	ETF	98.4375	98.9688	98.2812	98.5625	128400.0
2000-03-09 12:30:00	DIA	ETF	98.6875	98.8438	98.4375	98.625	106400.0
2000-03-09 13:00:00	DIA	ETF	98.625	98.7188	98.25	98.5938	58900.0
2000-03-09 13:30:00	DIA	ETF	98.5938	98.8438	98.3125	98.7188	11500.0
2000-03-09 14:00:00	DIA	ETF	98.7188	98.9688	98.625	98.9062	87400.0
2000-03-09 14:30:00	DIA	ETF	98.9688	99.1562	98.7812	98.9375	135900.0
2000-03-09 15:00:00	DIA	ETF	99.0938	99.875	98.9375	99.625	182100.0
2000-03-09 15:30:00	DIA	ETF	99.6875	100.1875	99.6875	100.0625	255900.0
2000-03-09 16:00:00	DIA	ETF	100.25	100.4375	100.1562	100.3125	133900.0

> showing 46 of 215 rows — these rows as CSV

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