PREVIEW / etf_30min / 2006-07-12

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-12.parquet
  size:    76 KB
  rows:    2,622

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
2006-07-12 07:00:00	SPY	ETF	127.36	127.36	127.36	127.36	40000.0
2006-07-12 07:30:00	SPY	ETF	127.36	127.36	127.35	127.36	19000.0
2006-07-12 08:00:00	SPY	ETF	127.32	127.37	127.28	127.33	159000.0
2006-07-12 08:30:00	SPY	ETF	127.34	127.36	127.22	127.22	560900.0
2006-07-12 09:00:00	SPY	ETF	127.21	127.25	127.17	127.21	220600.0
2006-07-12 09:30:00	SPY	ETF	127.21	127.4	127.11	127.21	5273500.0
2006-07-12 10:00:00	SPY	ETF	127.19	127.2	126.93	126.97	4533400.0
2006-07-12 10:30:00	SPY	ETF	126.95	127.05	126.56	126.66	10232900.0
2006-07-12 11:00:00	SPY	ETF	126.66	126.79	126.56	126.71	3852200.0
2006-07-12 11:30:00	SPY	ETF	126.71	126.95	126.68	126.89	4704800.0
2006-07-12 12:00:00	SPY	ETF	126.9	126.93	126.38	126.43	5065200.0
2006-07-12 12:30:00	SPY	ETF	126.42	126.56	126.34	126.5	4558600.0
2006-07-12 13:00:00	SPY	ETF	126.5	126.51	126.12	126.15	6808900.0
2006-07-12 13:30:00	SPY	ETF	126.15	126.28	125.91	126.1	6026100.0
2006-07-12 14:00:00	SPY	ETF	126.08	126.25	125.99	126.16	4874000.0
2006-07-12 14:30:00	SPY	ETF	126.16	126.22	125.72	125.82	9264600.0
2006-07-12 15:00:00	SPY	ETF	125.83	126.22	125.73	126.08	7640700.0
2006-07-12 15:30:00	SPY	ETF	126.08	126.11	125.78	125.96	6179100.0
2006-07-12 16:00:00	SPY	ETF	125.95	126.14	125.95	126.05	806100.0
2006-07-12 16:30:00	SPY	ETF	126.05	126.11	126.05	126.05	111800.0
2006-07-12 17:00:00	SPY	ETF	126.08	126.1	126.08	126.08	4500.0
2006-07-12 17:30:00	SPY	ETF	126.07	126.1	126.05	126.05	184400.0
2006-07-12 18:00:00	SPY	ETF	126.05	126.1	126.03	126.03	70200.0
2006-07-12 19:30:00	SPY	ETF	126.04	126.06	126.04	126.06	700.0
2006-07-12 09:30:00	QQQ	ETF	37.56	37.64	37.44	37.46	14273000.0
2006-07-12 10:00:00	QQQ	ETF	37.44	37.49	37.37	37.41	15518900.0
2006-07-12 10:30:00	QQQ	ETF	37.41	37.43	37.22	37.27	14629800.0
2006-07-12 11:00:00	QQQ	ETF	37.26	37.31	37.21	37.26	5900500.0
2006-07-12 11:30:00	QQQ	ETF	37.26	37.38	37.24	37.35	6435300.0
2006-07-12 12:00:00	QQQ	ETF	37.35	37.36	37.13	37.15	6225700.0
2006-07-12 12:30:00	QQQ	ETF	37.15	37.19	37.1	37.16	5235100.0
2006-07-12 13:00:00	QQQ	ETF	37.17	37.17	36.89	36.93	19058200.0
2006-07-12 13:30:00	QQQ	ETF	36.94	37.01	36.86	36.97	8258200.0
2006-07-12 14:00:00	QQQ	ETF	36.96	37.06	36.91	37.0	8358900.0
2006-07-12 14:30:00	QQQ	ETF	37.01	37.04	36.84	36.89	13449300.0
2006-07-12 15:00:00	QQQ	ETF	36.88	37.05	36.84	36.99	11192500.0
2006-07-12 15:30:00	QQQ	ETF	37.0	37.01	36.88	36.92	11364500.0
2006-07-12 08:00:00	IWM	ETF	70.95	71.03	70.8	70.8	63800.0
2006-07-12 08:30:00	IWM	ETF	70.87	70.88	70.68	70.7	834600.0
2006-07-12 09:00:00	IWM	ETF	70.7	70.79	70.65	70.77	483700.0
2006-07-12 09:30:00	IWM	ETF	70.78	71.08	70.7	70.91	3672500.0
2006-07-12 10:00:00	IWM	ETF	70.89	70.93	70.68	70.73	2960700.0
2006-07-12 10:30:00	IWM	ETF	70.73	70.75	70.24	70.28	7744000.0
2006-07-12 11:00:00	IWM	ETF	70.28	70.41	70.22	70.35	2246700.0
2006-07-12 11:30:00	IWM	ETF	70.34	70.57	70.31	70.52	1820100.0
2006-07-12 12:00:00	IWM	ETF	70.52	70.56	70.16	70.24	2180700.0
2006-07-12 12:30:00	IWM	ETF	70.24	70.31	70.14	70.28	1497600.0
2006-07-12 13:00:00	IWM	ETF	70.29	70.29	69.96	69.97	3558900.0
2006-07-12 13:30:00	IWM	ETF	69.97	70.14	69.88	69.98	3074200.0
2006-07-12 14:00:00	IWM	ETF	69.97	70.08	69.88	70.0	3203000.0

> showing 50 of 2,622 rows — these rows as CSV

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