PREVIEW / etf_30min / 2005-06-27

all etf 30-min files

  file:    by_date/etf_30min/2005/2005-06-27.parquet
  size:    43 KB
  rows:    1,580

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-06-27 07:00:00	SPY	ETF	118.93	118.93	118.87	118.93	48500.0
2005-06-27 07:30:00	SPY	ETF	118.95	118.95	118.92	118.93	58500.0
2005-06-27 08:00:00	SPY	ETF	118.94	118.97	118.93	118.93	9000.0
2005-06-27 08:30:00	SPY	ETF	118.95	118.95	118.91	118.93	56700.0
2005-06-27 09:00:00	SPY	ETF	118.93	118.96	118.87	118.96	47800.0
2005-06-27 09:30:00	SPY	ETF	118.97	119.24	118.95	119.12	6789900.0
2005-06-27 10:00:00	SPY	ETF	119.12	119.3	118.97	119.24	4047500.0
2005-06-27 10:30:00	SPY	ETF	119.23	119.38	119.16	119.19	3814200.0
2005-06-27 11:00:00	SPY	ETF	119.19	119.28	119.01	119.23	3397800.0
2005-06-27 11:30:00	SPY	ETF	119.22	119.27	119.05	119.21	3276100.0
2005-06-27 12:00:00	SPY	ETF	119.22	119.41	119.19	119.3	2321300.0
2005-06-27 12:30:00	SPY	ETF	119.32	119.36	119.06	119.1	3250800.0
2005-06-27 13:00:00	SPY	ETF	119.09	119.32	118.99	119.15	2427300.0
2005-06-27 13:30:00	SPY	ETF	119.13	119.22	118.77	118.78	2792300.0
2005-06-27 14:00:00	SPY	ETF	118.78	119.02	118.75	118.9	4296400.0
2005-06-27 14:30:00	SPY	ETF	118.9	119.05	118.87	118.98	1973800.0
2005-06-27 15:00:00	SPY	ETF	118.98	119.23	118.92	119.15	4226200.0
2005-06-27 15:30:00	SPY	ETF	119.16	119.22	119.03	119.04	4706600.0
2005-06-27 16:00:00	SPY	ETF	119.05	119.21	118.92	119.13	2506600.0
2005-06-27 16:30:00	SPY	ETF	119.13	119.15	119.11	119.12	232100.0
2005-06-27 17:00:00	SPY	ETF	119.11	119.13	119.09	119.13	14400.0
2005-06-27 17:30:00	SPY	ETF	119.12	119.12	119.12	119.12	900.0
2005-06-27 18:00:00	SPY	ETF	119.12	119.12	119.1	119.12	1000.0
2005-06-27 18:30:00	SPY	ETF	119.1	119.12	119.1	119.12	1300.0
2005-06-27 19:30:00	SPY	ETF	119.15	119.15	119.15	119.15	500.0
2005-06-27 09:30:00	QQQ	ETF	36.94	37.06	36.89	36.97	10772800.0
2005-06-27 10:00:00	QQQ	ETF	36.98	37.0	36.87	36.96	5612000.0
2005-06-27 10:30:00	QQQ	ETF	36.97	37.05	36.92	36.95	4126700.0
2005-06-27 11:00:00	QQQ	ETF	36.95	36.98	36.9	36.96	4698000.0
2005-06-27 11:30:00	QQQ	ETF	36.96	36.98	36.88	36.95	4084500.0
2005-06-27 12:00:00	QQQ	ETF	36.96	37.03	36.89	36.96	3349700.0
2005-06-27 12:30:00	QQQ	ETF	36.96	36.97	36.84	36.87	3797400.0
2005-06-27 13:00:00	QQQ	ETF	36.87	36.9	36.8	36.88	4611000.0
2005-06-27 13:30:00	QQQ	ETF	36.88	36.89	36.73	36.73	4960800.0
2005-06-27 14:00:00	QQQ	ETF	36.74	36.78	36.7	36.72	4652100.0
2005-06-27 14:30:00	QQQ	ETF	36.73	36.78	36.71	36.75	3205200.0
2005-06-27 15:00:00	QQQ	ETF	36.76	36.87	36.72	36.85	6226300.0
2005-06-27 15:30:00	QQQ	ETF	36.85	36.87	36.77	36.78	6084200.0
2005-06-27 07:00:00	IWM	ETF	62.14	62.14	62.14	62.14	100.0
2005-06-27 08:30:00	IWM	ETF	62.2	62.2	62.19	62.19	1000.0
2005-06-27 09:00:00	IWM	ETF	62.2	62.23	62.2	62.2	4200.0
2005-06-27 09:30:00	IWM	ETF	62.28	62.47	62.22	62.25	2792100.0
2005-06-27 10:00:00	IWM	ETF	62.254	62.31	62.1	62.28	1921300.0
2005-06-27 10:30:00	IWM	ETF	62.3	62.44	62.25	62.29	1011700.0
2005-06-27 11:00:00	IWM	ETF	62.29	62.49	62.22	62.45	3768800.0
2005-06-27 11:30:00	IWM	ETF	62.44	62.48	62.34	62.43	2427000.0
2005-06-27 12:00:00	IWM	ETF	62.43	62.59	62.43	62.53	448600.0
2005-06-27 12:30:00	IWM	ETF	62.52	62.53	62.36	62.39	744100.0
2005-06-27 13:00:00	IWM	ETF	62.39	62.5	62.32	62.5	622600.0
2005-06-27 13:30:00	IWM	ETF	62.49	62.5	62.17	62.18	671400.0

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

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