PREVIEW / etf_30min / 2008-06-20

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-20.parquet
  size:    171 KB
  rows:    5,905

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-06-20 04:00:00	SPY	ETF	133.44	133.52	133.43	133.5	5600.0
2008-06-20 04:30:00	SPY	ETF	133.43	133.43	133.43	133.43	100.0
2008-06-20 05:00:00	SPY	ETF	133.55	133.71	133.55	133.71	151100.0
2008-06-20 05:30:00	SPY	ETF	133.64	133.64	133.64	133.64	23000.0
2008-06-20 06:00:00	SPY	ETF	133.65	133.65	133.5	133.54	138100.0
2008-06-20 06:30:00	SPY	ETF	133.5	133.5	133.12	133.13	588800.0
2008-06-20 07:00:00	SPY	ETF	133.08	133.18	132.77	132.85	1105335.0
2008-06-20 07:30:00	SPY	ETF	132.85	132.94	132.75	132.87	1223761.0
2008-06-20 08:00:00	SPY	ETF	132.89	133.16	132.78	133.1	5100059.0
2008-06-20 08:30:00	SPY	ETF	133.1	133.11	132.81	133.0	2628240.0
2008-06-20 09:00:00	SPY	ETF	132.96	133.26	132.8	132.85	4156140.0
2008-06-20 09:30:00	SPY	ETF	132.85	133.09	132.49	132.66	40331542.0
2008-06-20 10:00:00	SPY	ETF	132.66	132.832	132.01	132.47	31976293.0
2008-06-20 10:30:00	SPY	ETF	132.47	132.49	132.09	132.439	20736542.0
2008-06-20 11:00:00	SPY	ETF	132.43	132.85	132.33	132.66	20715364.0
2008-06-20 11:30:00	SPY	ETF	132.65	132.98	132.49	132.64	9665852.0
2008-06-20 12:00:00	SPY	ETF	132.63	132.65	132.32	132.5	8296489.0
2008-06-20 12:30:00	SPY	ETF	132.49	132.63	132.39	132.44	7780237.0
2008-06-20 13:00:00	SPY	ETF	132.44	132.74	132.07	132.14	13122118.0
2008-06-20 13:30:00	SPY	ETF	132.14	132.14	131.75	131.86	21871276.0
2008-06-20 14:00:00	SPY	ETF	131.87	131.95	131.42	131.71	20275660.0
2008-06-20 14:30:00	SPY	ETF	131.68	132.5	131.22	131.29	12996441.0
2008-06-20 15:00:00	SPY	ETF	131.29	131.9	131.23	131.61	20425294.0
2008-06-20 15:30:00	SPY	ETF	131.62	132.0	131.51	131.59	28374447.0
2008-06-20 16:00:00	SPY	ETF	131.6299	131.97	131.51	131.65	6529817.0
2008-06-20 16:30:00	SPY	ETF	131.65	134.0817	131.5	131.7	3748607.0
2008-06-20 17:00:00	SPY	ETF	131.68	134.0817	131.68	131.75	2728883.0
2008-06-20 17:30:00	SPY	ETF	131.8	131.8	131.63	131.63	110480.0
2008-06-20 18:00:00	SPY	ETF	131.75	131.8	131.69	131.79	4125.0
2008-06-20 18:30:00	SPY	ETF	131.78	131.78	131.7	131.75	6637.0
2008-06-20 19:00:00	SPY	ETF	131.73	131.78	131.7	131.78	10791.0
2008-06-20 19:30:00	SPY	ETF	131.74	131.79	131.74	131.79	3147.0
2008-06-20 04:00:00	QQQ	ETF	48.57	48.6	48.57	48.6	8200.0
2008-06-20 04:30:00	QQQ	ETF	48.57	48.57	48.54	48.54	6300.0
2008-06-20 05:00:00	QQQ	ETF	48.59	48.59	48.59	48.59	200.0
2008-06-20 06:30:00	QQQ	ETF	48.5	48.5	48.5	48.5	200.0
2008-06-20 07:00:00	QQQ	ETF	48.45	48.47	48.34	48.38	33800.0
2008-06-20 07:30:00	QQQ	ETF	48.38	48.42	48.32	48.42	87600.0
2008-06-20 08:00:00	QQQ	ETF	48.43	48.45	48.37	48.44	1500509.0
2008-06-20 08:30:00	QQQ	ETF	48.43	48.43	48.34	48.36	478137.0
2008-06-20 09:00:00	QQQ	ETF	48.36	48.45	48.32	48.33	1484582.0
2008-06-20 09:30:00	QQQ	ETF	48.34	48.35	47.93	47.98	25123249.0
2008-06-20 10:00:00	QQQ	ETF	47.97	48.0	47.65	47.86	21243370.0
2008-06-20 10:30:00	QQQ	ETF	47.85	47.85	47.49	47.68	15433460.0
2008-06-20 11:00:00	QQQ	ETF	47.68	47.81	47.56	47.75	14824678.0
2008-06-20 11:30:00	QQQ	ETF	47.75	47.82	47.64	47.74	5599350.0
2008-06-20 12:00:00	QQQ	ETF	47.74	47.7699	47.59	47.67	7464781.0
2008-06-20 12:30:00	QQQ	ETF	47.66	47.68	47.57	47.61	5386883.0
2008-06-20 13:00:00	QQQ	ETF	47.6	47.74	47.45	47.4715	10306471.0
2008-06-20 13:30:00	QQQ	ETF	47.47	47.56	47.39	47.51	10157385.0

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

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