PREVIEW / etf_30min / 2009-06-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-10.parquet
  size:    225 KB
  rows:    7,438

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-10 04:00:00	SPY	ETF	95.42	95.49	95.38	95.49	3133.0
2009-06-10 04:30:00	SPY	ETF	95.5	95.55	95.5	95.55	5450.0
2009-06-10 05:00:00	SPY	ETF	95.58	95.67	95.58	95.66	3025.0
2009-06-10 05:30:00	SPY	ETF	95.6	95.65	95.51	95.51	1950.0
2009-06-10 06:00:00	SPY	ETF	95.72	95.87	95.7	95.78	22120.0
2009-06-10 06:30:00	SPY	ETF	95.78	95.81	95.71	95.76	25042.0
2009-06-10 07:00:00	SPY	ETF	95.72	95.94	95.68	95.75	506082.0
2009-06-10 07:30:00	SPY	ETF	95.75	95.75	95.55	95.57	788319.0
2009-06-10 08:00:00	SPY	ETF	95.56	95.8	94.85	95.58	767163.0
2009-06-10 08:30:00	SPY	ETF	95.58	95.61	94.63	95.36	848815.0
2009-06-10 09:00:00	SPY	ETF	95.35	95.815	95.35	95.48	1767158.0
2009-06-10 09:30:00	SPY	ETF	95.48	95.49	94.89	95.13	26994247.0
2009-06-10 10:00:00	SPY	ETF	95.13	95.15	94.42	94.69	22916910.0
2009-06-10 10:30:00	SPY	ETF	94.7	94.76	94.27	94.45	23581906.0
2009-06-10 11:00:00	SPY	ETF	94.45	94.4501	94.07	94.37	17307259.0
2009-06-10 11:30:00	SPY	ETF	94.38	94.44	94.27	94.32	7866169.0
2009-06-10 12:00:00	SPY	ETF	94.32	94.56	94.26	94.37	17762616.0
2009-06-10 12:30:00	SPY	ETF	94.37	94.37	94.16	94.26	8313597.0
2009-06-10 13:00:00	SPY	ETF	94.26	94.3	93.68	93.75	25414122.0
2009-06-10 13:30:00	SPY	ETF	93.74	93.75	93.26	93.48	21188507.0
2009-06-10 14:00:00	SPY	ETF	93.48	93.71	93.19	93.59	21880471.0
2009-06-10 14:30:00	SPY	ETF	93.59	94.24	93.46	93.9	21597223.0
2009-06-10 15:00:00	SPY	ETF	93.9	93.93	93.55	93.68	22006529.0
2009-06-10 15:30:00	SPY	ETF	93.68	94.4	93.4	94.355	34961059.0
2009-06-10 16:00:00	SPY	ETF	94.36	94.6799	93.9452	94.46	15924012.0
2009-06-10 16:30:00	SPY	ETF	94.46	94.52	94.45	94.49	1016459.0
2009-06-10 17:00:00	SPY	ETF	94.49	94.6	94.46	94.5	223602.0
2009-06-10 17:30:00	SPY	ETF	94.49	94.62	94.49	94.58	240895.0
2009-06-10 18:00:00	SPY	ETF	94.57	94.62	94.34	94.6	137729.0
2009-06-10 18:30:00	SPY	ETF	94.62	94.64	94.59	94.6	121053.0
2009-06-10 19:00:00	SPY	ETF	94.6	94.62	94.57	94.6	30008.0
2009-06-10 19:30:00	SPY	ETF	94.6	94.64	94.56	94.6	123089.0
2009-06-10 04:00:00	QQQ	ETF	37.3	37.3	37.3	37.3	841.0
2009-06-10 04:30:00	QQQ	ETF	37.36	37.36	37.27	37.27	300.0
2009-06-10 05:00:00	QQQ	ETF	37.35	37.35	37.35	37.35	100.0
2009-06-10 05:30:00	QQQ	ETF	37.31	37.31	37.26	37.26	200.0
2009-06-10 06:00:00	QQQ	ETF	37.36	37.36	37.32	37.32	928.0
2009-06-10 06:30:00	QQQ	ETF	37.34	37.35	37.32	37.32	9025.0
2009-06-10 07:00:00	QQQ	ETF	37.32	37.37	37.29	37.31	121624.0
2009-06-10 07:30:00	QQQ	ETF	37.31	37.31	37.25	37.26	453078.0
2009-06-10 08:00:00	QQQ	ETF	37.25	37.29	37.25	37.26	415631.0
2009-06-10 08:30:00	QQQ	ETF	37.26	37.26	37.17	37.18	269683.0
2009-06-10 09:00:00	QQQ	ETF	37.18	37.24	37.16	37.18	563486.0
2009-06-10 09:30:00	QQQ	ETF	37.17	37.17	36.8	36.9	16491264.0
2009-06-10 10:00:00	QQQ	ETF	36.91	36.93	36.61	36.71	10979914.0
2009-06-10 10:30:00	QQQ	ETF	36.71	36.76	36.56	36.59	9546453.0
2009-06-10 11:00:00	QQQ	ETF	36.59	36.6	36.42	36.49	10937768.0
2009-06-10 11:30:00	QQQ	ETF	36.49	36.59	36.48	36.52	5627834.0
2009-06-10 12:00:00	QQQ	ETF	36.52	36.73	36.5	36.66	7977618.0
2009-06-10 12:30:00	QQQ	ETF	36.66	36.67	36.57	36.63	3752299.0

> showing 50 of 7,438 rows — these rows as CSV

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