PREVIEW / etf_30min / 2005-04-27

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-04-27.parquet
  size:    45 KB
  rows:    1,494

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
2005-04-27 05:30:00	SPY	ETF	115.15	115.15	115.15	115.15	2400.0
2005-04-27 06:30:00	SPY	ETF	115.15	115.15	115.0	115.0	5500.0
2005-04-27 07:00:00	SPY	ETF	115.07	115.07	114.97	115.07	17600.0
2005-04-27 07:30:00	SPY	ETF	115.05	115.08	115.05	115.05	19900.0
2005-04-27 08:00:00	SPY	ETF	115.08	115.2	115.08	115.14	66700.0
2005-04-27 08:30:00	SPY	ETF	115.12	115.12	114.87	114.9	482800.0
2005-04-27 09:00:00	SPY	ETF	114.89	114.92	114.75	114.82	387500.0
2005-04-27 09:30:00	SPY	ETF	114.86	115.0	114.55	114.62	9797600.0
2005-04-27 10:00:00	SPY	ETF	114.61	114.67	114.44	114.62	6303500.0
2005-04-27 10:30:00	SPY	ETF	114.62	115.07	114.61	114.91	9909200.0
2005-04-27 11:00:00	SPY	ETF	114.91	115.31	114.71	115.23	5427300.0
2005-04-27 11:30:00	SPY	ETF	115.22	115.4	115.1	115.37	7126900.0
2005-04-27 12:00:00	SPY	ETF	115.38	115.79	115.37	115.57	7529300.0
2005-04-27 12:30:00	SPY	ETF	115.57	115.66	115.44	115.6	2600800.0
2005-04-27 13:00:00	SPY	ETF	115.58	116.07	115.55	115.86	6429500.0
2005-04-27 13:30:00	SPY	ETF	115.86	115.96	115.71	115.86	4547700.0
2005-04-27 14:00:00	SPY	ETF	115.85	115.93	115.63	115.77	3808300.0
2005-04-27 14:30:00	SPY	ETF	115.78	115.86	115.58	115.86	3954100.0
2005-04-27 15:00:00	SPY	ETF	115.85	115.96	115.63	115.66	5424600.0
2005-04-27 15:30:00	SPY	ETF	115.64	115.8	115.51	115.68	6966400.0
2005-04-27 16:00:00	SPY	ETF	115.67	115.77	115.63	115.69	1293500.0
2005-04-27 16:30:00	SPY	ETF	115.73	115.75	115.65	115.68	110600.0
2005-04-27 17:00:00	SPY	ETF	115.65	115.68	115.63	115.67	10900.0
2005-04-27 17:30:00	SPY	ETF	115.67	115.71	115.66	115.71	820100.0
2005-04-27 18:00:00	SPY	ETF	115.71	115.72	115.67	115.72	3800.0
2005-04-27 18:30:00	SPY	ETF	115.71	115.71	115.71	115.71	500.0
2005-04-27 09:30:00	QQQ	ETF	34.87	34.95	34.78	34.83	19218000.0
2005-04-27 10:00:00	QQQ	ETF	34.82	34.84	34.73	34.82	12726100.0
2005-04-27 10:30:00	QQQ	ETF	34.82	35.01	34.82	34.96	11840900.0
2005-04-27 11:00:00	QQQ	ETF	34.96	35.07	34.85	35.04	7677800.0
2005-04-27 11:30:00	QQQ	ETF	35.04	35.08	34.95	35.05	6279300.0
2005-04-27 12:00:00	QQQ	ETF	35.05	35.18	35.04	35.09	7358300.0
2005-04-27 12:30:00	QQQ	ETF	35.09	35.11	35.02	35.08	3103200.0
2005-04-27 13:00:00	QQQ	ETF	35.08	35.25	34.8	35.16	7648400.0
2005-04-27 13:30:00	QQQ	ETF	35.15	35.2	35.1	35.16	3330100.0
2005-04-27 14:00:00	QQQ	ETF	35.16	35.17	35.04	35.13	4993300.0
2005-04-27 14:30:00	QQQ	ETF	35.12	35.19	35.05	35.18	4774600.0
2005-04-27 15:00:00	QQQ	ETF	35.19	35.21	35.07	35.08	7175200.0
2005-04-27 15:30:00	QQQ	ETF	35.08	35.14	35.05	35.1	5143300.0
2005-04-27 08:00:00	IWM	ETF	58.245	58.245	58.245	58.245	1000.0
2005-04-27 08:30:00	IWM	ETF	58.08	58.135	58.065	58.105	24200.0
2005-04-27 09:00:00	IWM	ETF	58.105	58.105	57.98	58.05	67800.0
2005-04-27 09:30:00	IWM	ETF	58.125	58.185	57.78	57.82	3815200.0
2005-04-27 10:00:00	IWM	ETF	57.815	57.84	57.615	57.835	3157000.0
2005-04-27 10:30:00	IWM	ETF	57.84	58.09	57.745	57.97	3490400.0
2005-04-27 11:00:00	IWM	ETF	57.97	58.065	57.705	57.995	1711400.0
2005-04-27 11:30:00	IWM	ETF	57.995	58.24	57.905	58.225	2565400.0
2005-04-27 12:00:00	IWM	ETF	58.24	58.6	58.24	58.5	2804200.0
2005-04-27 12:30:00	IWM	ETF	58.5	58.555	58.43	58.475	922200.0
2005-04-27 13:00:00	IWM	ETF	58.47	58.79	58.375	58.62	1840400.0

> showing 50 of 1,494 rows — these rows as CSV

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