PREVIEW / etf_30min / 2006-11-01

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-11-01.parquet
  size:    89 KB
  rows:    3,044

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-11-01 04:30:00	SPY	ETF	137.84	137.84	137.84	137.84	500.0
2006-11-01 06:30:00	SPY	ETF	138.02	138.03	138.02	138.03	2000.0
2006-11-01 07:00:00	SPY	ETF	137.97	138.03	137.97	138.03	3000.0
2006-11-01 07:30:00	SPY	ETF	138.02	138.08	138.0	138.04	171800.0
2006-11-01 08:00:00	SPY	ETF	138.03	138.29	137.98	138.27	1213900.0
2006-11-01 08:30:00	SPY	ETF	138.27	138.33	138.22	138.33	679100.0
2006-11-01 09:00:00	SPY	ETF	138.35	138.35	137.79	138.21	271300.0
2006-11-01 09:30:00	SPY	ETF	138.22	138.31	138.05	138.07	7184000.0
2006-11-01 10:00:00	SPY	ETF	138.07	138.22	137.63	137.69	11977600.0
2006-11-01 10:30:00	SPY	ETF	137.69	137.99	137.65	137.91	5137700.0
2006-11-01 11:00:00	SPY	ETF	137.92	138.05	137.67	137.77	4215400.0
2006-11-01 11:30:00	SPY	ETF	137.77	137.78	137.4	137.48	4794600.0
2006-11-01 12:00:00	SPY	ETF	137.47	137.57	137.34	137.37	5114600.0
2006-11-01 12:30:00	SPY	ETF	137.37	137.39	137.21	137.35	3220100.0
2006-11-01 13:00:00	SPY	ETF	137.35	137.54	137.27	137.51	2814800.0
2006-11-01 13:30:00	SPY	ETF	137.51	137.58	137.39	137.47	2912900.0
2006-11-01 14:00:00	SPY	ETF	137.46	137.54	137.12	137.22	3372600.0
2006-11-01 14:30:00	SPY	ETF	137.22	137.5	137.04	137.04	4772100.0
2006-11-01 15:00:00	SPY	ETF	137.04	137.07	136.77	136.82	9768200.0
2006-11-01 15:30:00	SPY	ETF	136.82	136.93	136.72	136.91	9218800.0
2006-11-01 16:00:00	SPY	ETF	136.92	136.99	136.86	136.91	2325300.0
2006-11-01 16:30:00	SPY	ETF	136.86	136.9	136.83	136.83	2049300.0
2006-11-01 17:00:00	SPY	ETF	136.85	136.9	136.85	136.85	100700.0
2006-11-01 17:30:00	SPY	ETF	136.88	136.88	136.8	136.8	6400.0
2006-11-01 18:00:00	SPY	ETF	136.82	136.88	136.82	136.88	900.0
2006-11-01 18:30:00	SPY	ETF	136.9	136.9	136.9	136.9	200.0
2006-11-01 19:30:00	SPY	ETF	136.9	136.9	136.9	136.9	100.0
2006-11-01 09:30:00	QQQ	ETF	42.73	42.75	42.68	42.7	10440400.0
2006-11-01 10:00:00	QQQ	ETF	42.69	42.77	42.4	42.46	19630300.0
2006-11-01 10:30:00	QQQ	ETF	42.46	42.55	42.41	42.52	9521700.0
2006-11-01 11:00:00	QQQ	ETF	42.52	42.58	42.43	42.49	7888300.0
2006-11-01 11:30:00	QQQ	ETF	42.49	42.51	42.33	42.37	6846600.0
2006-11-01 12:00:00	QQQ	ETF	42.37	42.42	42.32	42.33	4530800.0
2006-11-01 12:30:00	QQQ	ETF	42.33	42.36	42.26	42.33	7380400.0
2006-11-01 13:00:00	QQQ	ETF	42.32	42.4	42.28	42.39	6056500.0
2006-11-01 13:30:00	QQQ	ETF	42.4	42.42	42.35	42.36	4803600.0
2006-11-01 14:00:00	QQQ	ETF	42.36	42.37	42.16	42.23	6949800.0
2006-11-01 14:30:00	QQQ	ETF	42.23	42.24	42.1	42.12	7529400.0
2006-11-01 15:00:00	QQQ	ETF	42.12	42.13	41.87	41.88	21171200.0
2006-11-01 15:30:00	QQQ	ETF	41.88	42.0	41.82	41.99	16341400.0
2006-11-01 07:00:00	IWM	ETF	76.15	76.3	76.15	76.3	300.0
2006-11-01 08:00:00	IWM	ETF	76.33	76.51	76.33	76.49	33200.0
2006-11-01 08:30:00	IWM	ETF	76.51	76.56	76.47	76.54	129800.0
2006-11-01 09:00:00	IWM	ETF	76.55	76.58	76.45	76.47	192100.0
2006-11-01 09:30:00	IWM	ETF	76.45	76.58	76.2	76.22	3084000.0
2006-11-01 10:00:00	IWM	ETF	76.21	76.4	75.69	75.79	6098100.0
2006-11-01 10:30:00	IWM	ETF	75.77	76.07	75.73	76.03	2535900.0
2006-11-01 11:00:00	IWM	ETF	76.03	76.12	75.76	75.94	2867600.0
2006-11-01 11:30:00	IWM	ETF	75.95	75.96	75.62	75.71	2571300.0
2006-11-01 12:00:00	IWM	ETF	75.7	75.79	75.63	75.67	1502100.0

> showing 50 of 3,044 rows — these rows as CSV

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