PREVIEW / etf_30min / 2009-09-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-17.parquet
  size:    234 KB
  rows:    7,770

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
2009-09-17 04:00:00	SPY	ETF	107.56	107.56	107.33	107.33	1700.0
2009-09-17 04:30:00	SPY	ETF	107.38	107.38	107.21	107.21	2130.0
2009-09-17 05:00:00	SPY	ETF	107.23	107.43	107.23	107.43	8300.0
2009-09-17 05:30:00	SPY	ETF	107.43	107.5	107.43	107.5	3090.0
2009-09-17 06:00:00	SPY	ETF	107.5	107.5	107.45	107.45	2200.0
2009-09-17 06:30:00	SPY	ETF	107.51	107.54	107.49	107.52	18950.0
2009-09-17 07:00:00	SPY	ETF	107.54	107.54	107.36	107.38	37522.0
2009-09-17 07:30:00	SPY	ETF	107.41	107.44	107.18	107.2	227389.0
2009-09-17 08:00:00	SPY	ETF	107.24	107.42	107.21	107.27	969864.0
2009-09-17 08:30:00	SPY	ETF	107.29	107.43	107.04	107.06	2462298.0
2009-09-17 09:00:00	SPY	ETF	107.06	108.81	106.97	107.18	1113385.0
2009-09-17 09:30:00	SPY	ETF	107.17	107.86	107.16	107.85	23878219.0
2009-09-17 10:00:00	SPY	ETF	107.85	108.06	107.2	107.3	25959523.0
2009-09-17 10:30:00	SPY	ETF	107.3	107.73	107.29	107.62	14741950.0
2009-09-17 11:00:00	SPY	ETF	107.63	107.84	107.48	107.77	10883369.0
2009-09-17 11:30:00	SPY	ETF	107.77	107.78	107.25	107.38	12642167.0
2009-09-17 12:00:00	SPY	ETF	107.38	107.43	106.91	107.18	14804255.0
2009-09-17 12:30:00	SPY	ETF	107.18	107.56	106.69	106.72	12335533.0
2009-09-17 13:00:00	SPY	ETF	106.72	106.95	106.57	106.69	11699835.0
2009-09-17 13:30:00	SPY	ETF	106.7	107.11	106.64	107.06	10709671.0
2009-09-17 14:00:00	SPY	ETF	107.06	107.11	106.93	107.02	8874759.0
2009-09-17 14:30:00	SPY	ETF	107.01	107.35	107.0	107.2206	9650092.0
2009-09-17 15:00:00	SPY	ETF	107.23	107.4	107.12	107.31	10900244.0
2009-09-17 15:30:00	SPY	ETF	107.31	107.31	106.88	107.15	16782735.0
2009-09-17 16:00:00	SPY	ETF	107.16	107.79	106.7311	107.26	19154080.0
2009-09-17 16:30:00	SPY	ETF	107.24	108.8	107.19	107.23	9570057.0
2009-09-17 17:00:00	SPY	ETF	107.24	107.25	107.14	107.23	168296.0
2009-09-17 17:30:00	SPY	ETF	107.21	107.3557	107.21	107.22	1004350.0
2009-09-17 18:00:00	SPY	ETF	107.22	107.22	107.14	107.14	835928.0
2009-09-17 18:30:00	SPY	ETF	107.15	107.18	107.14	107.14	8348.0
2009-09-17 19:00:00	SPY	ETF	107.14	107.14	107.11	107.11	11071.0
2009-09-17 19:30:00	SPY	ETF	107.1	107.1	107.02	107.02	46919.0
2009-09-17 05:30:00	QQQ	ETF	42.45	42.45	42.45	42.45	5500.0
2009-09-17 06:00:00	QQQ	ETF	42.44	42.44	42.42	42.42	700.0
2009-09-17 06:30:00	QQQ	ETF	42.44	42.44	42.44	42.44	566.0
2009-09-17 07:00:00	QQQ	ETF	42.41	42.41	42.33	42.37	63800.0
2009-09-17 07:30:00	QQQ	ETF	42.38	42.38	42.29	42.29	45554.0
2009-09-17 08:00:00	QQQ	ETF	42.29	42.38	42.28	42.33	279631.0
2009-09-17 08:30:00	QQQ	ETF	42.34	42.38	42.22	42.23	393876.0
2009-09-17 09:00:00	QQQ	ETF	42.24	42.91	42.21	42.31	772211.0
2009-09-17 09:30:00	QQQ	ETF	42.32	42.55	42.302	42.5299	12311968.0
2009-09-17 10:00:00	QQQ	ETF	42.53	42.65	42.4	42.4494	16869837.0
2009-09-17 10:30:00	QQQ	ETF	42.45	42.61	42.44	42.58	4723011.0
2009-09-17 11:00:00	QQQ	ETF	42.58	42.66	42.52	42.63	4064143.0
2009-09-17 11:30:00	QQQ	ETF	42.6204	42.63	42.44	42.5	8326656.0
2009-09-17 12:00:00	QQQ	ETF	42.5	42.5201	42.31	42.41	6208027.0
2009-09-17 12:30:00	QQQ	ETF	42.4	42.44	42.22	42.24	7976524.0
2009-09-17 13:00:00	QQQ	ETF	42.23	42.37	42.21	42.27	3234816.0
2009-09-17 13:30:00	QQQ	ETF	42.2699	42.43	42.22	42.41	4191764.0
2009-09-17 14:00:00	QQQ	ETF	42.41	42.44	42.36	42.4	3996750.0

> showing 50 of 7,770 rows — these rows as CSV

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