PREVIEW / etf_30min / 2006-03-09

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-03-09.parquet
  size:    61 KB
  rows:    2,142

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-03-09 05:30:00	SPY	ETF	128.54	128.56	128.54	128.56	28000.0
2006-03-09 06:30:00	SPY	ETF	128.54	128.54	128.54	128.54	30000.0
2006-03-09 07:00:00	SPY	ETF	128.5	128.64	128.5	128.62	136900.0
2006-03-09 07:30:00	SPY	ETF	128.63	128.63	128.54	128.55	16000.0
2006-03-09 08:00:00	SPY	ETF	128.55	128.62	128.4	128.52	155000.0
2006-03-09 08:30:00	SPY	ETF	128.5	128.55	128.41	128.46	623700.0
2006-03-09 09:00:00	SPY	ETF	128.41	128.61	128.32	128.34	209300.0
2006-03-09 09:30:00	SPY	ETF	128.33	128.64	128.27	128.62	6205500.0
2006-03-09 10:00:00	SPY	ETF	128.62	128.68	128.39	128.54	5017400.0
2006-03-09 10:30:00	SPY	ETF	128.55	128.66	128.36	128.39	3186400.0
2006-03-09 11:00:00	SPY	ETF	128.41	128.49	128.32	128.43	2319500.0
2006-03-09 11:30:00	SPY	ETF	128.45	128.52	128.35	128.42	1679300.0
2006-03-09 12:00:00	SPY	ETF	128.41	128.42	128.17	128.28	3304600.0
2006-03-09 12:30:00	SPY	ETF	128.28	128.3	128.02	128.12	3409100.0
2006-03-09 13:00:00	SPY	ETF	128.13	128.13	127.75	127.84	5686400.0
2006-03-09 13:30:00	SPY	ETF	127.84	127.99	127.83	127.96	2105400.0
2006-03-09 14:00:00	SPY	ETF	127.97	128.17	127.95	128.041	2937000.0
2006-03-09 14:30:00	SPY	ETF	128.05	128.15	127.8	127.87	3207700.0
2006-03-09 15:00:00	SPY	ETF	127.87	127.88	127.58	127.67	5354600.0
2006-03-09 15:30:00	SPY	ETF	127.67	127.76	127.57	127.57	4622100.0
2006-03-09 16:00:00	SPY	ETF	127.58	127.64	127.38	127.43	2970500.0
2006-03-09 16:30:00	SPY	ETF	127.43	127.45	127.39	127.42	290500.0
2006-03-09 17:00:00	SPY	ETF	127.43	127.46	127.4	127.46	104800.0
2006-03-09 17:30:00	SPY	ETF	127.42	127.58	127.41	127.41	201100.0
2006-03-09 18:00:00	SPY	ETF	127.4	127.42	127.36	127.36	9000.0
2006-03-09 19:00:00	SPY	ETF	127.39	127.41	127.39	127.41	5100.0
2006-03-09 19:30:00	SPY	ETF	127.45	127.5	127.45	127.5	55300.0
2006-03-09 09:30:00	QQQ	ETF	41.0	41.13	40.88	41.12	10583900.0
2006-03-09 10:00:00	QQQ	ETF	41.12	41.15	40.99	41.06	15465400.0
2006-03-09 10:30:00	QQQ	ETF	41.06	41.09	40.9	40.93	8420700.0
2006-03-09 11:00:00	QQQ	ETF	40.93	41.01	40.85	40.96	8996000.0
2006-03-09 11:30:00	QQQ	ETF	40.96	41.0	40.89	40.91	4571500.0
2006-03-09 12:00:00	QQQ	ETF	40.91	40.92	40.75	40.82	5145100.0
2006-03-09 12:30:00	QQQ	ETF	40.83	40.83	40.67	40.75	6431800.0
2006-03-09 13:00:00	QQQ	ETF	40.74	40.75	40.59	40.66	7841700.0
2006-03-09 13:30:00	QQQ	ETF	40.66	40.73	40.63	40.68	4978200.0
2006-03-09 14:00:00	QQQ	ETF	40.68	40.79	40.67	40.75	6076900.0
2006-03-09 14:30:00	QQQ	ETF	40.75	40.82	40.64	40.65	4993900.0
2006-03-09 15:00:00	QQQ	ETF	40.66	40.66	40.53	40.59	6306800.0
2006-03-09 15:30:00	QQQ	ETF	40.59	40.62	40.47	40.48	10684400.0
2006-03-09 08:00:00	IWM	ETF	71.97	71.98	71.9	71.95	4300.0
2006-03-09 08:30:00	IWM	ETF	71.92	71.96	71.89	71.93	8800.0
2006-03-09 09:00:00	IWM	ETF	71.88	71.9	71.88	71.9	20400.0
2006-03-09 09:30:00	IWM	ETF	71.87	72.39	71.78	72.21	4152700.0
2006-03-09 10:00:00	IWM	ETF	72.21	72.27	72.07	72.12	2142300.0
2006-03-09 10:30:00	IWM	ETF	72.11	72.2	71.96	71.96	1797600.0
2006-03-09 11:00:00	IWM	ETF	71.97	72.02	71.86	71.95	1607800.0
2006-03-09 11:30:00	IWM	ETF	71.95	72.02	71.86	71.9	1049200.0
2006-03-09 12:00:00	IWM	ETF	71.89	71.89	71.69	71.75	2324000.0
2006-03-09 12:30:00	IWM	ETF	71.75	71.76	71.54	71.6	1560500.0

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

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