PREVIEW / etf_30min / 2007-08-16

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-08-16.parquet
  size:    149 KB
  rows:    5,310

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-08-16 04:00:00	SPY	ETF	140.31	140.31	140.31	140.31	1000.0
2007-08-16 04:30:00	SPY	ETF	140.28	140.28	140.09	140.09	1400.0
2007-08-16 05:00:00	SPY	ETF	139.99	139.99	139.67	139.67	700.0
2007-08-16 05:30:00	SPY	ETF	139.51	139.76	139.47	139.76	4200.0
2007-08-16 06:00:00	SPY	ETF	139.74	139.98	139.69	139.81	46800.0
2007-08-16 06:30:00	SPY	ETF	139.76	139.76	139.15	139.39	304400.0
2007-08-16 07:00:00	SPY	ETF	139.39	139.55	139.12	139.28	1631700.0
2007-08-16 07:30:00	SPY	ETF	139.25	139.6	139.05	139.35	1474000.0
2007-08-16 08:00:00	SPY	ETF	139.4	139.95	139.15	139.66	2982200.0
2007-08-16 08:30:00	SPY	ETF	139.66	140.3	139.4	140.06	7393600.0
2007-08-16 09:00:00	SPY	ETF	140.06	140.25	139.65	139.79	5056719.0
2007-08-16 09:30:00	SPY	ETF	139.79	140.77	139.5	139.71	46996423.0
2007-08-16 10:00:00	SPY	ETF	139.69	139.83	138.93	138.94	35042896.0
2007-08-16 10:30:00	SPY	ETF	138.94	140.45	137.0	139.52	33064640.0
2007-08-16 11:00:00	SPY	ETF	139.52	140.46	139.2	139.55	30612136.0
2007-08-16 11:30:00	SPY	ETF	139.55	140.1	138.74	139.12	21417136.0
2007-08-16 12:00:00	SPY	ETF	139.11	139.15	137.77	138.36	40925074.0
2007-08-16 12:30:00	SPY	ETF	138.35	138.67	137.34	137.55	30429346.0
2007-08-16 13:00:00	SPY	ETF	137.55	139.0	137.25	138.39	38650848.0
2007-08-16 13:30:00	SPY	ETF	138.38	139.64	138.34	139.28	31610305.0
2007-08-16 14:00:00	SPY	ETF	139.29	140.75	138.89	139.95	48982387.0
2007-08-16 14:30:00	SPY	ETF	139.95	140.21	138.89	139.68	31130272.0
2007-08-16 15:00:00	SPY	ETF	139.68	139.77	137.93	139.68	53623792.0
2007-08-16 15:30:00	SPY	ETF	139.68	141.93	139.56	141.73	57107795.0
2007-08-16 16:00:00	SPY	ETF	141.64	142.99	137.54	142.28	9453500.0
2007-08-16 16:30:00	SPY	ETF	142.23	142.66	142.19	142.63	2884600.0
2007-08-16 17:00:00	SPY	ETF	142.6	142.75	140.6	142.58	2113400.0
2007-08-16 17:30:00	SPY	ETF	142.55	142.55	142.1	142.47	167600.0
2007-08-16 18:00:00	SPY	ETF	142.5	142.78	142.47	142.66	250400.0
2007-08-16 18:30:00	SPY	ETF	142.68	142.7	142.47	142.51	36700.0
2007-08-16 19:00:00	SPY	ETF	142.48	142.52	139.433	142.49	257300.0
2007-08-16 19:30:00	SPY	ETF	142.51	142.56	142.43	142.54	6700.0
2007-08-16 05:00:00	QQQ	ETF	45.6	45.6	45.56	45.56	400.0
2007-08-16 05:30:00	QQQ	ETF	45.52	45.55	45.52	45.55	10200.0
2007-08-16 06:30:00	QQQ	ETF	45.6	45.6	45.44	45.49	72800.0
2007-08-16 07:00:00	QQQ	ETF	45.46	45.47	45.33	45.38	908106.0
2007-08-16 07:30:00	QQQ	ETF	45.37	45.54	45.35	45.5	709028.0
2007-08-16 08:00:00	QQQ	ETF	45.49	45.56	45.43	45.55	1659434.0
2007-08-16 08:30:00	QQQ	ETF	45.56	45.69	45.5	45.65	1313722.0
2007-08-16 09:00:00	QQQ	ETF	45.65	45.65	45.53	45.55	1605521.0
2007-08-16 09:30:00	QQQ	ETF	45.54	45.91	45.47	45.47	28587300.0
2007-08-16 10:00:00	QQQ	ETF	45.48	45.51	45.18	45.18	21365726.0
2007-08-16 10:30:00	QQQ	ETF	45.18	45.52	45.12	45.3489	19051204.0
2007-08-16 11:00:00	QQQ	ETF	45.341	45.68	45.33	45.38	17659621.0
2007-08-16 11:30:00	QQQ	ETF	45.38	45.49	45.03	45.16	19109028.0
2007-08-16 12:00:00	QQQ	ETF	45.16	45.17	44.7	44.78	25888849.0
2007-08-16 12:30:00	QQQ	ETF	44.7789	44.87	44.41	44.5	23502251.0
2007-08-16 13:00:00	QQQ	ETF	44.5	44.9	44.39	44.731	22388622.0
2007-08-16 13:30:00	QQQ	ETF	44.7301	45.11	44.71	44.98	26853579.0
2007-08-16 14:00:00	QQQ	ETF	44.98	45.43	44.8	45.08	28572656.0

> showing 50 of 5,310 rows — these rows as CSV

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