PREVIEW / etf_30min / 2008-10-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-29.parquet
  size:    180 KB
  rows:    6,446

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-29 04:00:00	SPY	ETF	92.02	92.15	92.0	92.0	1900.0
2008-10-29 04:30:00	SPY	ETF	92.03	92.24	91.94	91.95	2700.0
2008-10-29 05:00:00	SPY	ETF	92.0	92.1	92.0	92.05	28100.0
2008-10-29 05:30:00	SPY	ETF	91.87	92.0	91.73	92.0	11400.0
2008-10-29 06:00:00	SPY	ETF	92.21	93.0	92.21	93.0	116350.0
2008-10-29 06:30:00	SPY	ETF	92.99	93.8	92.89	93.7	200962.0
2008-10-29 07:00:00	SPY	ETF	93.7	93.75	92.94	93.37	427545.0
2008-10-29 07:30:00	SPY	ETF	93.43	94.64	93.3	94.24	1350909.0
2008-10-29 08:00:00	SPY	ETF	94.25	95.23	92.0	94.05	4619752.0
2008-10-29 08:30:00	SPY	ETF	94.15	94.58	93.57	93.74	4580642.0
2008-10-29 09:00:00	SPY	ETF	93.74	94.25	93.57	93.77	3870363.0
2008-10-29 09:30:00	SPY	ETF	93.77	93.94	92.79	93.3	47524278.0
2008-10-29 10:00:00	SPY	ETF	93.29	94.72	92.94	94.24	39532304.0
2008-10-29 10:30:00	SPY	ETF	94.23	94.4	92.98	93.14	30132987.0
2008-10-29 11:00:00	SPY	ETF	93.15	93.98	92.97	93.81	23923737.0
2008-10-29 11:30:00	SPY	ETF	93.8425	94.25	93.62	94.22	16965901.0
2008-10-29 12:00:00	SPY	ETF	94.2325	94.62	93.75	94.59	12030034.0
2008-10-29 12:30:00	SPY	ETF	94.58	95.42	94.47	94.5801	20999062.0
2008-10-29 13:00:00	SPY	ETF	94.58	94.97	94.37	94.71	13960213.0
2008-10-29 13:30:00	SPY	ETF	94.71	95.58	94.71	94.87	19777117.0
2008-10-29 14:00:00	SPY	ETF	94.87	95.38	93.27	94.04	51097464.0
2008-10-29 14:30:00	SPY	ETF	94.04	94.95	92.81	94.43	55246590.0
2008-10-29 15:00:00	SPY	ETF	94.43	97.16	93.81	96.3	60342748.0
2008-10-29 15:30:00	SPY	ETF	96.28	97.17	92.1	92.32	100348518.0
2008-10-29 16:00:00	SPY	ETF	92.31	94.4955	92.22	92.95	14192361.0
2008-10-29 16:30:00	SPY	ETF	92.97	94.12	92.97	93.51	5433743.0
2008-10-29 17:00:00	SPY	ETF	93.45	94.12	93.38	93.45	1680517.0
2008-10-29 17:30:00	SPY	ETF	93.45	93.59	93.35	93.5	99130.0
2008-10-29 18:00:00	SPY	ETF	93.55	93.69	93.47	93.51	27600.0
2008-10-29 18:30:00	SPY	ETF	93.5	93.73	93.46	93.7	28226.0
2008-10-29 19:00:00	SPY	ETF	93.65	93.73	93.46	93.49	23640.0
2008-10-29 19:30:00	SPY	ETF	93.48	93.63	93.46	93.63	46010.0
2008-10-29 04:00:00	QQQ	ETF	31.45	31.45	31.37	31.37	4300.0
2008-10-29 04:30:00	QQQ	ETF	31.42	31.42	31.33	31.33	3900.0
2008-10-29 05:00:00	QQQ	ETF	31.34	31.37	31.34	31.35	2100.0
2008-10-29 05:30:00	QQQ	ETF	31.22	31.4	31.22	31.35	3400.0
2008-10-29 06:00:00	QQQ	ETF	31.41	31.68	31.41	31.68	2500.0
2008-10-29 06:30:00	QQQ	ETF	31.68	31.88	31.64	31.83	9700.0
2008-10-29 07:00:00	QQQ	ETF	31.88	31.89	31.65	31.75	109441.0
2008-10-29 07:30:00	QQQ	ETF	31.75	32.31	31.71	32.16	460159.0
2008-10-29 08:00:00	QQQ	ETF	32.15	32.4	31.4	32.07	1502584.0
2008-10-29 08:30:00	QQQ	ETF	32.08	32.26	31.83	31.87	996165.0
2008-10-29 09:00:00	QQQ	ETF	31.9	32.05	31.85	31.96	1569657.0
2008-10-29 09:30:00	QQQ	ETF	31.96	31.96	31.25	31.57	33756675.0
2008-10-29 10:00:00	QQQ	ETF	31.57	32.08	31.45	31.94	21493196.0
2008-10-29 10:30:00	QQQ	ETF	31.93	32.02	31.41	31.48	16491979.0
2008-10-29 11:00:00	QQQ	ETF	31.48	31.84	31.443	31.8	13836434.0
2008-10-29 11:30:00	QQQ	ETF	31.7901	31.95	31.68	31.9299	11661616.0
2008-10-29 12:00:00	QQQ	ETF	31.9299	32.14	31.82	32.14	9398896.0
2008-10-29 12:30:00	QQQ	ETF	32.14	32.43	32.13	32.26	15129084.0

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

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