PREVIEW / etf_30min / 2009-01-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-23.parquet
  size:    206 KB
  rows:    6,729

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-01-23 04:00:00	SPY	ETF	81.61	81.61	81.27	81.27	4506.0
2009-01-23 04:30:00	SPY	ETF	81.07	81.2	80.67	80.67	8925.0
2009-01-23 05:00:00	SPY	ETF	80.75	80.94	80.68	80.9	1300.0
2009-01-23 05:30:00	SPY	ETF	80.84	81.12	80.84	81.05	4510.0
2009-01-23 06:00:00	SPY	ETF	80.95	81.33	80.89	81.28	15256.0
2009-01-23 06:30:00	SPY	ETF	81.25	81.54	81.18	81.25	450250.0
2009-01-23 07:00:00	SPY	ETF	81.26	81.61	81.23	81.53	411578.0
2009-01-23 07:30:00	SPY	ETF	81.55	81.64	81.13	81.15	796929.0
2009-01-23 08:00:00	SPY	ETF	81.15	81.4	80.63	80.63	2149561.0
2009-01-23 08:30:00	SPY	ETF	80.63	80.85	80.4	80.41	3966268.0
2009-01-23 09:00:00	SPY	ETF	80.41	80.93	80.4	80.89	3721512.0
2009-01-23 09:30:00	SPY	ETF	80.9	81.74	80.57	81.4499	39229440.0
2009-01-23 10:00:00	SPY	ETF	81.45	82.15	81.4	81.97	29296910.0
2009-01-23 10:30:00	SPY	ETF	81.96	81.98	81.23	81.54	18842248.0
2009-01-23 11:00:00	SPY	ETF	81.54	82.91	81.53	82.49	31366230.0
2009-01-23 11:30:00	SPY	ETF	82.5	82.72	81.81	81.98	22945984.0
2009-01-23 12:00:00	SPY	ETF	81.98	82.86	81.91	82.72	25636279.0
2009-01-23 12:30:00	SPY	ETF	82.72	82.89	82.05	82.44	26144669.0
2009-01-23 13:00:00	SPY	ETF	82.44	83.49	82.23	83.1	28249320.0
2009-01-23 13:30:00	SPY	ETF	83.1	83.83	83.06	83.82	24182217.0
2009-01-23 14:00:00	SPY	ETF	83.81	83.99	83.12	83.57	22984249.0
2009-01-23 14:30:00	SPY	ETF	83.57	83.67	82.55	82.75	30838811.0
2009-01-23 15:00:00	SPY	ETF	82.75	83.32	82.5	82.88	28430570.0
2009-01-23 15:30:00	SPY	ETF	82.87	83.54	82.68	83.11	31879709.0
2009-01-23 16:00:00	SPY	ETF	83.1	83.224	81.45	82.82	10907451.0
2009-01-23 16:30:00	SPY	ETF	82.82	82.86	82.79	82.86	3849454.0
2009-01-23 17:00:00	SPY	ETF	82.85	82.88	82.75	82.77	48206.0
2009-01-23 17:30:00	SPY	ETF	82.77	82.89	82.71	82.8	48871.0
2009-01-23 18:00:00	SPY	ETF	82.82	82.89	82.78	82.84	12500.0
2009-01-23 18:30:00	SPY	ETF	82.84	82.9	82.81	82.85	17175.0
2009-01-23 19:00:00	SPY	ETF	82.83	82.87	82.72	82.74	11638.0
2009-01-23 19:30:00	SPY	ETF	82.83	82.83	82.72	82.81	6434.0
2009-01-23 04:00:00	QQQ	ETF	28.46	28.46	28.32	28.32	1745.0
2009-01-23 04:30:00	QQQ	ETF	28.31	28.33	28.17	28.19	3959.0
2009-01-23 05:00:00	QQQ	ETF	28.21	28.24	28.21	28.24	1150.0
2009-01-23 05:30:00	QQQ	ETF	28.27	28.31	28.27	28.31	6630.0
2009-01-23 06:00:00	QQQ	ETF	28.31	28.44	28.25	28.33	13667.0
2009-01-23 06:30:00	QQQ	ETF	28.36	28.47	28.36	28.39	54700.0
2009-01-23 07:00:00	QQQ	ETF	28.38	28.47	28.36	28.41	17572.0
2009-01-23 07:30:00	QQQ	ETF	28.41	28.41	28.31	28.34	73178.0
2009-01-23 08:00:00	QQQ	ETF	28.34	28.4	28.2	28.22	446600.0
2009-01-23 08:30:00	QQQ	ETF	28.22	28.31	28.17	28.18	502538.0
2009-01-23 09:00:00	QQQ	ETF	28.19	28.33	28.19	28.32	598991.0
2009-01-23 09:30:00	QQQ	ETF	28.32	28.56	28.14	28.46	21076460.0
2009-01-23 10:00:00	QQQ	ETF	28.46	28.69	28.41	28.63	12994407.0
2009-01-23 10:30:00	QQQ	ETF	28.63	28.64	28.39	28.441	7842398.0
2009-01-23 11:00:00	QQQ	ETF	28.45	28.93	28.45	28.81	12888178.0
2009-01-23 11:30:00	QQQ	ETF	28.82	28.9	28.61	28.68	8269879.0
2009-01-23 12:00:00	QQQ	ETF	28.67	28.94	28.65	28.8999	7748001.0
2009-01-23 12:30:00	QQQ	ETF	28.9	28.98	28.68	28.83	10580703.0

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

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