PREVIEW / etf_30min / 2008-08-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-19.parquet
  size:    170 KB
  rows:    5,980

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-08-19 04:00:00	SPY	ETF	128.13	128.13	128.13	128.13	600.0
2008-08-19 05:00:00	SPY	ETF	128.2	128.2	128.2	128.2	3000.0
2008-08-19 05:30:00	SPY	ETF	128.18	128.2	128.18	128.2	101000.0
2008-08-19 06:00:00	SPY	ETF	128.18	128.35	128.07	128.1	234700.0
2008-08-19 06:30:00	SPY	ETF	128.08	128.08	127.95	127.95	69100.0
2008-08-19 07:00:00	SPY	ETF	128.0	128.03	127.85	127.85	307674.0
2008-08-19 07:30:00	SPY	ETF	127.85	127.88	127.71	127.75	439964.0
2008-08-19 08:00:00	SPY	ETF	127.74	127.99	127.59	127.63	1553688.0
2008-08-19 08:30:00	SPY	ETF	127.68	127.79	127.1	127.21	5031948.0
2008-08-19 09:00:00	SPY	ETF	127.2	128.39	127.2	127.43	1816370.0
2008-08-19 09:30:00	SPY	ETF	127.42	127.69	126.98	127.28	28370096.0
2008-08-19 10:00:00	SPY	ETF	127.28	127.35	126.83	126.93	15845010.0
2008-08-19 10:30:00	SPY	ETF	126.93	127.35	126.83	126.99	13778111.0
2008-08-19 11:00:00	SPY	ETF	126.99	127.04	126.73	126.96	11274170.0
2008-08-19 11:30:00	SPY	ETF	126.945	127.02	126.58	126.64	10394267.0
2008-08-19 12:00:00	SPY	ETF	126.64	126.98	126.55	126.91	12261258.0
2008-08-19 12:30:00	SPY	ETF	126.92	128.1181	126.83	127.04	8129623.0
2008-08-19 13:00:00	SPY	ETF	127.05	127.29	126.94	127.13	6512462.0
2008-08-19 13:30:00	SPY	ETF	127.13	127.43	126.94	126.975	10370074.0
2008-08-19 14:00:00	SPY	ETF	126.99	127.14	126.77	126.789	8665840.0
2008-08-19 14:30:00	SPY	ETF	126.79	127.03	126.65	126.93	9498069.0
2008-08-19 15:00:00	SPY	ETF	126.93	127.15	126.53	126.92	16993738.0
2008-08-19 15:30:00	SPY	ETF	126.92	127.02	126.66	127.02	17517641.0
2008-08-19 16:00:00	SPY	ETF	126.9901	128.1184	126.91	127.04	3909612.0
2008-08-19 16:30:00	SPY	ETF	127.05	128.1181	126.99	126.99	1557758.0
2008-08-19 17:00:00	SPY	ETF	127.0	127.12	126.99	127.06	3083202.0
2008-08-19 17:30:00	SPY	ETF	127.1	127.13	127.06	127.07	19537.0
2008-08-19 18:00:00	SPY	ETF	127.06	127.07	127.03	127.03	38419.0
2008-08-19 18:30:00	SPY	ETF	127.02	127.09	127.02	127.09	3200.0
2008-08-19 19:00:00	SPY	ETF	127.09	127.09	127.09	127.09	200.0
2008-08-19 19:30:00	SPY	ETF	127.05	127.19	127.05	127.19	15967.0
2008-08-19 06:00:00	QQQ	ETF	47.66	47.66	47.64	47.64	2000.0
2008-08-19 06:30:00	QQQ	ETF	47.58	47.58	47.57	47.57	2400.0
2008-08-19 07:00:00	QQQ	ETF	47.6	47.6	47.55	47.55	54300.0
2008-08-19 07:30:00	QQQ	ETF	47.54	47.54	47.41	47.43	896152.0
2008-08-19 08:00:00	QQQ	ETF	47.43	47.49	47.4	47.46	1891211.0
2008-08-19 08:30:00	QQQ	ETF	47.49	47.49	47.3	47.34	2167751.0
2008-08-19 09:00:00	QQQ	ETF	47.35	47.41	47.33	47.37	1815749.0
2008-08-19 09:30:00	QQQ	ETF	47.37	47.59	47.24	47.38	29580141.0
2008-08-19 10:00:00	QQQ	ETF	47.38	47.38	47.14	47.18	12141410.0
2008-08-19 10:30:00	QQQ	ETF	47.18	47.33	47.14	47.2	6801616.0
2008-08-19 11:00:00	QQQ	ETF	47.2	47.29	47.15	47.28	5994952.0
2008-08-19 11:30:00	QQQ	ETF	47.27	47.33	47.11	47.12	7411925.0
2008-08-19 12:00:00	QQQ	ETF	47.12	47.13	46.98	47.06	9884760.0
2008-08-19 12:30:00	QQQ	ETF	47.06	47.21	47.02	47.11	5465677.0
2008-08-19 13:00:00	QQQ	ETF	47.11	47.29	47.07	47.27	3679901.0
2008-08-19 13:30:00	QQQ	ETF	47.27	47.39	47.1	47.11	9480791.0
2008-08-19 14:00:00	QQQ	ETF	47.1	47.208	47.0	47.01	7374399.0
2008-08-19 14:30:00	QQQ	ETF	47.01	47.08	46.92	47.01	6667812.0
2008-08-19 15:00:00	QQQ	ETF	47.01	47.01	46.75	46.88	12380311.0

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

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