PREVIEW / etf_30min / 2010-01-28

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-28.parquet
  size:    255 KB
  rows:    8,413

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
2010-01-28 04:00:00	SPY	ETF	110.38	110.38	110.36	110.36	2200.0
2010-01-28 04:30:00	SPY	ETF	110.46	110.5	110.46	110.5	300.0
2010-01-28 05:00:00	SPY	ETF	110.5	110.5	110.35	110.35	21200.0
2010-01-28 05:30:00	SPY	ETF	110.31	110.31	110.07	110.2	14400.0
2010-01-28 06:00:00	SPY	ETF	110.18	110.3	110.08	110.26	2750.0
2010-01-28 06:30:00	SPY	ETF	110.26	110.26	110.09	110.15	18700.0
2010-01-28 07:00:00	SPY	ETF	110.2	110.47	110.14	110.44	316592.0
2010-01-28 07:30:00	SPY	ETF	110.44	110.63	110.41	110.41	414166.0
2010-01-28 08:00:00	SPY	ETF	110.39	110.6	110.37	110.49	2613094.0
2010-01-28 08:30:00	SPY	ETF	110.42	110.85	109.92	110.21	2523377.0
2010-01-28 09:00:00	SPY	ETF	110.2	110.38	109.81	110.2	2051633.0
2010-01-28 09:30:00	SPY	ETF	110.19	110.25	109.44	109.7	28828908.0
2010-01-28 10:00:00	SPY	ETF	109.71	109.725	109.01	109.21	28751152.0
2010-01-28 10:30:00	SPY	ETF	109.21	109.41	108.86	109.01	17634356.0
2010-01-28 11:00:00	SPY	ETF	109.0	109.05	108.52	108.58	22468106.0
2010-01-28 11:30:00	SPY	ETF	108.59	108.64	107.91	108.34	30330342.0
2010-01-28 12:00:00	SPY	ETF	108.34	108.37	108.05	108.125	11711408.0
2010-01-28 12:30:00	SPY	ETF	108.1225	108.54	108.1	108.53	10323971.0
2010-01-28 13:00:00	SPY	ETF	108.53	108.8	108.43	108.77	15244018.0
2010-01-28 13:30:00	SPY	ETF	108.77	109.8639	108.69	108.74	23645006.0
2010-01-28 14:00:00	SPY	ETF	108.74	108.78	108.32	108.723	18558694.0
2010-01-28 14:30:00	SPY	ETF	108.73	108.96	108.47	108.8	13615067.0
2010-01-28 15:00:00	SPY	ETF	108.8	109.25	108.75	109.05	21643227.0
2010-01-28 15:30:00	SPY	ETF	109.06	109.36	108.54	108.56	39474874.0
2010-01-28 16:00:00	SPY	ETF	108.56	109.63	108.19	108.63	12321127.0
2010-01-28 16:30:00	SPY	ETF	108.63	108.84	108.57	108.66	8831406.0
2010-01-28 17:00:00	SPY	ETF	108.7	108.73	108.49	108.57	3725300.0
2010-01-28 17:30:00	SPY	ETF	108.54	108.57	108.46	108.55	57039.0
2010-01-28 18:00:00	SPY	ETF	108.52	108.53	108.18	108.22	428507.0
2010-01-28 18:30:00	SPY	ETF	108.21	108.35	108.15	108.26	37357.0
2010-01-28 19:00:00	SPY	ETF	108.28	108.28	108.09	108.17	35233.0
2010-01-28 19:30:00	SPY	ETF	108.16	108.16	108.01	108.11	79255.0
2010-01-28 05:00:00	QQQ	ETF	44.72	44.72	44.72	44.72	340.0
2010-01-28 05:30:00	QQQ	ETF	44.64	44.64	44.52	44.58	11900.0
2010-01-28 06:00:00	QQQ	ETF	44.58	44.61	44.53	44.61	11800.0
2010-01-28 07:00:00	QQQ	ETF	44.56	44.65	44.54	44.64	141381.0
2010-01-28 07:30:00	QQQ	ETF	44.66	44.77	44.65	44.68	1218084.0
2010-01-28 08:00:00	QQQ	ETF	44.68	44.75	44.64	44.66	3231474.0
2010-01-28 08:30:00	QQQ	ETF	44.66	44.85	44.47	44.49	1606883.0
2010-01-28 09:00:00	QQQ	ETF	44.49	44.52	44.37	44.39	880640.0
2010-01-28 09:30:00	QQQ	ETF	44.39	44.43	44.0125	44.1699	23177300.0
2010-01-28 10:00:00	QQQ	ETF	44.18	44.18	43.72	43.8	20972866.0
2010-01-28 10:30:00	QQQ	ETF	43.8	43.89	43.62	43.68	14610665.0
2010-01-28 11:00:00	QQQ	ETF	43.68	43.7	43.51	43.58	21084156.0
2010-01-28 11:30:00	QQQ	ETF	43.5725	43.64	43.35	43.47	16344638.0
2010-01-28 12:00:00	QQQ	ETF	43.48	43.53	43.32	43.36	8977906.0
2010-01-28 12:30:00	QQQ	ETF	43.37	43.5	43.34	43.5	4456351.0
2010-01-28 13:00:00	QQQ	ETF	43.51	43.55	43.42	43.53	7842308.0
2010-01-28 13:30:00	QQQ	ETF	43.535	43.67	43.5	43.54	7447031.0
2010-01-28 14:00:00	QQQ	ETF	43.545	43.57	43.36	43.54	6232469.0

> showing 50 of 8,413 rows — these rows as CSV

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