PREVIEW / etf_30min / 2009-04-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-27.parquet
  size:    215 KB
  rows:    7,130

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-04-27 04:00:00	SPY	ETF	85.52	85.62	85.52	85.62	1900.0
2009-04-27 04:30:00	SPY	ETF	85.54	85.69	85.54	85.69	200.0
2009-04-27 05:00:00	SPY	ETF	85.74	85.74	85.36	85.39	10330.0
2009-04-27 05:30:00	SPY	ETF	85.37	85.6	85.37	85.56	11500.0
2009-04-27 06:00:00	SPY	ETF	85.54	85.68	85.42	85.68	18000.0
2009-04-27 06:30:00	SPY	ETF	85.67	85.73	85.36	85.44	35649.0
2009-04-27 07:00:00	SPY	ETF	85.44	85.66	85.42	85.64	264786.0
2009-04-27 07:30:00	SPY	ETF	85.65	85.83	85.55	85.64	728942.0
2009-04-27 08:00:00	SPY	ETF	85.62	85.65	85.29	85.44	1995079.0
2009-04-27 08:30:00	SPY	ETF	85.43	85.56	85.36	85.55	1056521.0
2009-04-27 09:00:00	SPY	ETF	85.54	85.69	85.43	85.68	1571558.0
2009-04-27 09:30:00	SPY	ETF	85.68	86.3	85.56	86.1794	29389321.0
2009-04-27 10:00:00	SPY	ETF	86.18	86.52	85.65	86.38	39250162.0
2009-04-27 10:30:00	SPY	ETF	86.38	86.87	86.18	86.84	17540435.0
2009-04-27 11:00:00	SPY	ETF	86.84	86.98	86.55	86.8	15927775.0
2009-04-27 11:30:00	SPY	ETF	86.7902	86.92	86.63	86.84	9978590.0
2009-04-27 12:00:00	SPY	ETF	86.85	87.01	86.56	86.66	12636659.0
2009-04-27 12:30:00	SPY	ETF	86.6601	86.68	86.25	86.4	13417059.0
2009-04-27 13:00:00	SPY	ETF	86.4	86.43	85.9	85.92	12899049.0
2009-04-27 13:30:00	SPY	ETF	85.92	86.02	85.54	85.74	18694013.0
2009-04-27 14:00:00	SPY	ETF	85.74	85.84	85.54	85.78	18350917.0
2009-04-27 14:30:00	SPY	ETF	85.78	86.08	85.78	85.96	13029280.0
2009-04-27 15:00:00	SPY	ETF	85.96	86.18	85.58	85.8	20598250.0
2009-04-27 15:30:00	SPY	ETF	85.79	86.37	85.63	85.85	40772346.0
2009-04-27 16:00:00	SPY	ETF	85.86	86.4501	85.73	86.0	17545485.0
2009-04-27 16:30:00	SPY	ETF	86.0	86.05	85.56	85.73	734779.0
2009-04-27 17:00:00	SPY	ETF	85.71	85.75	85.64	85.7	206433.0
2009-04-27 17:30:00	SPY	ETF	85.73	85.81	85.65	85.8	1102101.0
2009-04-27 18:00:00	SPY	ETF	85.77	85.77	85.7	85.71	97355.0
2009-04-27 18:30:00	SPY	ETF	85.73	85.73	85.63	85.68	44055.0
2009-04-27 19:00:00	SPY	ETF	85.67	85.74	85.67	85.72	9779.0
2009-04-27 19:30:00	SPY	ETF	85.71	85.76	85.65	85.68	32933.0
2009-04-27 04:00:00	QQQ	ETF	33.32	33.32	33.32	33.32	475.0
2009-04-27 05:00:00	QQQ	ETF	33.37	33.37	33.37	33.37	911.0
2009-04-27 05:30:00	QQQ	ETF	33.32	33.37	33.29	33.37	900.0
2009-04-27 06:00:00	QQQ	ETF	33.34	33.34	33.34	33.34	256.0
2009-04-27 06:30:00	QQQ	ETF	33.39	33.4	33.31	33.36	233513.0
2009-04-27 07:00:00	QQQ	ETF	33.37	33.38	33.32	33.38	73818.0
2009-04-27 07:30:00	QQQ	ETF	33.38	33.44	33.35	33.4	46526.0
2009-04-27 08:00:00	QQQ	ETF	33.39	33.41	33.32	33.32	262903.0
2009-04-27 08:30:00	QQQ	ETF	33.32	33.37	33.3	33.36	319045.0
2009-04-27 09:00:00	QQQ	ETF	33.37	33.44	33.34	33.42	454803.0
2009-04-27 09:30:00	QQQ	ETF	33.42	33.83	33.35	33.74	17248806.0
2009-04-27 10:00:00	QQQ	ETF	33.75	33.94	33.58	33.84	18006608.0
2009-04-27 10:30:00	QQQ	ETF	33.83	34.04	33.75	34.01	8054370.0
2009-04-27 11:00:00	QQQ	ETF	34.01	34.06	33.9	33.99	5880718.0
2009-04-27 11:30:00	QQQ	ETF	34.0	34.03	33.91	33.97	3668198.0
2009-04-27 12:00:00	QQQ	ETF	33.98	34.05	33.91	33.95	3454122.0
2009-04-27 12:30:00	QQQ	ETF	33.95	33.96	33.8	33.84	4969167.0
2009-04-27 13:00:00	QQQ	ETF	33.8302	33.845	33.68	33.68	4575426.0

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

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