PREVIEW / etf_30min / 2007-04-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-16.parquet
  size:    108 KB
  rows:    3,833

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
2007-04-16 06:00:00	SPY	ETF	145.62	145.62	145.62	145.62	17500.0
2007-04-16 06:30:00	SPY	ETF	145.6	145.6	145.6	145.6	1100.0
2007-04-16 07:00:00	SPY	ETF	145.59	145.74	145.59	145.66	393900.0
2007-04-16 07:30:00	SPY	ETF	145.68	145.72	145.66	145.71	185400.0
2007-04-16 08:00:00	SPY	ETF	145.7	145.8	145.5	145.72	1352600.0
2007-04-16 08:30:00	SPY	ETF	145.74	145.9	145.69	145.83	1107300.0
2007-04-16 09:00:00	SPY	ETF	145.83	145.94	145.8	145.86	1096800.0
2007-04-16 09:30:00	SPY	ETF	145.87	146.35	145.82	146.19	14482083.0
2007-04-16 10:00:00	SPY	ETF	146.19	146.36	146.12	146.18	7958124.0
2007-04-16 10:30:00	SPY	ETF	146.18	146.52	146.14	146.41	6199746.0
2007-04-16 11:00:00	SPY	ETF	146.42	146.53	146.28	146.48	4204756.0
2007-04-16 11:30:00	SPY	ETF	146.49	146.86	146.47	146.75	10025660.0
2007-04-16 12:00:00	SPY	ETF	146.75	146.78	146.65	146.66	2831412.0
2007-04-16 12:30:00	SPY	ETF	146.67	146.7	146.57	146.58	2487850.0
2007-04-16 13:00:00	SPY	ETF	146.5701	146.67	146.53	146.65	2481412.0
2007-04-16 13:30:00	SPY	ETF	146.66	146.71	146.48	146.5	2725296.0
2007-04-16 14:00:00	SPY	ETF	146.49	146.58	146.41	146.5	4228801.0
2007-04-16 14:30:00	SPY	ETF	146.49	146.66	146.48	146.63	3554472.0
2007-04-16 15:00:00	SPY	ETF	146.63	146.77	146.62	146.72	5479392.0
2007-04-16 15:30:00	SPY	ETF	146.72	146.8	146.69	146.78	6720314.0
2007-04-16 16:00:00	SPY	ETF	146.78	146.82	146.62	146.68	3312400.0
2007-04-16 16:30:00	SPY	ETF	146.68	146.7	146.56	146.65	1124300.0
2007-04-16 17:00:00	SPY	ETF	146.63	146.65	146.59	146.64	73900.0
2007-04-16 17:30:00	SPY	ETF	146.63	146.7	146.62	146.69	140700.0
2007-04-16 18:00:00	SPY	ETF	146.69	146.69	146.69	146.69	500.0
2007-04-16 18:30:00	SPY	ETF	146.66	146.66	146.65	146.65	1500.0
2007-04-16 19:30:00	SPY	ETF	146.69	146.69	146.68	146.68	4500.0
2007-04-16 07:00:00	QQQ	ETF	44.79	44.82	44.79	44.82	23800.0
2007-04-16 07:30:00	QQQ	ETF	44.81	44.85	44.8	44.82	84149.0
2007-04-16 08:00:00	QQQ	ETF	44.82	44.87	44.8	44.81	135571.0
2007-04-16 08:30:00	QQQ	ETF	44.82	44.88	44.79	44.85	584507.0
2007-04-16 09:00:00	QQQ	ETF	44.84	44.87	44.83	44.85	470677.0
2007-04-16 09:30:00	QQQ	ETF	44.82	45.0	44.82	44.94	13333500.0
2007-04-16 10:00:00	QQQ	ETF	44.93	44.95	44.85	44.88	6634700.0
2007-04-16 10:30:00	QQQ	ETF	44.88	45.0	44.87	44.97	5088900.0
2007-04-16 11:00:00	QQQ	ETF	44.96	44.99	44.93	44.96	4145600.0
2007-04-16 11:30:00	QQQ	ETF	44.95	45.15	44.95	45.08	8660300.0
2007-04-16 12:00:00	QQQ	ETF	45.07	45.09	45.02	45.02	2860200.0
2007-04-16 12:30:00	QQQ	ETF	45.03	45.06	44.99	45.0	3129800.0
2007-04-16 13:00:00	QQQ	ETF	45.0	45.08	44.98	45.04	4091700.0
2007-04-16 13:30:00	QQQ	ETF	45.03	45.05	44.96	44.96	1784000.0
2007-04-16 14:00:00	QQQ	ETF	44.97	44.99	44.94	44.98	3359600.0
2007-04-16 14:30:00	QQQ	ETF	44.98	45.03	44.96	45.01	2307100.0
2007-04-16 15:00:00	QQQ	ETF	45.01	45.08	45.01	45.05	3769700.0
2007-04-16 15:30:00	QQQ	ETF	45.05	45.08	44.99	45.08	6977500.0
2007-04-16 16:00:00	QQQ	ETF	45.08	45.1	45.05	45.09	3287471.0
2007-04-16 16:30:00	QQQ	ETF	45.08	45.1	45.07	45.1	626611.0
2007-04-16 17:00:00	QQQ	ETF	45.08	45.09	45.07	45.09	140900.0
2007-04-16 17:30:00	QQQ	ETF	45.09	45.1	45.08	45.09	1650745.0
2007-04-16 18:00:00	QQQ	ETF	45.09	45.09	45.08	45.09	12000.0

> showing 50 of 3,833 rows — these rows as CSV

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