PREVIEW / etf_30min / 2008-12-29

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-29.parquet
  size:    202 KB
  rows:    6,696

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-12-29 04:00:00	SPY	ETF	87.26	87.39	87.26	87.39	1520.0
2008-12-29 04:30:00	SPY	ETF	87.4	87.45	87.4	87.45	200.0
2008-12-29 05:00:00	SPY	ETF	87.5	87.5	87.47	87.47	2200.0
2008-12-29 05:30:00	SPY	ETF	87.4	87.44	87.4	87.44	1341.0
2008-12-29 06:00:00	SPY	ETF	87.44	87.52	87.44	87.52	1800.0
2008-12-29 06:30:00	SPY	ETF	87.48	87.55	87.39	87.39	6585.0
2008-12-29 07:00:00	SPY	ETF	87.38	87.45	87.34	87.39	16350.0
2008-12-29 07:30:00	SPY	ETF	87.38	87.4	87.17	87.31	67318.0
2008-12-29 08:00:00	SPY	ETF	87.29	87.58	87.09	87.26	843458.0
2008-12-29 08:30:00	SPY	ETF	87.26	87.31	87.1	87.1	433578.0
2008-12-29 09:00:00	SPY	ETF	87.11	87.27	87.08	87.23	463262.0
2008-12-29 09:30:00	SPY	ETF	87.24	87.33	86.85	86.965	8463221.0
2008-12-29 10:00:00	SPY	ETF	86.97	86.97	86.29	86.38	9925059.0
2008-12-29 10:30:00	SPY	ETF	86.38	86.5	86.12	86.14	8195912.0
2008-12-29 11:00:00	SPY	ETF	86.15	86.18	85.98	86.1	7799965.0
2008-12-29 11:30:00	SPY	ETF	86.1	86.27	86.07	86.23	6981962.0
2008-12-29 12:00:00	SPY	ETF	86.24	86.38	86.11	86.1583	6283110.0
2008-12-29 12:30:00	SPY	ETF	86.16	86.16	85.75	85.75	7965466.0
2008-12-29 13:00:00	SPY	ETF	85.7599	85.85	85.6	85.6225	6286254.0
2008-12-29 13:30:00	SPY	ETF	85.63	86.16	85.61	86.11	7009994.0
2008-12-29 14:00:00	SPY	ETF	86.11	86.18	85.78	86.1	5864256.0
2008-12-29 14:30:00	SPY	ETF	86.1	86.31	85.92	86.2025	6823214.0
2008-12-29 15:00:00	SPY	ETF	86.21	86.66	86.21	86.4	11698940.0
2008-12-29 15:30:00	SPY	ETF	86.4	86.92	86.11	86.89	17540768.0
2008-12-29 16:00:00	SPY	ETF	86.9	87.38	86.25	87.21	11537812.0
2008-12-29 16:30:00	SPY	ETF	87.22	87.32	87.15	87.3	839089.0
2008-12-29 17:00:00	SPY	ETF	87.31	87.33	87.26	87.28	94009.0
2008-12-29 17:30:00	SPY	ETF	87.28	87.32	87.25	87.31	217225.0
2008-12-29 18:00:00	SPY	ETF	87.3	87.39	87.27	87.38	238094.0
2008-12-29 18:30:00	SPY	ETF	87.36	87.36	87.22	87.24	34038.0
2008-12-29 19:00:00	SPY	ETF	87.26	87.47	87.26	87.47	67128.0
2008-12-29 19:30:00	SPY	ETF	87.48	87.5	87.35	87.39	72205.0
2008-12-29 05:00:00	QQQ	ETF	29.4	29.4	29.4	29.4	10000.0
2008-12-29 06:00:00	QQQ	ETF	29.38	29.38	29.38	29.38	100.0
2008-12-29 06:30:00	QQQ	ETF	29.4	29.42	29.4	29.42	1266.0
2008-12-29 07:00:00	QQQ	ETF	29.38	29.4	29.38	29.39	7752.0
2008-12-29 07:30:00	QQQ	ETF	29.34	29.34	29.28	29.29	28428.0
2008-12-29 08:00:00	QQQ	ETF	29.3	29.31	29.24	29.27	45215.0
2008-12-29 08:30:00	QQQ	ETF	29.28	29.29	29.22	29.22	71112.0
2008-12-29 09:00:00	QQQ	ETF	29.22	29.27	29.21	29.22	138786.0
2008-12-29 09:30:00	QQQ	ETF	29.22	29.24	29.04	29.06	3187234.0
2008-12-29 10:00:00	QQQ	ETF	29.05	29.06	28.66	28.73	5837433.0
2008-12-29 10:30:00	QQQ	ETF	28.73	28.75	28.59	28.6499	2935800.0
2008-12-29 11:00:00	QQQ	ETF	28.64	28.68	28.57	28.68	2216533.0
2008-12-29 11:30:00	QQQ	ETF	28.68	28.72	28.66	28.6879	1869162.0
2008-12-29 12:00:00	QQQ	ETF	28.69	28.75	28.65	28.66	1706073.0
2008-12-29 12:30:00	QQQ	ETF	28.66	28.68	28.541	28.55	1841780.0
2008-12-29 13:00:00	QQQ	ETF	28.55	28.56	28.46	28.4774	3299832.0
2008-12-29 13:30:00	QQQ	ETF	28.47	28.66	28.47	28.62	2516814.0
2008-12-29 14:00:00	QQQ	ETF	28.62	28.63	28.5	28.61	3100040.0

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

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