PREVIEW / etf_30min / 2008-10-23

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-23.parquet
  size:    182 KB
  rows:    6,432

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
2008-10-23 04:00:00	SPY	ETF	92.3	92.4	92.12	92.3	8185.0
2008-10-23 04:30:00	SPY	ETF	92.31	92.31	91.12	91.12	12400.0
2008-10-23 05:00:00	SPY	ETF	91.0	91.0	90.58	90.58	848.0
2008-10-23 05:30:00	SPY	ETF	90.42	90.55	89.95	90.19	19054.0
2008-10-23 06:00:00	SPY	ETF	90.45	91.06	90.45	90.75	36200.0
2008-10-23 06:30:00	SPY	ETF	90.67	90.85	89.75	89.75	72806.0
2008-10-23 07:00:00	SPY	ETF	89.9	90.42	89.61	89.86	266534.0
2008-10-23 07:30:00	SPY	ETF	89.89	90.0	88.5	88.67	1011716.0
2008-10-23 08:00:00	SPY	ETF	88.64	92.25	88.58	89.07	2198556.0
2008-10-23 08:30:00	SPY	ETF	89.04	90.64	88.64	89.88	5241620.0
2008-10-23 09:00:00	SPY	ETF	89.88	90.34	89.0	90.26	3321693.0
2008-10-23 09:30:00	SPY	ETF	90.29	91.08	88.35	89.71	52488126.0
2008-10-23 10:00:00	SPY	ETF	89.7	90.73	89.45	89.75	49452190.0
2008-10-23 10:30:00	SPY	ETF	89.75	92.25	89.59	92.1	42086965.0
2008-10-23 11:00:00	SPY	ETF	92.1	92.45	90.98	91.24	29883833.0
2008-10-23 11:30:00	SPY	ETF	91.24	91.9	90.75	91.41	22466719.0
2008-10-23 12:00:00	SPY	ETF	91.4	91.42	88.88	89.13	32452630.0
2008-10-23 12:30:00	SPY	ETF	89.13	89.69	88.15	88.35	35209032.0
2008-10-23 13:00:00	SPY	ETF	88.34	89.28	87.76	88.0	38046203.0
2008-10-23 13:30:00	SPY	ETF	88.0	88.71	87.45	87.91	31161358.0
2008-10-23 14:00:00	SPY	ETF	87.9	87.9075	85.81	86.92	46492960.0
2008-10-23 14:30:00	SPY	ETF	86.93	88.22	86.07	86.91	51305193.0
2008-10-23 15:00:00	SPY	ETF	86.89	89.7398	86.39	88.63	73215266.0
2008-10-23 15:30:00	SPY	ETF	88.61	91.87	87.45	91.05	85283313.0
2008-10-23 16:00:00	SPY	ETF	91.04	91.71	89.7769	91.49	13782013.0
2008-10-23 16:30:00	SPY	ETF	91.48	91.73	91.33	91.67	9523904.0
2008-10-23 17:00:00	SPY	ETF	91.67	91.67	91.38	91.42	3300721.0
2008-10-23 17:30:00	SPY	ETF	91.46	91.55	89.7398	91.5	2188687.0
2008-10-23 18:00:00	SPY	ETF	91.45	91.6	91.4	91.58	48038.0
2008-10-23 18:30:00	SPY	ETF	91.6	91.6	91.3	91.4	60613.0
2008-10-23 19:00:00	SPY	ETF	91.38	91.7	91.38	91.45	36321.0
2008-10-23 19:30:00	SPY	ETF	91.45	91.55	91.37	91.45	53045.0
2008-10-23 04:00:00	QQQ	ETF	31.09	31.09	31.09	31.09	3000.0
2008-10-23 04:30:00	QQQ	ETF	30.92	30.92	30.61	30.61	3400.0
2008-10-23 05:00:00	QQQ	ETF	30.55	30.55	30.55	30.55	900.0
2008-10-23 05:30:00	QQQ	ETF	30.46	30.55	30.45	30.55	2775.0
2008-10-23 06:00:00	QQQ	ETF	30.55	30.77	30.55	30.67	1600.0
2008-10-23 06:30:00	QQQ	ETF	30.67	30.67	30.54	30.54	1900.0
2008-10-23 07:00:00	QQQ	ETF	30.49	30.64	30.33	30.51	157133.0
2008-10-23 07:30:00	QQQ	ETF	30.5	30.5	30.12	30.17	272713.0
2008-10-23 08:00:00	QQQ	ETF	30.17	30.77	30.12	30.3	650368.0
2008-10-23 08:30:00	QQQ	ETF	30.13	30.32	30.04	30.32	1681744.0
2008-10-23 09:00:00	QQQ	ETF	30.32	30.54	30.23	30.46	1261653.0
2008-10-23 09:30:00	QQQ	ETF	30.47	30.8	29.87	30.32	35095529.0
2008-10-23 10:00:00	QQQ	ETF	30.3	30.62	30.17	30.32	27368156.0
2008-10-23 10:30:00	QQQ	ETF	30.32	31.0	30.25	30.94	24792799.0
2008-10-23 11:00:00	QQQ	ETF	30.94	31.09	30.58	30.68	16499062.0
2008-10-23 11:30:00	QQQ	ETF	30.67	30.79	30.44	30.603	13066568.0
2008-10-23 12:00:00	QQQ	ETF	30.6	30.62	29.87	29.95	15090094.0
2008-10-23 12:30:00	QQQ	ETF	29.95	30.19	29.77	29.8	18867791.0

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

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