PREVIEW / etf_30min / 2006-07-05

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-05.parquet
  size:    73 KB
  rows:    2,626

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-05 04:00:00	SPY	ETF	127.62	127.62	127.62	127.62	500.0
2006-07-05 07:00:00	SPY	ETF	127.55	127.57	127.4	127.4	6000.0
2006-07-05 07:30:00	SPY	ETF	127.39	127.43	127.37	127.43	3100.0
2006-07-05 08:00:00	SPY	ETF	127.44	127.54	127.35	127.41	1178800.0
2006-07-05 08:30:00	SPY	ETF	127.42	127.8	127.36	127.38	266800.0
2006-07-05 09:00:00	SPY	ETF	127.38	127.38	127.24	127.29	933900.0
2006-07-05 09:30:00	SPY	ETF	127.29	127.37	126.94	127.05	8175300.0
2006-07-05 10:00:00	SPY	ETF	127.04	127.07	126.77	126.98	6763700.0
2006-07-05 10:30:00	SPY	ETF	126.97	127.0	126.55	126.63	10703600.0
2006-07-05 11:00:00	SPY	ETF	126.64	126.7	126.52	126.6	6552500.0
2006-07-05 11:30:00	SPY	ETF	126.6	126.881	126.57	126.86	2633900.0
2006-07-05 12:00:00	SPY	ETF	126.86	126.94	126.81	126.94	1451900.0
2006-07-05 12:30:00	SPY	ETF	126.93	126.98	126.79	126.89	1143600.0
2006-07-05 13:00:00	SPY	ETF	126.9	127.17	126.87	127.08	3743000.0
2006-07-05 13:30:00	SPY	ETF	127.07	127.24	126.94	127.02	3821800.0
2006-07-05 14:00:00	SPY	ETF	127.02	127.06	126.96	127.0286	2494500.0
2006-07-05 14:30:00	SPY	ETF	127.03	127.45	127.01	127.3	4768500.0
2006-07-05 15:00:00	SPY	ETF	127.3	127.3025	126.96	127.01	2733500.0
2006-07-05 15:30:00	SPY	ETF	127.0	127.18	126.82	127.03	5458200.0
2006-07-05 16:00:00	SPY	ETF	127.02	127.14	126.957	127.12	512400.0
2006-07-05 16:30:00	SPY	ETF	127.08	127.12	127.04	127.04	3521100.0
2006-07-05 17:00:00	SPY	ETF	127.05	127.07	127.03	127.07	311100.0
2006-07-05 17:30:00	SPY	ETF	127.02	127.02	127.02	127.02	500.0
2006-07-05 18:00:00	SPY	ETF	127.05	127.08	127.05	127.08	300.0
2006-07-05 19:00:00	SPY	ETF	127.03	127.03	127.03	127.03	500.0
2006-07-05 09:30:00	QQQ	ETF	38.64	38.68	38.35	38.42	14072200.0
2006-07-05 10:00:00	QQQ	ETF	38.42	38.43	38.25	38.34	12416900.0
2006-07-05 10:30:00	QQQ	ETF	38.34	38.37	38.16	38.19	7869200.0
2006-07-05 11:00:00	QQQ	ETF	38.18	38.19	38.09	38.11	8047200.0
2006-07-05 11:30:00	QQQ	ETF	38.11	38.24	38.11	38.22	6032000.0
2006-07-05 12:00:00	QQQ	ETF	38.22	38.23	38.16	38.19	2493200.0
2006-07-05 12:30:00	QQQ	ETF	38.2	38.23	38.16	38.2	2658500.0
2006-07-05 13:00:00	QQQ	ETF	38.2	38.29	38.17	38.25	4237700.0
2006-07-05 13:30:00	QQQ	ETF	38.26	38.28	38.16	38.2	2990900.0
2006-07-05 14:00:00	QQQ	ETF	38.19	38.24	38.16	38.23	1792000.0
2006-07-05 14:30:00	QQQ	ETF	38.23	38.37	38.22	38.34	5790800.0
2006-07-05 15:00:00	QQQ	ETF	38.35	38.35	38.22	38.22	5708600.0
2006-07-05 15:30:00	QQQ	ETF	38.23	38.29	38.16	38.17	12100000.0
2006-07-05 08:00:00	IWM	ETF	72.29	72.35	72.13	72.13	33400.0
2006-07-05 08:30:00	IWM	ETF	72.14	72.15	72.01	72.02	293500.0
2006-07-05 09:00:00	IWM	ETF	72.01	72.0555	71.81	71.88	652000.0
2006-07-05 09:30:00	IWM	ETF	71.84	72.59	71.27	71.38	7858300.0
2006-07-05 10:00:00	IWM	ETF	71.38	71.42	71.12	71.36	4484700.0
2006-07-05 10:30:00	IWM	ETF	71.36	71.43	71.05	71.08	2039100.0
2006-07-05 11:00:00	IWM	ETF	71.09	71.15	70.99	71.09	3033100.0
2006-07-05 11:30:00	IWM	ETF	71.1	71.42	71.09	71.34	3926400.0
2006-07-05 12:00:00	IWM	ETF	71.33	71.39	71.28	71.38	404700.0
2006-07-05 12:30:00	IWM	ETF	71.38	71.41	71.26	71.39	777200.0
2006-07-05 13:00:00	IWM	ETF	71.39	71.61	71.35	71.5	2222900.0
2006-07-05 13:30:00	IWM	ETF	71.51	71.6	71.36	71.391	1267000.0

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

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