PREVIEW / etf_30min / 2009-06-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-29.parquet
  size:    209 KB
  rows:    6,939

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-06-29 04:00:00	SPY	ETF	91.84	91.84	91.7	91.7	1110.0
2009-06-29 04:30:00	SPY	ETF	91.72	91.72	91.72	91.72	500.0
2009-06-29 05:00:00	SPY	ETF	91.75	91.75	91.75	91.75	200.0
2009-06-29 06:00:00	SPY	ETF	91.87	92.14	91.87	92.09	25250.0
2009-06-29 06:30:00	SPY	ETF	92.14	92.15	92.14	92.15	700.0
2009-06-29 07:00:00	SPY	ETF	92.15	92.19	92.05	92.19	829184.0
2009-06-29 07:30:00	SPY	ETF	92.19	92.25	92.09	92.22	517546.0
2009-06-29 08:00:00	SPY	ETF	92.22	92.32	92.07	92.24	1612815.0
2009-06-29 08:30:00	SPY	ETF	92.24	92.24	92.05	92.09	672589.0
2009-06-29 09:00:00	SPY	ETF	92.09	92.2	92.08	92.11	505368.0
2009-06-29 09:30:00	SPY	ETF	92.11	92.2	91.6	91.73	22648513.0
2009-06-29 10:00:00	SPY	ETF	91.73	92.49	91.66	92.48	17249648.0
2009-06-29 10:30:00	SPY	ETF	92.48	92.75	92.45	92.61	17268682.0
2009-06-29 11:00:00	SPY	ETF	92.6199	92.74	92.55	92.67	7277324.0
2009-06-29 11:30:00	SPY	ETF	92.66	92.77	92.55	92.74	7217462.0
2009-06-29 12:00:00	SPY	ETF	92.7395	92.77	92.63	92.73	4672550.0
2009-06-29 12:30:00	SPY	ETF	92.72	92.81	92.58	92.59	6242291.0
2009-06-29 13:00:00	SPY	ETF	92.59	92.78	92.58	92.66	4658682.0
2009-06-29 13:30:00	SPY	ETF	92.66	92.72	92.56	92.66	5265406.0
2009-06-29 14:00:00	SPY	ETF	92.6501	92.7	92.45	92.52	6238175.0
2009-06-29 14:30:00	SPY	ETF	92.52	92.67	92.49	92.64	13942782.0
2009-06-29 15:00:00	SPY	ETF	92.64	92.82	92.6	92.75	6310519.0
2009-06-29 15:30:00	SPY	ETF	92.75	92.77	92.42	92.72	26205455.0
2009-06-29 16:00:00	SPY	ETF	92.73	92.75	91.85	92.6	9353390.0
2009-06-29 16:30:00	SPY	ETF	92.6	92.63	92.56	92.56	451502.0
2009-06-29 17:00:00	SPY	ETF	92.57	92.61	92.56	92.58	28700.0
2009-06-29 17:30:00	SPY	ETF	92.57	92.63	92.57	92.62	64122.0
2009-06-29 18:00:00	SPY	ETF	92.6	92.68	92.52	92.54	52341.0
2009-06-29 18:30:00	SPY	ETF	92.53	92.6	92.53	92.55	8150.0
2009-06-29 19:00:00	SPY	ETF	92.58	92.63	92.58	92.62	19400.0
2009-06-29 19:30:00	SPY	ETF	92.6	92.62	92.52	92.59	37552.0
2009-06-29 05:00:00	QQQ	ETF	36.31	36.37	36.31	36.33	600.0
2009-06-29 06:00:00	QQQ	ETF	36.33	36.47	36.33	36.47	200.0
2009-06-29 06:30:00	QQQ	ETF	36.5	36.51	36.5	36.5	45700.0
2009-06-29 07:00:00	QQQ	ETF	36.5	36.53	36.47	36.51	457975.0
2009-06-29 07:30:00	QQQ	ETF	36.54	36.54	36.46	36.52	118446.0
2009-06-29 08:00:00	QQQ	ETF	36.5	36.55	36.49	36.51	755229.0
2009-06-29 08:30:00	QQQ	ETF	36.5	36.51	36.43	36.45	96592.0
2009-06-29 09:00:00	QQQ	ETF	36.46	36.49	36.44	36.45	342359.0
2009-06-29 09:30:00	QQQ	ETF	36.44	36.52	36.17	36.26	14421925.0
2009-06-29 10:00:00	QQQ	ETF	36.26	36.45	36.12	36.44	8870807.0
2009-06-29 10:30:00	QQQ	ETF	36.44	36.51	36.37	36.45	7519981.0
2009-06-29 11:00:00	QQQ	ETF	36.46	36.64	36.43	36.6085	6648183.0
2009-06-29 11:30:00	QQQ	ETF	36.6085	36.69	36.45	36.68	4801255.0
2009-06-29 12:00:00	QQQ	ETF	36.69	36.7	36.62	36.64	3689851.0
2009-06-29 12:30:00	QQQ	ETF	36.64	36.75	36.59	36.59	4742568.0
2009-06-29 13:00:00	QQQ	ETF	36.5905	36.64	36.55	36.57	2479794.0
2009-06-29 13:30:00	QQQ	ETF	36.57	36.61	36.47	36.52	4053844.0
2009-06-29 14:00:00	QQQ	ETF	36.52	36.53	36.44	36.49	3541157.0
2009-06-29 14:30:00	QQQ	ETF	36.49	36.55	36.44	36.54	5038507.0

> showing 50 of 6,939 rows — these rows as CSV

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