PREVIEW / etf_30min / 2006-08-04

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-04.parquet
  size:    80 KB
  rows:    2,735

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-08-04 05:30:00	SPY	ETF	128.24	128.24	128.24	128.24	1500.0
2006-08-04 06:00:00	SPY	ETF	128.27	128.27	128.27	128.27	1000.0
2006-08-04 07:00:00	SPY	ETF	128.37	128.37	128.35	128.37	74600.0
2006-08-04 07:30:00	SPY	ETF	128.33	128.35	128.28	128.34	61400.0
2006-08-04 08:00:00	SPY	ETF	128.37	128.54	128.24	128.52	2790900.0
2006-08-04 08:30:00	SPY	ETF	128.53	129.44	128.5	129.27	10734900.0
2006-08-04 09:00:00	SPY	ETF	129.27	129.3	129.05	129.06	3241800.0
2006-08-04 09:30:00	SPY	ETF	129.06	129.43	128.77	128.95	12522600.0
2006-08-04 10:00:00	SPY	ETF	128.94	129.11	128.66	128.89	8028100.0
2006-08-04 10:30:00	SPY	ETF	128.87	129.1	128.77	128.87	4992800.0
2006-08-04 11:00:00	SPY	ETF	128.87	129.03	128.7	128.94	3149500.0
2006-08-04 11:30:00	SPY	ETF	128.91	129.02	128.48	128.51	3720500.0
2006-08-04 12:00:00	SPY	ETF	128.51	128.65	128.21	128.38	6465600.0
2006-08-04 12:30:00	SPY	ETF	128.39	128.58	128.18	128.3	6107100.0
2006-08-04 13:00:00	SPY	ETF	128.31	128.39	127.72	127.87	6267400.0
2006-08-04 13:30:00	SPY	ETF	127.87	127.99	127.65	127.8	4396500.0
2006-08-04 14:00:00	SPY	ETF	127.83	128.05	127.58	127.68	3546800.0
2006-08-04 14:30:00	SPY	ETF	127.69	127.89	127.5	127.57	3671200.0
2006-08-04 15:00:00	SPY	ETF	127.57	128.0	127.48	127.98	5389600.0
2006-08-04 15:30:00	SPY	ETF	127.97	128.13	127.84	128.08	5217100.0
2006-08-04 16:00:00	SPY	ETF	128.07	128.25	128.0	128.19	2077600.0
2006-08-04 16:30:00	SPY	ETF	128.2	128.3	128.2	128.22	27900.0
2006-08-04 17:00:00	SPY	ETF	128.2	128.23	128.11	128.11	10500.0
2006-08-04 17:30:00	SPY	ETF	128.12	128.23	128.12	128.2	2400.0
2006-08-04 18:00:00	SPY	ETF	128.2	128.23	128.2	128.23	600.0
2006-08-04 18:30:00	SPY	ETF	128.21	128.21	128.21	128.21	300.0
2006-08-04 19:30:00	SPY	ETF	128.21	128.21	128.21	128.21	1500.0
2006-08-04 09:30:00	QQQ	ETF	37.42	37.63	37.36	37.47	15928100.0
2006-08-04 10:00:00	QQQ	ETF	37.47	37.5	37.28	37.37	9375000.0
2006-08-04 10:30:00	QQQ	ETF	37.37	37.47	37.34	37.39	6537200.0
2006-08-04 11:00:00	QQQ	ETF	37.39	37.43	37.32	37.38	5804700.0
2006-08-04 11:30:00	QQQ	ETF	37.39	37.42	37.18	37.19	3927400.0
2006-08-04 12:00:00	QQQ	ETF	37.19	37.22	36.97	37.0	9651100.0
2006-08-04 12:30:00	QQQ	ETF	37.0	37.01	36.89	36.94	5832500.0
2006-08-04 13:00:00	QQQ	ETF	36.95	37.5	36.73	36.84	11007500.0
2006-08-04 13:30:00	QQQ	ETF	36.84	36.92	36.72	36.81	8265500.0
2006-08-04 14:00:00	QQQ	ETF	36.81	36.92	36.7	36.73	7625300.0
2006-08-04 14:30:00	QQQ	ETF	36.73	36.84	36.66	36.69	5507000.0
2006-08-04 15:00:00	QQQ	ETF	36.69	36.9	36.62	36.88	7372300.0
2006-08-04 15:30:00	QQQ	ETF	36.88	36.97	36.78	36.96	10962300.0
2006-08-04 07:30:00	IWM	ETF	70.28	70.28	70.28	70.28	1000.0
2006-08-04 08:00:00	IWM	ETF	70.3	70.6	70.23	70.6	112100.0
2006-08-04 08:30:00	IWM	ETF	70.54	71.32	70.54	71.23	4538200.0
2006-08-04 09:00:00	IWM	ETF	71.23	71.29	71.1	71.14	1325700.0
2006-08-04 09:30:00	IWM	ETF	71.13	71.31	70.87	71.04	10582700.0
2006-08-04 10:00:00	IWM	ETF	71.04	71.19	70.53	70.65	8599500.0
2006-08-04 10:30:00	IWM	ETF	70.65	70.84	70.49	70.54	4425000.0
2006-08-04 11:00:00	IWM	ETF	70.54	70.63	70.36	70.5875	3219000.0
2006-08-04 11:30:00	IWM	ETF	70.59	70.64	70.14	70.15	3457600.0
2006-08-04 12:00:00	IWM	ETF	70.15	70.21	69.72	69.86	5300400.0

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

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