PREVIEW / etf_30min / 2007-06-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-18.parquet
  size:    112 KB
  rows:    4,418

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-06-18 05:30:00	SPY	ETF	153.52	153.52	153.52	153.52	1900.0
2007-06-18 06:30:00	SPY	ETF	153.34	153.34	153.34	153.34	4300.0
2007-06-18 07:00:00	SPY	ETF	153.37	153.41	153.32	153.4	190200.0
2007-06-18 07:30:00	SPY	ETF	153.4	153.4	153.29	153.31	214100.0
2007-06-18 08:00:00	SPY	ETF	153.29	153.44	153.29	153.36	658600.0
2007-06-18 08:30:00	SPY	ETF	153.39	153.51	153.39	153.46	542900.0
2007-06-18 09:00:00	SPY	ETF	153.45	153.48	153.36	153.36	234600.0
2007-06-18 09:30:00	SPY	ETF	153.36	153.39	153.11	153.18	9835466.0
2007-06-18 10:00:00	SPY	ETF	153.18	153.19	152.66	152.86	15943921.0
2007-06-18 10:30:00	SPY	ETF	152.8599	153.0	152.82	152.9	6556676.0
2007-06-18 11:00:00	SPY	ETF	152.9	153.12	152.77	153.05	4481701.0
2007-06-18 11:30:00	SPY	ETF	153.045	153.12	152.99	153.04	3102779.0
2007-06-18 12:00:00	SPY	ETF	153.05	153.06	152.93	152.93	3393200.0
2007-06-18 12:30:00	SPY	ETF	152.94	153.21	152.93	153.17	5520213.0
2007-06-18 13:00:00	SPY	ETF	153.16	153.21	153.0	153.1	4691139.0
2007-06-18 13:30:00	SPY	ETF	153.1	153.17	152.87	153.0	4510801.0
2007-06-18 14:00:00	SPY	ETF	153.0	153.13	152.83	153.07	4905821.0
2007-06-18 14:30:00	SPY	ETF	153.08	153.1	152.91	153.06	3130968.0
2007-06-18 15:00:00	SPY	ETF	153.06	153.1	152.9	152.97	5298818.0
2007-06-18 15:30:00	SPY	ETF	152.96	153.0541	152.79	152.9	7735458.0
2007-06-18 16:00:00	SPY	ETF	152.91	153.36	152.8	152.81	1960100.0
2007-06-18 16:30:00	SPY	ETF	152.81	152.89	152.6	152.62	3201600.0
2007-06-18 17:00:00	SPY	ETF	152.65	152.68	152.6	152.65	140500.0
2007-06-18 17:30:00	SPY	ETF	152.62	152.68	152.62	152.67	9400.0
2007-06-18 18:00:00	SPY	ETF	152.68	152.75	152.67	152.71	15400.0
2007-06-18 18:30:00	SPY	ETF	152.68	152.68	152.68	152.68	600.0
2007-06-18 19:00:00	SPY	ETF	152.67	152.67	152.67	152.67	500.0
2007-06-18 19:30:00	SPY	ETF	152.67	152.73	152.67	152.73	600.0
2007-06-18 04:00:00	QQQ	ETF	47.85	47.85	47.85	47.85	1000.0
2007-06-18 04:30:00	QQQ	ETF	47.9	47.9	47.9	47.9	200.0
2007-06-18 07:00:00	QQQ	ETF	47.78	47.82	47.78	47.81	58100.0
2007-06-18 07:30:00	QQQ	ETF	47.81	47.81	47.76	47.78	236444.0
2007-06-18 08:00:00	QQQ	ETF	47.78	47.82	47.78	47.82	524584.0
2007-06-18 08:30:00	QQQ	ETF	47.82	47.87	47.81	47.86	442839.0
2007-06-18 09:00:00	QQQ	ETF	47.87	47.88	47.85	47.86	371842.0
2007-06-18 09:30:00	QQQ	ETF	47.85	47.86	47.75	47.83	9392229.0
2007-06-18 10:00:00	QQQ	ETF	47.82	47.83	47.67	47.75	8040042.0
2007-06-18 10:30:00	QQQ	ETF	47.75	47.82	47.73	47.76	5902655.0
2007-06-18 11:00:00	QQQ	ETF	47.76	47.83	47.7	47.7892	5947820.0
2007-06-18 11:30:00	QQQ	ETF	47.781	47.8	47.77	47.78	1950564.0
2007-06-18 12:00:00	QQQ	ETF	47.79	47.79	47.74	47.75	1733244.0
2007-06-18 12:30:00	QQQ	ETF	47.74	47.87	47.74	47.86	2093364.0
2007-06-18 13:00:00	QQQ	ETF	47.86	47.87	47.81	47.83	2367079.0
2007-06-18 13:30:00	QQQ	ETF	47.8314	47.86	47.74	47.77	4257246.0
2007-06-18 14:00:00	QQQ	ETF	47.78	47.8	47.72	47.79	3876719.0
2007-06-18 14:30:00	QQQ	ETF	47.79	47.81	47.75	47.8	2589268.0
2007-06-18 15:00:00	QQQ	ETF	47.8	47.86	47.78	47.84	3588970.0
2007-06-18 15:30:00	QQQ	ETF	47.8393	47.86	47.79	47.8	8347197.0
2007-06-18 16:00:00	QQQ	ETF	47.8	47.83	47.75	47.79	5117120.0
2007-06-18 16:30:00	QQQ	ETF	47.78	47.78	47.6	47.65	2929552.0

> showing 50 of 4,418 rows — these rows as CSV

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