PREVIEW / etf_30min / 2006-06-19

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-19.parquet
  size:    69 KB
  rows:    2,425

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-06-19 04:00:00	SPY	ETF	125.11	125.11	125.11	125.11	300.0
2006-06-19 04:30:00	SPY	ETF	125.05	125.05	125.05	125.05	500.0
2006-06-19 05:00:00	SPY	ETF	125.11	125.26	125.11	125.26	2700.0
2006-06-19 05:30:00	SPY	ETF	125.24	125.3	125.24	125.3	8100.0
2006-06-19 06:30:00	SPY	ETF	125.2	125.2	125.17	125.17	47100.0
2006-06-19 07:00:00	SPY	ETF	125.17	125.22	125.17	125.2	106300.0
2006-06-19 07:30:00	SPY	ETF	125.21	125.37	125.21	125.32	48100.0
2006-06-19 08:00:00	SPY	ETF	125.31	125.41	125.17	125.35	456300.0
2006-06-19 08:30:00	SPY	ETF	125.34	125.39	125.29	125.39	181900.0
2006-06-19 09:00:00	SPY	ETF	125.37	125.41	124.98	125.38	406800.0
2006-06-19 09:30:00	SPY	ETF	125.4	125.48	124.93	125.06	9015100.0
2006-06-19 10:00:00	SPY	ETF	125.08	125.18	124.5	124.65	8501700.0
2006-06-19 10:30:00	SPY	ETF	124.64	125.45	124.39	124.73	6170100.0
2006-06-19 11:00:00	SPY	ETF	124.72	124.89	124.56	124.56	3611500.0
2006-06-19 11:30:00	SPY	ETF	124.56	124.82	124.47	124.65	3271700.0
2006-06-19 12:00:00	SPY	ETF	124.65	124.79	124.58	124.65	2379600.0
2006-06-19 12:30:00	SPY	ETF	124.68	124.7	124.5	124.5	1640800.0
2006-06-19 13:00:00	SPY	ETF	124.5	124.59	123.93	124.03	9066200.0
2006-06-19 13:30:00	SPY	ETF	124.04	124.15	123.67	123.84	17254900.0
2006-06-19 14:00:00	SPY	ETF	123.87	125.0298	123.73	123.97	7348200.0
2006-06-19 14:30:00	SPY	ETF	123.94	124.0	123.55	123.57	6587000.0
2006-06-19 15:00:00	SPY	ETF	123.58	124.32	123.56	124.18	5938700.0
2006-06-19 15:30:00	SPY	ETF	124.18	124.34	123.74	123.83	9095000.0
2006-06-19 16:00:00	SPY	ETF	123.81	123.89	123.6	123.69	971900.0
2006-06-19 16:30:00	SPY	ETF	123.7	123.89	123.7	123.77	169500.0
2006-06-19 17:00:00	SPY	ETF	123.77	124.0	123.77	123.85	527600.0
2006-06-19 17:30:00	SPY	ETF	123.85	123.85	123.83	123.83	5100.0
2006-06-19 18:00:00	SPY	ETF	123.83	123.88	123.81	123.84	10600.0
2006-06-19 18:30:00	SPY	ETF	123.85	123.85	123.85	123.85	500.0
2006-06-19 19:00:00	SPY	ETF	123.8	123.8	123.79	123.79	200.0
2006-06-19 19:30:00	SPY	ETF	123.85	123.87	123.85	123.87	5600.0
2006-06-19 09:30:00	QQQ	ETF	38.5	38.54	38.34	38.41	9687300.0
2006-06-19 10:00:00	QQQ	ETF	38.41	38.49	38.17	38.23	10272900.0
2006-06-19 10:30:00	QQQ	ETF	38.23	38.39	38.15	38.35	9247100.0
2006-06-19 11:00:00	QQQ	ETF	38.34	38.47	38.3	38.33	10006800.0
2006-06-19 11:30:00	QQQ	ETF	38.33	38.43	38.28	38.38	6040300.0
2006-06-19 12:00:00	QQQ	ETF	38.39	38.46	38.37	38.41	3370000.0
2006-06-19 12:30:00	QQQ	ETF	38.41	38.43	38.35	38.35	2498700.0
2006-06-19 13:00:00	QQQ	ETF	38.35	38.37	38.07	38.14	17585600.0
2006-06-19 13:30:00	QQQ	ETF	38.14	38.22	38.03	38.13	9573700.0
2006-06-19 14:00:00	QQQ	ETF	38.14	38.19	38.06	38.12	7846900.0
2006-06-19 14:30:00	QQQ	ETF	38.12	38.14	37.93	37.93	9222500.0
2006-06-19 15:00:00	QQQ	ETF	37.93	38.22	37.91	38.17	10819600.0
2006-06-19 15:30:00	QQQ	ETF	38.17	38.23	38.02	38.04	14709200.0
2006-06-19 07:00:00	IWM	ETF	69.1	69.1	69.1	69.1	100.0
2006-06-19 08:00:00	IWM	ETF	69.1	69.12	68.85	69.1	1911400.0
2006-06-19 08:30:00	IWM	ETF	69.11	69.13	69.08	69.1	173200.0
2006-06-19 09:00:00	IWM	ETF	69.1	69.18	69.07	69.08	1087100.0
2006-06-19 09:30:00	IWM	ETF	69.1	69.12	68.34	68.53	7871200.0
2006-06-19 10:00:00	IWM	ETF	68.52	68.59	67.9	67.98	9422200.0

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

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