PREVIEW / etf_30min / 2009-02-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-03.parquet
  size:    203 KB
  rows:    6,641

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-02-03 04:00:00	SPY	ETF	82.9	82.9	82.65	82.67	1400.0
2009-02-03 04:30:00	SPY	ETF	82.57	82.62	82.57	82.62	200.0
2009-02-03 05:00:00	SPY	ETF	82.17	82.17	82.17	82.17	106.0
2009-02-03 05:30:00	SPY	ETF	82.25	82.25	82.11	82.11	10400.0
2009-02-03 06:00:00	SPY	ETF	82.21	82.59	82.21	82.59	17400.0
2009-02-03 06:30:00	SPY	ETF	82.24	82.35	82.24	82.35	9800.0
2009-02-03 07:00:00	SPY	ETF	82.35	82.79	82.28	82.7	272571.0
2009-02-03 07:30:00	SPY	ETF	82.79	82.98	82.48	82.72	577928.0
2009-02-03 08:00:00	SPY	ETF	82.07	83.2	82.07	82.49	1462483.0
2009-02-03 08:30:00	SPY	ETF	82.5	82.85	82.46	82.78	756593.0
2009-02-03 09:00:00	SPY	ETF	82.78	83.19	82.78	83.11	2496464.0
2009-02-03 09:30:00	SPY	ETF	83.1	83.24	82.22	82.48	29284713.0
2009-02-03 10:00:00	SPY	ETF	82.47	83.0	82.3	82.59	28860331.0
2009-02-03 10:30:00	SPY	ETF	82.59	83.18	82.48	82.9	17598135.0
2009-02-03 11:00:00	SPY	ETF	82.9	83.4	82.88	83.18	16323285.0
2009-02-03 11:30:00	SPY	ETF	83.18	83.22	82.77	82.86	11490710.0
2009-02-03 12:00:00	SPY	ETF	82.86	82.99	82.63	82.78	14450952.0
2009-02-03 12:30:00	SPY	ETF	82.78	83.06	82.66	82.68	9637045.0
2009-02-03 13:00:00	SPY	ETF	82.67	82.98	82.59	82.71	9373578.0
2009-02-03 13:30:00	SPY	ETF	82.73	83.17	82.67	82.95	13813146.0
2009-02-03 14:00:00	SPY	ETF	82.96	83.69	82.84	83.4	23375098.0
2009-02-03 14:30:00	SPY	ETF	83.41	83.86	83.39	83.63	18197229.0
2009-02-03 15:00:00	SPY	ETF	83.635	84.36	83.47	84.21	29088594.0
2009-02-03 15:30:00	SPY	ETF	84.22	84.32	83.77	83.81	35527060.0
2009-02-03 16:00:00	SPY	ETF	83.82	83.93	82.75	83.6	12187049.0
2009-02-03 16:30:00	SPY	ETF	83.59	83.74	83.4	83.57	425277.0
2009-02-03 17:00:00	SPY	ETF	83.57	83.79	83.55	83.79	363187.0
2009-02-03 17:30:00	SPY	ETF	83.79	83.85	83.76	83.78	91802.0
2009-02-03 18:00:00	SPY	ETF	83.75	83.82	83.72	83.75	21524.0
2009-02-03 18:30:00	SPY	ETF	83.74	83.78	83.61	83.61	10355.0
2009-02-03 19:00:00	SPY	ETF	83.61	83.73	83.59	83.71	14375.0
2009-02-03 19:30:00	SPY	ETF	83.73	83.84	83.73	83.8	38257.0
2009-02-03 04:00:00	QQQ	ETF	29.46	29.46	29.46	29.46	400.0
2009-02-03 05:30:00	QQQ	ETF	29.25	29.25	29.22	29.22	700.0
2009-02-03 06:00:00	QQQ	ETF	29.31	29.4	29.31	29.4	11000.0
2009-02-03 06:30:00	QQQ	ETF	29.33	29.36	29.22	29.23	26777.0
2009-02-03 07:00:00	QQQ	ETF	29.31	29.44	29.31	29.41	26430.0
2009-02-03 07:30:00	QQQ	ETF	29.43	29.46	29.33	29.41	80078.0
2009-02-03 08:00:00	QQQ	ETF	29.41	29.42	29.28	29.34	341956.0
2009-02-03 08:30:00	QQQ	ETF	29.33	29.41	29.3	29.39	378554.0
2009-02-03 09:00:00	QQQ	ETF	29.4	29.53	29.4	29.46	1242361.0
2009-02-03 09:30:00	QQQ	ETF	29.46	29.54	29.03	29.11	18464379.0
2009-02-03 10:00:00	QQQ	ETF	29.11	29.33	29.1	29.2605	14604670.0
2009-02-03 10:30:00	QQQ	ETF	29.26	29.55	29.24	29.44	10455609.0
2009-02-03 11:00:00	QQQ	ETF	29.4405	29.65	29.44	29.58	6947325.0
2009-02-03 11:30:00	QQQ	ETF	29.59	29.6	29.45	29.47	6168600.0
2009-02-03 12:00:00	QQQ	ETF	29.47	29.51	29.38	29.43	4352017.0
2009-02-03 12:30:00	QQQ	ETF	29.43	29.51	29.38	29.3801	3485667.0
2009-02-03 13:00:00	QQQ	ETF	29.38	29.46	29.35	29.39	2845616.0
2009-02-03 13:30:00	QQQ	ETF	29.39	29.54	29.37	29.47	4796307.0

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

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