PREVIEW / etf_30min / 2001-07-19

all etf 30-min files

  file:    by_date/etf_30min/2001/2001-07-19.parquet
  size:    15 KB
  rows:    362

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
2001-07-19 09:30:00	SPY	ETF	122.18	122.88	122.05	122.82	1596800.0
2001-07-19 10:00:00	SPY	ETF	122.86	122.98	122.42	122.52	549500.0
2001-07-19 10:30:00	SPY	ETF	122.57	122.68	122.26	122.64	1166100.0
2001-07-19 11:00:00	SPY	ETF	122.64	122.93	122.5	122.53	479800.0
2001-07-19 11:30:00	SPY	ETF	122.55	122.7	122.03	122.16	441100.0
2001-07-19 12:00:00	SPY	ETF	122.16	122.16	121.87	121.99	666800.0
2001-07-19 12:30:00	SPY	ETF	121.99	122.09	121.63	121.95	384400.0
2001-07-19 13:00:00	SPY	ETF	121.95	122.3	121.9	122.19	281300.0
2001-07-19 13:30:00	SPY	ETF	122.15	122.39	121.83	122.0	213000.0
2001-07-19 14:00:00	SPY	ETF	122.04	122.1	121.62	121.9	381600.0
2001-07-19 14:30:00	SPY	ETF	121.87	122.0	121.2	121.37	651600.0
2001-07-19 15:00:00	SPY	ETF	121.33	121.41	120.76	121.24	1257200.0
2001-07-19 15:30:00	SPY	ETF	121.24	121.84	121.16	121.83	614600.0
2001-07-19 16:00:00	SPY	ETF	121.87	122.13	121.55	121.55	477000.0
2001-07-19 16:30:00	SPY	ETF	121.65	121.65	121.32	121.37	510900.0
2001-07-19 17:00:00	SPY	ETF	121.36	121.5	121.18	121.35	10000.0
2001-07-19 17:30:00	SPY	ETF	121.15	121.15	121.15	121.15	50000.0
2001-07-19 18:00:00	SPY	ETF	121.0	121.0	121.0	121.0	100.0
2001-07-19 09:30:00	QQQ	ETF	42.46	43.17	42.4	43.1	10418200.0
2001-07-19 10:00:00	QQQ	ETF	43.1	43.22	42.85	42.95	7596700.0
2001-07-19 10:30:00	QQQ	ETF	42.91	43.14	42.75	43.1	4082900.0
2001-07-19 11:00:00	QQQ	ETF	43.08	43.35	43.03	43.09	6512000.0
2001-07-19 11:30:00	QQQ	ETF	43.09	43.2	42.85	42.89	2659700.0
2001-07-19 12:00:00	QQQ	ETF	42.89	42.92	42.66	42.68	4093100.0
2001-07-19 12:30:00	QQQ	ETF	42.67	42.8	42.54	42.73	4015600.0
2001-07-19 13:00:00	QQQ	ETF	42.7	42.94	42.62	42.74	2431400.0
2001-07-19 13:30:00	QQQ	ETF	42.72	42.82	42.4	42.49	4702700.0
2001-07-19 14:00:00	QQQ	ETF	42.49	42.49	42.09	42.32	4605600.0
2001-07-19 14:30:00	QQQ	ETF	42.31	42.49	42.0	42.07	4302100.0
2001-07-19 15:00:00	QQQ	ETF	42.1	42.12	41.75	42.0	7182900.0
2001-07-19 15:30:00	QQQ	ETF	41.99	42.27	41.93	42.25	6090900.0
2001-07-19 16:00:00	QQQ	ETF	42.25	42.75	41.87	41.99	2504800.0
2001-07-19 16:30:00	QQQ	ETF	42.1	42.39	41.7	41.8	1574000.0
2001-07-19 17:00:00	QQQ	ETF	41.83	41.83	41.45	41.5	740700.0
2001-07-19 17:30:00	QQQ	ETF	41.46	41.7	41.43	41.6	397100.0
2001-07-19 18:00:00	QQQ	ETF	41.63	41.8	41.49	41.58	93600.0
2001-07-19 09:30:00	IWM	ETF	48.6	48.9	48.6	48.86	11200.0
2001-07-19 10:00:00	IWM	ETF	48.85	48.87	48.8	48.85	5200.0
2001-07-19 10:30:00	IWM	ETF	48.7	48.845	48.7	48.845	6400.0
2001-07-19 11:00:00	IWM	ETF	48.845	49.085	48.8	48.995	18600.0
2001-07-19 11:30:00	IWM	ETF	48.875	48.9	48.755	48.805	6800.0
2001-07-19 12:00:00	IWM	ETF	48.785	48.82	48.75	48.81	7200.0
2001-07-19 12:30:00	IWM	ETF	48.705	48.71	48.64	48.64	10200.0
2001-07-19 13:00:00	IWM	ETF	48.72	48.72	48.72	48.72	1600.0
2001-07-19 13:30:00	IWM	ETF	48.73	48.75	48.625	48.625	22000.0
2001-07-19 14:00:00	IWM	ETF	48.6	48.6	48.485	48.49	7800.0
2001-07-19 14:30:00	IWM	ETF	48.495	48.57	48.4	48.425	18400.0
2001-07-19 15:00:00	IWM	ETF	48.35	48.4	48.25	48.38	113200.0
2001-07-19 15:30:00	IWM	ETF	48.375	48.65	48.36	48.56	94400.0
2001-07-19 16:00:00	IWM	ETF	48.62	48.675	48.5	48.5	93000.0

> showing 50 of 362 rows — these rows as CSV

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