PREVIEW / etf_30min / 2007-10-18

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-18.parquet
  size:    127 KB
  rows:    4,767

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-10-18 04:00:00	SPY	ETF	154.15	154.15	154.15	154.15	200.0
2007-10-18 04:30:00	SPY	ETF	154.18	154.18	154.18	154.18	2000.0
2007-10-18 06:00:00	SPY	ETF	154.4	154.4	154.4	154.4	3000.0
2007-10-18 06:30:00	SPY	ETF	154.5	154.5	154.3	154.4	17200.0
2007-10-18 07:00:00	SPY	ETF	154.32	154.35	153.39	153.51	1285000.0
2007-10-18 07:30:00	SPY	ETF	153.5	153.71	153.5	153.56	707000.0
2007-10-18 08:00:00	SPY	ETF	153.6	153.79	153.24	153.25	3423400.0
2007-10-18 08:30:00	SPY	ETF	153.28	153.46	153.16	153.28	2754100.0
2007-10-18 09:00:00	SPY	ETF	153.3	153.44	153.27	153.44	784800.0
2007-10-18 09:30:00	SPY	ETF	153.45	153.68	153.25	153.38	13054112.0
2007-10-18 10:00:00	SPY	ETF	153.38	153.91	153.08	153.9	17413865.0
2007-10-18 10:30:00	SPY	ETF	153.9	153.9	153.49	153.59	8396200.0
2007-10-18 11:00:00	SPY	ETF	153.58	153.8	153.22	153.39	9028400.0
2007-10-18 11:30:00	SPY	ETF	153.38	153.64	153.34	153.45	7119400.0
2007-10-18 12:00:00	SPY	ETF	153.45	153.53	153.16	153.38	6777400.0
2007-10-18 12:30:00	SPY	ETF	153.38	153.63	153.31	153.38	5829250.0
2007-10-18 13:00:00	SPY	ETF	153.38	153.55	153.21	153.5	5587421.0
2007-10-18 13:30:00	SPY	ETF	153.5	154.03	153.47	153.97	11528700.0
2007-10-18 14:00:00	SPY	ETF	153.96	154.19	153.78	153.825	9956400.0
2007-10-18 14:30:00	SPY	ETF	153.825	153.95	153.53	153.66	13104258.0
2007-10-18 15:00:00	SPY	ETF	153.66	154.09	153.65	153.78	7738700.0
2007-10-18 15:30:00	SPY	ETF	153.77	154.15	153.7	153.82	8263600.0
2007-10-18 16:00:00	SPY	ETF	153.84	154.02	153.69	153.79	5099200.0
2007-10-18 16:30:00	SPY	ETF	153.76	153.91	153.69	153.78	5883300.0
2007-10-18 17:00:00	SPY	ETF	153.77	154.0	153.73	154.0	1764900.0
2007-10-18 17:30:00	SPY	ETF	153.93	154.0	153.75	153.94	130600.0
2007-10-18 18:00:00	SPY	ETF	153.9	153.94	153.69	153.91	178300.0
2007-10-18 18:30:00	SPY	ETF	153.88	153.93	153.81	153.91	83500.0
2007-10-18 19:00:00	SPY	ETF	153.89	153.9	153.88	153.88	7500.0
2007-10-18 19:30:00	SPY	ETF	153.88	153.9	153.88	153.88	2000.0
2007-10-18 04:30:00	QQQ	ETF	53.55	53.55	53.55	53.55	900.0
2007-10-18 05:00:00	QQQ	ETF	53.6	53.6	53.6	53.6	5000.0
2007-10-18 06:00:00	QQQ	ETF	53.64	53.68	53.64	53.67	4400.0
2007-10-18 06:30:00	QQQ	ETF	53.67	53.67	53.64	53.65	2900.0
2007-10-18 07:00:00	QQQ	ETF	53.6	53.6	53.36	53.42	1238998.0
2007-10-18 07:30:00	QQQ	ETF	53.43	53.44	53.37	53.38	357791.0
2007-10-18 08:00:00	QQQ	ETF	53.39	53.66	53.3	53.32	1994273.0
2007-10-18 08:30:00	QQQ	ETF	53.32	53.34	53.22	53.26	3823663.0
2007-10-18 09:00:00	QQQ	ETF	53.25	53.36	53.23	53.34	429453.0
2007-10-18 09:30:00	QQQ	ETF	53.34	53.45	53.181	53.27	12127647.0
2007-10-18 10:00:00	QQQ	ETF	53.27	53.48	53.12	53.4789	13101977.0
2007-10-18 10:30:00	QQQ	ETF	53.4789	53.49	53.29	53.328	7818172.0
2007-10-18 11:00:00	QQQ	ETF	53.32	53.38	53.15	53.22	6659929.0
2007-10-18 11:30:00	QQQ	ETF	53.23	53.36	53.23	53.3	3505893.0
2007-10-18 12:00:00	QQQ	ETF	53.3	53.34	53.23	53.31	3091589.0
2007-10-18 12:30:00	QQQ	ETF	53.31	53.41	53.2896	53.35	4491986.0
2007-10-18 13:00:00	QQQ	ETF	53.35	53.39	53.25	53.38	7456921.0
2007-10-18 13:30:00	QQQ	ETF	53.375	53.76	53.37	53.73	13106834.0
2007-10-18 14:00:00	QQQ	ETF	53.73	53.88	53.69	53.71	12306391.0
2007-10-18 14:30:00	QQQ	ETF	53.71	53.75	53.64	53.68	6773918.0

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

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