PREVIEW / etf_30min / 2008-08-01

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-01.parquet
  size:    166 KB
  rows:    5,727

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-01 04:00:00	SPY	ETF	126.9	126.9	126.9	126.9	100.0
2008-08-01 04:30:00	SPY	ETF	126.99	126.99	126.95	126.95	2800.0
2008-08-01 05:30:00	SPY	ETF	127.05	127.05	127.05	127.05	1000.0
2008-08-01 06:00:00	SPY	ETF	127.3	127.3	127.27	127.27	3000.0
2008-08-01 06:30:00	SPY	ETF	127.2	127.27	127.2	127.2	29000.0
2008-08-01 07:00:00	SPY	ETF	127.11	127.17	126.5	126.54	391872.0
2008-08-01 07:30:00	SPY	ETF	126.62	126.75	126.57	126.7	329992.0
2008-08-01 08:00:00	SPY	ETF	126.66	127.25	126.66	127.25	2654659.0
2008-08-01 08:30:00	SPY	ETF	127.25	127.75	127.06	127.3	7856365.0
2008-08-01 09:00:00	SPY	ETF	127.3	127.38	127.08	127.13	1838317.0
2008-08-01 09:30:00	SPY	ETF	127.12	127.28	125.83	126.19	33165338.0
2008-08-01 10:00:00	SPY	ETF	126.19	126.43	125.46	125.73	35673822.0
2008-08-01 10:30:00	SPY	ETF	125.73	126.83	125.73	126.2	20146818.0
2008-08-01 11:00:00	SPY	ETF	126.21	126.31	125.83	126.04	11115016.0
2008-08-01 11:30:00	SPY	ETF	126.03	126.48	126.02	126.31	14016643.0
2008-08-01 12:00:00	SPY	ETF	126.3	126.35	125.81	126.05	13477348.0
2008-08-01 12:30:00	SPY	ETF	126.04	126.1	125.54	125.6	11575046.0
2008-08-01 13:00:00	SPY	ETF	125.61	126.34	125.58	126.22	10340279.0
2008-08-01 13:30:00	SPY	ETF	126.21	127.0	126.02	126.2	12141071.0
2008-08-01 14:00:00	SPY	ETF	126.2	126.3	125.72	126.04	13967446.0
2008-08-01 14:30:00	SPY	ETF	126.03	126.31	125.75	126.23	12894845.0
2008-08-01 15:00:00	SPY	ETF	126.23	126.41	125.84	126.21	12213138.0
2008-08-01 15:30:00	SPY	ETF	126.21	126.63	126.0	126.11	20538382.0
2008-08-01 16:00:00	SPY	ETF	126.12	126.79	125.97	126.25	5258515.0
2008-08-01 16:30:00	SPY	ETF	126.25	126.75	126.16	126.27	2614705.0
2008-08-01 17:00:00	SPY	ETF	126.27	126.33	126.22	126.33	6675.0
2008-08-01 17:30:00	SPY	ETF	126.2	126.23	126.13	126.19	6906.0
2008-08-01 18:00:00	SPY	ETF	126.19	126.2	126.19	126.2	700.0
2008-08-01 19:00:00	SPY	ETF	126.18	126.22	126.18	126.22	2600.0
2008-08-01 19:30:00	SPY	ETF	126.18	126.23	126.18	126.23	10127.0
2008-08-01 05:30:00	QQQ	ETF	45.55	45.55	45.55	45.55	100.0
2008-08-01 06:00:00	QQQ	ETF	45.58	45.58	45.58	45.58	400.0
2008-08-01 07:00:00	QQQ	ETF	45.55	45.55	45.42	45.42	3300.0
2008-08-01 07:30:00	QQQ	ETF	45.46	45.46	45.4	45.42	81347.0
2008-08-01 08:00:00	QQQ	ETF	45.42	45.48	45.32	45.36	3743345.0
2008-08-01 08:30:00	QQQ	ETF	45.41	45.74	45.41	45.69	2124009.0
2008-08-01 09:00:00	QQQ	ETF	45.68	45.69	45.5	45.52	645224.0
2008-08-01 09:30:00	QQQ	ETF	45.53	45.55	44.42	44.67	41950976.0
2008-08-01 10:00:00	QQQ	ETF	44.6699	44.76	44.4	44.6305	26274590.0
2008-08-01 10:30:00	QQQ	ETF	44.64	44.9	44.63	44.83	11973709.0
2008-08-01 11:00:00	QQQ	ETF	44.84	44.88	44.63	44.78	9271437.0
2008-08-01 11:30:00	QQQ	ETF	44.77	45.01	44.76	44.99	7986655.0
2008-08-01 12:00:00	QQQ	ETF	44.99	45.0	44.79	44.86	8216806.0
2008-08-01 12:30:00	QQQ	ETF	44.85	44.86	44.62	44.68	5629468.0
2008-08-01 13:00:00	QQQ	ETF	44.68	45.01	44.65	44.97	9808087.0
2008-08-01 13:30:00	QQQ	ETF	44.98	45.08	44.8501	44.94	7632970.0
2008-08-01 14:00:00	QQQ	ETF	44.94	44.97	44.77	44.9099	5724172.0
2008-08-01 14:30:00	QQQ	ETF	44.9	45.05	44.81	44.99	5546919.0
2008-08-01 15:00:00	QQQ	ETF	44.99	45.1	44.87	44.99	5827996.0
2008-08-01 15:30:00	QQQ	ETF	44.99	45.13	44.88	44.9	13975869.0

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

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