PREVIEW / etf_30min / 2006-01-06

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-06.parquet
  size:    60 KB
  rows:    2,137

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-01-06 04:00:00	SPY	ETF	127.37	127.37	127.37	127.37	60000.0
2006-01-06 07:00:00	SPY	ETF	127.53	127.53	127.53	127.53	600.0
2006-01-06 07:30:00	SPY	ETF	127.61	127.65	127.58	127.65	150200.0
2006-01-06 08:00:00	SPY	ETF	127.65	127.83	127.48	127.73	936500.0
2006-01-06 08:30:00	SPY	ETF	127.72	128.06	127.49	128.01	3364800.0
2006-01-06 09:00:00	SPY	ETF	128.02	128.04	127.39	128.04	2144300.0
2006-01-06 09:30:00	SPY	ETF	128.04	128.13	127.77	127.85	9884500.0
2006-01-06 10:00:00	SPY	ETF	127.85	127.87	127.43	127.58	8265300.0
2006-01-06 10:30:00	SPY	ETF	127.57	127.74	127.44	127.6	2778000.0
2006-01-06 11:00:00	SPY	ETF	127.61	127.96	127.45	127.95	5415500.0
2006-01-06 11:30:00	SPY	ETF	127.94	128.04	127.8	127.89	2167000.0
2006-01-06 12:00:00	SPY	ETF	127.89	128.12	127.87	128.05	2288200.0
2006-01-06 12:30:00	SPY	ETF	128.05	128.14	127.96	128.0	1820000.0
2006-01-06 13:00:00	SPY	ETF	128.0	128.14	127.95	128.09	1763800.0
2006-01-06 13:30:00	SPY	ETF	128.08	128.5	128.02	128.38	4837700.0
2006-01-06 14:00:00	SPY	ETF	128.39	128.57	128.29	128.45	5104800.0
2006-01-06 14:30:00	SPY	ETF	128.45	128.5	128.32	128.43	3131200.0
2006-01-06 15:00:00	SPY	ETF	128.42	128.58	128.41	128.49	2659800.0
2006-01-06 15:30:00	SPY	ETF	128.48	128.53	128.33	128.42	3971700.0
2006-01-06 16:00:00	SPY	ETF	128.44	128.55	128.4	128.48	653000.0
2006-01-06 16:30:00	SPY	ETF	128.54	128.62	128.44	128.52	113300.0
2006-01-06 17:00:00	SPY	ETF	128.53	128.53	128.41	128.5	15600.0
2006-01-06 17:30:00	SPY	ETF	128.52	128.53	128.46	128.47	3600.0
2006-01-06 18:00:00	SPY	ETF	128.48	128.5	128.46	128.46	2800.0
2006-01-06 18:30:00	SPY	ETF	128.45	128.48	128.45	128.48	2200.0
2006-01-06 19:30:00	SPY	ETF	128.5	128.5	128.5	128.5	600.0
2006-01-06 09:30:00	QQQ	ETF	42.26	42.34	42.15	42.21	14983700.0
2006-01-06 10:00:00	QQQ	ETF	42.2	42.21	42.06	42.15	8927500.0
2006-01-06 10:30:00	QQQ	ETF	42.14	42.21	42.14	42.18	3830400.0
2006-01-06 11:00:00	QQQ	ETF	42.18	42.28	42.11	42.25	5293800.0
2006-01-06 11:30:00	QQQ	ETF	42.25	42.33	42.23	42.29	3338500.0
2006-01-06 12:00:00	QQQ	ETF	42.29	42.41	42.29	42.38	7023000.0
2006-01-06 12:30:00	QQQ	ETF	42.39	42.5	42.39	42.43	6439500.0
2006-01-06 13:00:00	QQQ	ETF	42.43	42.45	42.36	42.43	4344400.0
2006-01-06 13:30:00	QQQ	ETF	42.44	42.59	42.4	42.56	7862400.0
2006-01-06 14:00:00	QQQ	ETF	42.57	42.7	42.53	42.64	7681100.0
2006-01-06 14:30:00	QQQ	ETF	42.64	42.65	42.57	42.62	5009300.0
2006-01-06 15:00:00	QQQ	ETF	42.62	42.68	42.6	42.67	4939000.0
2006-01-06 15:30:00	QQQ	ETF	42.66	42.68	42.55	42.66	10541500.0
2006-01-06 07:00:00	IWM	ETF	68.91	68.91	68.87	68.87	14000.0
2006-01-06 08:00:00	IWM	ETF	68.95	69.09	68.91	69.0	110100.0
2006-01-06 08:30:00	IWM	ETF	69.1	69.6	69.05	69.15	215800.0
2006-01-06 09:00:00	IWM	ETF	69.17	69.18	68.79	69.14	235700.0
2006-01-06 09:30:00	IWM	ETF	69.12	69.23	68.89	69.0	1949000.0
2006-01-06 10:00:00	IWM	ETF	69.0	69.0	68.68	68.77	1639700.0
2006-01-06 10:30:00	IWM	ETF	68.77	68.91	68.76	68.87	1314000.0
2006-01-06 11:00:00	IWM	ETF	68.86	69.1	68.76	69.095	2708200.0
2006-01-06 11:30:00	IWM	ETF	69.09	69.12	68.99	69.09	1222100.0
2006-01-06 12:00:00	IWM	ETF	69.1	69.29	69.08	69.26	1313100.0
2006-01-06 12:30:00	IWM	ETF	69.26	69.35	69.23	69.29	931100.0

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

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