PREVIEW / etf_30min / 2006-01-09

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-01-09.parquet
  size:    59 KB
  rows:    2,146

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-09 06:30:00	SPY	ETF	128.34	128.34	128.34	128.34	100.0
2006-01-09 07:00:00	SPY	ETF	128.36	128.38	128.31	128.31	75000.0
2006-01-09 07:30:00	SPY	ETF	128.33	128.37	128.33	128.37	1100.0
2006-01-09 08:00:00	SPY	ETF	128.37	128.42	128.32	128.4	168800.0
2006-01-09 08:30:00	SPY	ETF	128.38	128.42	128.37	128.37	121500.0
2006-01-09 09:00:00	SPY	ETF	128.37	128.44	128.37	128.42	553900.0
2006-01-09 09:30:00	SPY	ETF	128.42	128.6	128.39	128.54	3581400.0
2006-01-09 10:00:00	SPY	ETF	128.53	128.63	128.38	128.58	4954800.0
2006-01-09 10:30:00	SPY	ETF	128.57	128.71	128.49	128.52	3108000.0
2006-01-09 11:00:00	SPY	ETF	128.52	128.68	128.45	128.62	1880000.0
2006-01-09 11:30:00	SPY	ETF	128.62	128.71	128.53	128.68	1384200.0
2006-01-09 12:00:00	SPY	ETF	128.68	128.74	128.59	128.66	1633100.0
2006-01-09 12:30:00	SPY	ETF	128.67	128.8	128.57	128.79	3309800.0
2006-01-09 13:00:00	SPY	ETF	128.8	128.84	128.69	128.71	2694900.0
2006-01-09 13:30:00	SPY	ETF	128.72	129.06	128.7	128.95	3061700.0
2006-01-09 14:00:00	SPY	ETF	128.98	128.99	128.85	128.86	1776200.0
2006-01-09 14:30:00	SPY	ETF	128.86	128.88	128.5	128.66	4459500.0
2006-01-09 15:00:00	SPY	ETF	128.67	128.77	128.59	128.68	3003100.0
2006-01-09 15:30:00	SPY	ETF	128.65	128.97	128.65	128.92	6203700.0
2006-01-09 16:00:00	SPY	ETF	128.92	128.94	128.69	128.7	616600.0
2006-01-09 16:30:00	SPY	ETF	128.69	128.7	128.64	128.67	38300.0
2006-01-09 17:00:00	SPY	ETF	128.67	128.71	128.67	128.67	102300.0
2006-01-09 18:00:00	SPY	ETF	128.74	128.77	128.72	128.76	5300.0
2006-01-09 18:30:00	SPY	ETF	128.7	128.7	128.7	128.7	1900.0
2006-01-09 19:30:00	SPY	ETF	128.71	128.71	128.68	128.68	2200.0
2006-01-09 09:30:00	QQQ	ETF	42.66	42.72	42.61	42.63	8654000.0
2006-01-09 10:00:00	QQQ	ETF	42.63	42.77	42.52	42.76	11192600.0
2006-01-09 10:30:00	QQQ	ETF	42.75	42.83	42.72	42.73	5418200.0
2006-01-09 11:00:00	QQQ	ETF	42.73	42.77	42.65	42.74	3547500.0
2006-01-09 11:30:00	QQQ	ETF	42.75	42.85	42.73	42.83	2824100.0
2006-01-09 12:00:00	QQQ	ETF	42.83	42.84	42.77	42.79	2111000.0
2006-01-09 12:30:00	QQQ	ETF	42.79	42.85	42.75	42.82	2321800.0
2006-01-09 13:00:00	QQQ	ETF	42.82	42.84	42.77	42.8	2805400.0
2006-01-09 13:30:00	QQQ	ETF	42.8	42.92	42.79	42.87	5767600.0
2006-01-09 14:00:00	QQQ	ETF	42.87	42.88	42.79	42.8	3329100.0
2006-01-09 14:30:00	QQQ	ETF	42.8	42.81	42.65	42.73	8690800.0
2006-01-09 15:00:00	QQQ	ETF	42.74	42.79	42.69	42.73	3498600.0
2006-01-09 15:30:00	QQQ	ETF	42.73	42.86	42.72	42.84	6277500.0
2006-01-09 07:00:00	IWM	ETF	69.6	69.6	69.6	69.6	800.0
2006-01-09 08:30:00	IWM	ETF	69.6	69.6	69.56	69.56	1200.0
2006-01-09 09:00:00	IWM	ETF	69.55	69.62	69.54	69.61	86000.0
2006-01-09 09:30:00	IWM	ETF	69.61	69.88	69.57	69.83	2697000.0
2006-01-09 10:00:00	IWM	ETF	69.83	69.97	69.77	69.89	1876600.0
2006-01-09 10:30:00	IWM	ETF	69.9	69.98	69.81	69.83	2514100.0
2006-01-09 11:00:00	IWM	ETF	69.84	70.04	69.79	69.98	1432600.0
2006-01-09 11:30:00	IWM	ETF	69.99	70.11	69.97	70.09	466100.0
2006-01-09 12:00:00	IWM	ETF	70.09	70.15	70.05	70.1	1552300.0
2006-01-09 12:30:00	IWM	ETF	70.1	70.2	70.08	70.2	840700.0
2006-01-09 13:00:00	IWM	ETF	70.2	70.2	70.1	70.13	647600.0
2006-01-09 13:30:00	IWM	ETF	70.14	70.38	70.13	70.32	1577500.0

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

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