PREVIEW / etf_30min / 2008-10-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-27.parquet
  size:    175 KB
  rows:    6,267

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-27 04:00:00	SPY	ETF	83.17	83.66	82.81	83.66	2800.0
2008-10-27 04:30:00	SPY	ETF	83.62	83.62	83.01	83.07	1825.0
2008-10-27 05:00:00	SPY	ETF	83.4	84.01	83.32	83.82	5200.0
2008-10-27 05:30:00	SPY	ETF	84.11	84.11	83.54	83.57	1100.0
2008-10-27 06:00:00	SPY	ETF	83.7	83.93	83.6	83.92	15200.0
2008-10-27 06:30:00	SPY	ETF	83.61	84.46	83.61	83.7	27900.0
2008-10-27 07:00:00	SPY	ETF	83.88	85.03	83.85	84.93	391454.0
2008-10-27 07:30:00	SPY	ETF	84.84	84.94	84.4	84.62	731007.0
2008-10-27 08:00:00	SPY	ETF	83.99	87.5	82.96	84.41	2878183.0
2008-10-27 08:30:00	SPY	ETF	84.43	86.26	84.39	86.18	3845863.0
2008-10-27 09:00:00	SPY	ETF	86.17	86.84	85.35	85.96	5414992.0
2008-10-27 09:30:00	SPY	ETF	85.97	87.48	85.51	87.23	49447573.0
2008-10-27 10:00:00	SPY	ETF	87.23	88.47	86.69	86.96	41223561.0
2008-10-27 10:30:00	SPY	ETF	86.97	88.4	86.06	87.37	25392400.0
2008-10-27 11:00:00	SPY	ETF	87.36	88.3	86.5	87.2	22773799.0
2008-10-27 11:30:00	SPY	ETF	87.19	87.38	86.5	87.06	18090332.0
2008-10-27 12:00:00	SPY	ETF	87.06	88.15	87.05	87.27	21955722.0
2008-10-27 12:30:00	SPY	ETF	87.26	88.82	87.07	88.72	22724871.0
2008-10-27 13:00:00	SPY	ETF	88.73	89.06	87.96	89.04	18752162.0
2008-10-27 13:30:00	SPY	ETF	89.06	89.51	88.44	88.67	20176524.0
2008-10-27 14:00:00	SPY	ETF	88.68	88.82	87.45	87.47	18366259.0
2008-10-27 14:30:00	SPY	ETF	87.46	87.89	86.73	86.7975	25384334.0
2008-10-27 15:00:00	SPY	ETF	86.82	87.88	86.73	87.33	22714856.0
2008-10-27 15:30:00	SPY	ETF	87.33	87.78	84.68	84.86	53646561.0
2008-10-27 16:00:00	SPY	ETF	84.85	88.6	83.69	83.89	12823482.0
2008-10-27 16:30:00	SPY	ETF	83.92	84.72	83.86	84.0	2195398.0
2008-10-27 17:00:00	SPY	ETF	84.05	84.1128	83.77	83.9	2763233.0
2008-10-27 17:30:00	SPY	ETF	83.9	88.21	83.73	83.73	700256.0
2008-10-27 18:00:00	SPY	ETF	83.77	83.77	83.07	83.25	2965924.0
2008-10-27 18:30:00	SPY	ETF	83.27	83.39	83.17	83.29	97355.0
2008-10-27 19:00:00	SPY	ETF	83.26	83.57	83.26	83.57	79569.0
2008-10-27 19:30:00	SPY	ETF	83.57	83.82	83.53	83.79	148813.0
2008-10-27 04:00:00	QQQ	ETF	28.12	28.37	28.11	28.37	1700.0
2008-10-27 04:30:00	QQQ	ETF	28.34	28.43	28.19	28.19	5500.0
2008-10-27 05:00:00	QQQ	ETF	28.28	28.34	28.28	28.34	3500.0
2008-10-27 05:30:00	QQQ	ETF	28.5	28.53	28.17	28.25	21500.0
2008-10-27 06:00:00	QQQ	ETF	28.32	28.39	28.24	28.24	18600.0
2008-10-27 06:30:00	QQQ	ETF	28.34	28.57	28.25	28.25	68295.0
2008-10-27 07:00:00	QQQ	ETF	28.34	28.79	28.33	28.77	183277.0
2008-10-27 07:30:00	QQQ	ETF	28.77	28.78	28.65	28.71	213432.0
2008-10-27 08:00:00	QQQ	ETF	28.76	29.95	28.68	28.76	489598.0
2008-10-27 08:30:00	QQQ	ETF	28.74	29.34	28.74	29.32	1348867.0
2008-10-27 09:00:00	QQQ	ETF	29.31	29.47	28.55	29.13	2416692.0
2008-10-27 09:30:00	QQQ	ETF	29.13	29.51	28.91	29.4	35569869.0
2008-10-27 10:00:00	QQQ	ETF	29.4	29.76	29.13	29.1399	30367147.0
2008-10-27 10:30:00	QQQ	ETF	29.14	29.32	28.87	29.3	16528326.0
2008-10-27 11:00:00	QQQ	ETF	29.3	29.6	29.15	29.32	13863172.0
2008-10-27 11:30:00	QQQ	ETF	29.33	29.42	29.12	29.3199	9070555.0
2008-10-27 12:00:00	QQQ	ETF	29.32	29.65	29.31	29.41	11778800.0
2008-10-27 12:30:00	QQQ	ETF	29.41	29.94	29.35	29.91	13758506.0

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

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