PREVIEW / etf_30min / 2008-04-24

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-24.parquet
  size:    167 KB
  rows:    5,738

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-04-24 06:00:00	SPY	ETF	137.14	137.29	137.02	137.29	65000.0
2008-04-24 06:30:00	SPY	ETF	137.1	137.12	136.75	136.75	365000.0
2008-04-24 07:00:00	SPY	ETF	136.73	137.13	136.72	137.11	610111.0
2008-04-24 07:30:00	SPY	ETF	137.13	137.17	136.88	137.0	489622.0
2008-04-24 08:00:00	SPY	ETF	137.01	137.47	136.84	136.99	2020895.0
2008-04-24 08:30:00	SPY	ETF	136.98	137.72	136.98	137.54	5668151.0
2008-04-24 09:00:00	SPY	ETF	137.54	138.38	137.2	138.08	4507105.0
2008-04-24 09:30:00	SPY	ETF	138.08	138.28	137.53	137.84	19780855.0
2008-04-24 10:00:00	SPY	ETF	137.84	137.88	137.06	137.33	21474667.0
2008-04-24 10:30:00	SPY	ETF	137.33	137.39	137.04	137.35	10510216.0
2008-04-24 11:00:00	SPY	ETF	137.349	137.93	137.32	137.92	14421317.0
2008-04-24 11:30:00	SPY	ETF	137.93	138.71	137.9	138.44	23719644.0
2008-04-24 12:00:00	SPY	ETF	138.44	139.18	138.43	138.89	19877512.0
2008-04-24 12:30:00	SPY	ETF	138.9	139.36	138.86	139.091	10383330.0
2008-04-24 13:00:00	SPY	ETF	139.1	139.41	138.85	138.97	10775497.0
2008-04-24 13:30:00	SPY	ETF	138.96	139.3	138.74	139.24	11314499.0
2008-04-24 14:00:00	SPY	ETF	139.25	139.7	139.14	139.61	14443586.0
2008-04-24 14:30:00	SPY	ETF	139.61	139.74	139.35	139.46	10683661.0
2008-04-24 15:00:00	SPY	ETF	139.45	139.73	139.0	139.37	14308796.0
2008-04-24 15:30:00	SPY	ETF	139.38	139.48	138.7	138.75	23356425.0
2008-04-24 16:00:00	SPY	ETF	138.77	138.8798	138.21	138.42	6667303.0
2008-04-24 16:30:00	SPY	ETF	138.37	139.41	138.16	138.21	1522977.0
2008-04-24 17:00:00	SPY	ETF	138.22	138.39	138.17	138.2	254017.0
2008-04-24 17:30:00	SPY	ETF	138.24	138.35	138.24	138.3	14600.0
2008-04-24 18:00:00	SPY	ETF	138.3	138.34	138.29	138.34	39850.0
2008-04-24 18:30:00	SPY	ETF	138.36	138.4	138.29	138.29	15300.0
2008-04-24 19:00:00	SPY	ETF	138.34	138.34	138.24	138.32	16340.0
2008-04-24 19:30:00	SPY	ETF	138.25	138.28	138.25	138.28	5331.0
2008-04-24 04:30:00	QQQ	ETF	46.45	46.48	46.45	46.48	200.0
2008-04-24 05:30:00	QQQ	ETF	46.5	46.5	46.5	46.5	100.0
2008-04-24 06:00:00	QQQ	ETF	46.45	46.48	46.43	46.48	50000.0
2008-04-24 06:30:00	QQQ	ETF	46.49	46.49	46.42	46.42	50500.0
2008-04-24 07:00:00	QQQ	ETF	46.36	46.47	46.36	46.47	97841.0
2008-04-24 07:30:00	QQQ	ETF	46.47	46.51	46.44	46.49	228330.0
2008-04-24 08:00:00	QQQ	ETF	46.49	46.68	46.49	46.59	2840260.0
2008-04-24 08:30:00	QQQ	ETF	46.64	46.75	46.56	46.67	3879935.0
2008-04-24 09:00:00	QQQ	ETF	46.67	46.96	46.64	46.88	2728674.0
2008-04-24 09:30:00	QQQ	ETF	46.87	46.95	46.515	46.66	14929737.0
2008-04-24 10:00:00	QQQ	ETF	46.66	46.66	46.41	46.51	11668530.0
2008-04-24 10:30:00	QQQ	ETF	46.51	46.57	46.39	46.5599	6347551.0
2008-04-24 11:00:00	QQQ	ETF	46.5505	46.85	46.55	46.84	9289156.0
2008-04-24 11:30:00	QQQ	ETF	46.84	47.33	46.83	47.2	19032998.0
2008-04-24 12:00:00	QQQ	ETF	47.192	47.5	47.192	47.36	11994806.0
2008-04-24 12:30:00	QQQ	ETF	47.36	47.5	47.29	47.369	7113850.0
2008-04-24 13:00:00	QQQ	ETF	47.37	47.46	47.26	47.35	5909742.0
2008-04-24 13:30:00	QQQ	ETF	47.35	47.55	47.28	47.52	7218675.0
2008-04-24 14:00:00	QQQ	ETF	47.5201	47.74	47.49	47.6699	9620617.0
2008-04-24 14:30:00	QQQ	ETF	47.6696	47.75	47.6	47.6901	8177408.0
2008-04-24 15:00:00	QQQ	ETF	47.69	47.79	47.52	47.58	10570402.0
2008-04-24 15:30:00	QQQ	ETF	47.58	47.58	47.26	47.3	18328206.0

> showing 50 of 5,738 rows — these rows as CSV

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