PREVIEW / etf_30min / 2006-06-27

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-06-27.parquet
  size:    73 KB
  rows:    2,498

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-27 07:00:00	SPY	ETF	124.74	124.74	124.63	124.63	94200.0
2006-06-27 07:30:00	SPY	ETF	124.65	124.7	124.59	124.7	52000.0
2006-06-27 08:00:00	SPY	ETF	124.75	124.89	124.6	124.86	730600.0
2006-06-27 08:30:00	SPY	ETF	124.86	124.91	124.84	124.87	230200.0
2006-06-27 09:00:00	SPY	ETF	124.87	125.05	124.87	125.05	323700.0
2006-06-27 09:30:00	SPY	ETF	125.01	125.26	125.0	125.16	6014500.0
2006-06-27 10:00:00	SPY	ETF	125.17	125.29	124.87	124.99	5697600.0
2006-06-27 10:30:00	SPY	ETF	124.99	125.13	124.83	124.89	3124600.0
2006-06-27 11:00:00	SPY	ETF	124.9	124.92	124.32	124.5	10024400.0
2006-06-27 11:30:00	SPY	ETF	124.5	124.6	124.39	124.52	3669800.0
2006-06-27 12:00:00	SPY	ETF	124.51	124.53	124.3	124.36	3845700.0
2006-06-27 12:30:00	SPY	ETF	124.33	124.36	124.13	124.28	3998400.0
2006-06-27 13:00:00	SPY	ETF	124.28	124.43	124.17	124.38	2679200.0
2006-06-27 13:30:00	SPY	ETF	124.39	124.44	124.22	124.33	2383000.0
2006-06-27 14:00:00	SPY	ETF	124.33	124.47	124.07	124.15	4847500.0
2006-06-27 14:30:00	SPY	ETF	124.15	124.25	123.83	124.0	5449000.0
2006-06-27 15:00:00	SPY	ETF	123.9905	124.35	123.99	124.1295	6488100.0
2006-06-27 15:30:00	SPY	ETF	124.14	124.25	123.77	123.87	6673500.0
2006-06-27 16:00:00	SPY	ETF	123.88	124.518	123.78	123.89	894200.0
2006-06-27 16:30:00	SPY	ETF	123.89	123.98	123.87	123.95	146600.0
2006-06-27 17:00:00	SPY	ETF	123.83	123.94	123.83	123.94	140600.0
2006-06-27 17:30:00	SPY	ETF	123.94	123.96	123.94	123.96	1800.0
2006-06-27 18:00:00	SPY	ETF	123.94	123.98	123.92	123.98	3100.0
2006-06-27 18:30:00	SPY	ETF	124.0	124.0	123.98	123.98	200.0
2006-06-27 19:00:00	SPY	ETF	123.98	123.99	123.98	123.99	53200.0
2006-06-27 09:30:00	QQQ	ETF	38.28	38.33	38.19	38.27	7875900.0
2006-06-27 10:00:00	QQQ	ETF	38.26	38.32	38.03	38.08	12016100.0
2006-06-27 10:30:00	QQQ	ETF	38.08	38.14	37.91	37.95	8234700.0
2006-06-27 11:00:00	QQQ	ETF	37.95	37.96	37.68	37.77	16517900.0
2006-06-27 11:30:00	QQQ	ETF	37.77	37.82	37.73	37.79	4708700.0
2006-06-27 12:00:00	QQQ	ETF	37.8	37.81	37.72	37.74	3392400.0
2006-06-27 12:30:00	QQQ	ETF	37.74	37.74	37.61	37.66	6877400.0
2006-06-27 13:00:00	QQQ	ETF	37.65	37.75	37.63	37.74	5368000.0
2006-06-27 13:30:00	QQQ	ETF	37.74	37.77	37.68	37.72	4110900.0
2006-06-27 14:00:00	QQQ	ETF	37.72	37.77	37.59	37.59	10277700.0
2006-06-27 14:30:00	QQQ	ETF	37.59	37.64	37.5	37.55	9432300.0
2006-06-27 15:00:00	QQQ	ETF	37.55	37.71	37.54	37.65	9097000.0
2006-06-27 15:30:00	QQQ	ETF	37.66	37.76	37.49	37.53	13647600.0
2006-06-27 08:00:00	IWM	ETF	69.37	69.47	69.36	69.43	34300.0
2006-06-27 08:30:00	IWM	ETF	69.45	69.46	69.42	69.45	62300.0
2006-06-27 09:00:00	IWM	ETF	69.51	69.55	69.39	69.52	124800.0
2006-06-27 09:30:00	IWM	ETF	69.54	69.79	69.54	69.69	4276500.0
2006-06-27 10:00:00	IWM	ETF	69.7	69.83	69.4	69.53	5388100.0
2006-06-27 10:30:00	IWM	ETF	69.5276	69.64	69.33	69.33	2365300.0
2006-06-27 11:00:00	IWM	ETF	69.3325	69.37	69.09	69.29	9047500.0
2006-06-27 11:30:00	IWM	ETF	69.29	69.32	69.07	69.19	4341300.0
2006-06-27 12:00:00	IWM	ETF	69.19	69.19	68.78	68.79	4609400.0
2006-06-27 12:30:00	IWM	ETF	68.78	68.86	68.54	68.67	4255500.0
2006-06-27 13:00:00	IWM	ETF	68.68	68.85	68.58	68.8	2382500.0
2006-06-27 13:30:00	IWM	ETF	68.8	68.87	68.7	68.74	1852300.0

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

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