PREVIEW / etf_30min / 2006-04-13

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-04-13.parquet
  size:    59 KB
  rows:    2,154

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-04-13 06:30:00	SPY	ETF	128.87	128.87	128.74	128.74	5500.0
2006-04-13 07:00:00	SPY	ETF	128.73	128.75	128.7	128.7	59500.0
2006-04-13 07:30:00	SPY	ETF	128.69	128.72	128.64	128.66	27100.0
2006-04-13 08:00:00	SPY	ETF	128.69	128.77	128.65	128.77	460100.0
2006-04-13 08:30:00	SPY	ETF	128.79	128.95	128.65	128.68	487100.0
2006-04-13 09:00:00	SPY	ETF	128.69	128.69	128.48	128.6	1254000.0
2006-04-13 09:30:00	SPY	ETF	128.59	128.6	128.31	128.4	8301800.0
2006-04-13 10:00:00	SPY	ETF	128.4	128.92	128.37	128.61	7109200.0
2006-04-13 10:30:00	SPY	ETF	128.61	129.16	128.59	129.11	4922200.0
2006-04-13 11:00:00	SPY	ETF	129.121	129.25	128.92	129.04	6283900.0
2006-04-13 11:30:00	SPY	ETF	129.04	129.12	128.87	129.07	3147000.0
2006-04-13 12:00:00	SPY	ETF	129.07	129.13	128.92	128.96	1361200.0
2006-04-13 12:30:00	SPY	ETF	128.96	129.0	128.77	128.8	3239600.0
2006-04-13 13:00:00	SPY	ETF	128.81	128.88	128.67	128.84	2756000.0
2006-04-13 13:30:00	SPY	ETF	128.85	129.03	128.78	128.97	1042800.0
2006-04-13 14:00:00	SPY	ETF	128.96	128.99	128.81	128.88	978400.0
2006-04-13 14:30:00	SPY	ETF	128.88	128.9	128.63	128.71	2174200.0
2006-04-13 15:00:00	SPY	ETF	128.71	128.79	128.59	128.75	1951100.0
2006-04-13 15:30:00	SPY	ETF	128.74	128.92	128.74	128.86	3624300.0
2006-04-13 16:00:00	SPY	ETF	128.85	128.875	128.69	128.72	508600.0
2006-04-13 16:30:00	SPY	ETF	128.71	128.72	128.71	128.71	5400.0
2006-04-13 17:00:00	SPY	ETF	128.71	128.75	128.67	128.67	16000.0
2006-04-13 17:30:00	SPY	ETF	128.74	128.87	128.74	128.87	4000.0
2006-04-13 19:30:00	SPY	ETF	128.85	128.85	128.85	128.85	300.0
2006-04-13 09:30:00	QQQ	ETF	41.9	41.93	41.79	41.85	6403100.0
2006-04-13 10:00:00	QQQ	ETF	41.85	42.05	41.84	41.94	7347000.0
2006-04-13 10:30:00	QQQ	ETF	41.94	42.27	41.94	42.27	8052500.0
2006-04-13 11:00:00	QQQ	ETF	42.27	42.33	42.21	42.24	7783300.0
2006-04-13 11:30:00	QQQ	ETF	42.24	42.29	42.2	42.26	3087600.0
2006-04-13 12:00:00	QQQ	ETF	42.26	42.29	42.19	42.2	2892800.0
2006-04-13 12:30:00	QQQ	ETF	42.21	42.25	42.16	42.17	2722300.0
2006-04-13 13:00:00	QQQ	ETF	42.15	42.25	42.11	42.19	3359600.0
2006-04-13 13:30:00	QQQ	ETF	42.19	42.26	42.17	42.24	1475000.0
2006-04-13 14:00:00	QQQ	ETF	42.24	42.24	42.17	42.19	1472600.0
2006-04-13 14:30:00	QQQ	ETF	42.2	42.21	42.09	42.12	3000600.0
2006-04-13 15:00:00	QQQ	ETF	42.12	42.13	42.02	42.07	2871400.0
2006-04-13 15:30:00	QQQ	ETF	42.08	42.13	42.07	42.1	5420000.0
2006-04-13 06:30:00	IWM	ETF	75.27	75.27	75.27	75.27	100.0
2006-04-13 07:30:00	IWM	ETF	74.3	74.3	74.3	74.3	100.0
2006-04-13 08:00:00	IWM	ETF	74.32	74.32	74.21	74.27	502100.0
2006-04-13 08:30:00	IWM	ETF	74.36	74.47	74.28	74.3	55100.0
2006-04-13 09:00:00	IWM	ETF	74.28	74.28	74.14	74.2	441500.0
2006-04-13 09:30:00	IWM	ETF	74.2	74.2	73.76	73.87	4531100.0
2006-04-13 10:00:00	IWM	ETF	73.88	74.34	73.88	74.05	3432400.0
2006-04-13 10:30:00	IWM	ETF	74.04	74.56	74.0	74.53	4050800.0
2006-04-13 11:00:00	IWM	ETF	74.53	74.78	74.45	74.65	4691600.0
2006-04-13 11:30:00	IWM	ETF	74.66	74.93	74.57	74.88	1431600.0
2006-04-13 12:00:00	IWM	ETF	74.9	74.92	74.74	74.78	1279500.0
2006-04-13 12:30:00	IWM	ETF	74.79	74.84	74.66	74.69	1232100.0
2006-04-13 13:00:00	IWM	ETF	74.68	74.81	74.62	74.75	1260300.0

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

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