PREVIEW / etf_30min / 2006-07-21

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-07-21.parquet
  size:    74 KB
  rows:    2,624

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-07-21 04:00:00	SPY	ETF	125.21	125.21	125.21	125.21	300.0
2006-07-21 05:30:00	SPY	ETF	125.25	125.25	125.25	125.25	6000.0
2006-07-21 06:00:00	SPY	ETF	125.3	125.3	125.3	125.3	9000.0
2006-07-21 06:30:00	SPY	ETF	125.25	125.25	125.19	125.19	103000.0
2006-07-21 07:00:00	SPY	ETF	125.21	125.22	125.14	125.14	145400.0
2006-07-21 07:30:00	SPY	ETF	125.04	125.06	124.87	124.87	243100.0
2006-07-21 08:00:00	SPY	ETF	124.87	125.29	124.84	124.94	2960500.0
2006-07-21 08:30:00	SPY	ETF	124.97	125.06	124.88	125.06	715500.0
2006-07-21 09:00:00	SPY	ETF	125.07	125.34	124.93	125.17	2177400.0
2006-07-21 09:30:00	SPY	ETF	125.15	125.17	124.14	124.43	12802600.0
2006-07-21 10:00:00	SPY	ETF	124.43	124.5	124.02	124.26	11720800.0
2006-07-21 10:30:00	SPY	ETF	124.25	124.86	124.12	124.65	10638100.0
2006-07-21 11:00:00	SPY	ETF	124.65	125.19	124.3	124.33	5646800.0
2006-07-21 11:30:00	SPY	ETF	124.33	124.7	124.29	124.57	3532500.0
2006-07-21 12:00:00	SPY	ETF	124.57	124.58	124.17	124.33	5921600.0
2006-07-21 12:30:00	SPY	ETF	124.34	124.47	123.87	124.08	9447500.0
2006-07-21 13:00:00	SPY	ETF	124.08	124.26	123.91	124.1	5087400.0
2006-07-21 13:30:00	SPY	ETF	124.1	124.49	124.07	124.32	4679100.0
2006-07-21 14:00:00	SPY	ETF	124.31	124.32	124.07	124.3	4200500.0
2006-07-21 14:30:00	SPY	ETF	124.3	124.31	123.99	124.06	4266100.0
2006-07-21 15:00:00	SPY	ETF	124.06	124.4	123.95	124.12	4532700.0
2006-07-21 15:30:00	SPY	ETF	124.11	124.29	124.06	124.09	7446300.0
2006-07-21 16:00:00	SPY	ETF	124.08	124.11	123.1896	123.97	2839100.0
2006-07-21 16:30:00	SPY	ETF	123.99	124.04	123.89	123.92	193600.0
2006-07-21 17:00:00	SPY	ETF	123.9	123.94	123.85	123.93	63200.0
2006-07-21 17:30:00	SPY	ETF	123.98	123.98	123.9	123.9	3400.0
2006-07-21 18:00:00	SPY	ETF	123.94	123.94	123.9	123.92	400.0
2006-07-21 18:30:00	SPY	ETF	123.92	123.92	123.92	123.92	3500.0
2006-07-21 19:00:00	SPY	ETF	123.91	123.91	123.91	123.91	300.0
2006-07-21 19:30:00	SPY	ETF	123.88	123.88	123.86	123.86	800.0
2006-07-21 09:30:00	QQQ	ETF	35.88	35.89	35.66	35.76	23102700.0
2006-07-21 10:00:00	QQQ	ETF	35.76	35.8	35.62	35.73	12443500.0
2006-07-21 10:30:00	QQQ	ETF	35.73	35.96	35.66	35.89	13630800.0
2006-07-21 11:00:00	QQQ	ETF	35.89	35.92	35.75	35.77	5653900.0
2006-07-21 11:30:00	QQQ	ETF	35.77	35.95	35.73	35.87	5882400.0
2006-07-21 12:00:00	QQQ	ETF	35.87	35.89	35.66	35.78	5133800.0
2006-07-21 12:30:00	QQQ	ETF	35.79	35.86	35.65	35.73	3881500.0
2006-07-21 13:00:00	QQQ	ETF	35.73	35.77	35.66	35.7	3227400.0
2006-07-21 13:30:00	QQQ	ETF	35.7	35.86	35.69	35.8	5273200.0
2006-07-21 14:00:00	QQQ	ETF	35.81	35.81	35.66	35.76	4627000.0
2006-07-21 14:30:00	QQQ	ETF	35.76	35.77	35.67	35.67	3545400.0
2006-07-21 15:00:00	QQQ	ETF	35.67	35.72	35.63	35.68	4499900.0
2006-07-21 15:30:00	QQQ	ETF	35.68	35.77	35.66	35.7	11475400.0
2006-07-21 07:30:00	IWM	ETF	67.85	67.85	67.85	67.85	1000.0
2006-07-21 08:00:00	IWM	ETF	67.72	67.76	67.64	67.68	245200.0
2006-07-21 08:30:00	IWM	ETF	67.68	67.88	67.47	67.55	1431700.0
2006-07-21 09:00:00	IWM	ETF	67.55	67.82	67.5	67.64	685100.0
2006-07-21 09:30:00	IWM	ETF	67.65	67.65	66.56	66.68	19227100.0
2006-07-21 10:00:00	IWM	ETF	66.69	66.79	66.35	66.6	18199500.0
2006-07-21 10:30:00	IWM	ETF	66.6	67.3	66.59	67.17	10783500.0

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

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