PREVIEW / etf_30min / 2008-08-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-04.parquet
  size:    166 KB
  rows:    5,756

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
2008-08-04 04:30:00	SPY	ETF	126.25	126.25	126.25	126.25	100.0
2008-08-04 05:00:00	SPY	ETF	126.2	126.2	126.2	126.2	100.0
2008-08-04 05:30:00	SPY	ETF	125.92	125.92	125.87	125.87	200.0
2008-08-04 06:00:00	SPY	ETF	125.85	125.85	125.85	125.85	100.0
2008-08-04 06:30:00	SPY	ETF	125.86	125.87	125.75	125.75	11200.0
2008-08-04 07:00:00	SPY	ETF	125.89	125.99	125.79	125.94	119238.0
2008-08-04 07:30:00	SPY	ETF	125.92	126.03	125.87	125.93	308956.0
2008-08-04 08:00:00	SPY	ETF	125.98	126.07	125.87	125.88	1934436.0
2008-08-04 08:30:00	SPY	ETF	125.87	126.15	125.72	125.84	1529366.0
2008-08-04 09:00:00	SPY	ETF	125.84	126.04	125.81	126.04	571303.0
2008-08-04 09:30:00	SPY	ETF	126.04	126.12	125.25	125.48	18092432.0
2008-08-04 10:00:00	SPY	ETF	125.49	125.57	125.1	125.34	14363161.0
2008-08-04 10:30:00	SPY	ETF	125.35	125.38	124.89	125.0675	14436342.0
2008-08-04 11:00:00	SPY	ETF	125.06	126.0	124.85	124.99	10139284.0
2008-08-04 11:30:00	SPY	ETF	124.98	125.72	124.86	125.6	28290402.0
2008-08-04 12:00:00	SPY	ETF	125.6	125.82	125.32	125.62	11625845.0
2008-08-04 12:30:00	SPY	ETF	125.62	125.81	125.28	125.31	5895859.0
2008-08-04 13:00:00	SPY	ETF	125.32	125.48	125.19	125.28	7865692.0
2008-08-04 13:30:00	SPY	ETF	125.28	125.51	125.25	125.42	6608437.0
2008-08-04 14:00:00	SPY	ETF	125.41	125.86	125.33	125.81	11211309.0
2008-08-04 14:30:00	SPY	ETF	125.81	126.14	125.76	125.94	12723058.0
2008-08-04 15:00:00	SPY	ETF	125.935	126.01	125.21	125.21	12413572.0
2008-08-04 15:30:00	SPY	ETF	125.22	125.35	124.76	124.91	24793108.0
2008-08-04 16:00:00	SPY	ETF	124.99	125.9541	124.92	125.07	1862903.0
2008-08-04 16:30:00	SPY	ETF	125.08	125.14	124.99	125.1	1266958.0
2008-08-04 17:00:00	SPY	ETF	125.09	125.11	125.06	125.11	136686.0
2008-08-04 17:30:00	SPY	ETF	125.13	125.13	125.01	125.06	30700.0
2008-08-04 18:00:00	SPY	ETF	125.08	125.11	125.08	125.11	12008.0
2008-08-04 18:30:00	SPY	ETF	125.14	125.14	125.03	125.05	9300.0
2008-08-04 19:00:00	SPY	ETF	125.04	125.09	125.04	125.09	2600.0
2008-08-04 19:30:00	SPY	ETF	125.06	125.13	125.05	125.13	9578.0
2008-08-04 04:30:00	QQQ	ETF	44.96	45.0	44.96	45.0	200.0
2008-08-04 07:00:00	QQQ	ETF	44.83	44.87	44.63	44.79	903854.0
2008-08-04 07:30:00	QQQ	ETF	44.79	44.82	44.78	44.8	154800.0
2008-08-04 08:00:00	QQQ	ETF	44.8	44.85	44.75	44.77	2540188.0
2008-08-04 08:30:00	QQQ	ETF	44.76	44.85	44.75	44.85	1015925.0
2008-08-04 09:00:00	QQQ	ETF	44.84	44.88	44.84	44.88	895149.0
2008-08-04 09:30:00	QQQ	ETF	44.88	44.92	44.5	44.68	14638645.0
2008-08-04 10:00:00	QQQ	ETF	44.67	44.71	44.49	44.6	10545133.0
2008-08-04 10:30:00	QQQ	ETF	44.6	44.62	44.38	44.49	7176419.0
2008-08-04 11:00:00	QQQ	ETF	44.48	44.57	44.41	44.52	4646446.0
2008-08-04 11:30:00	QQQ	ETF	44.52	44.84	44.5189	44.77	14061207.0
2008-08-04 12:00:00	QQQ	ETF	44.77	44.8	44.64	44.75	4448592.0
2008-08-04 12:30:00	QQQ	ETF	44.75	44.82	44.5901	44.6	1783751.0
2008-08-04 13:00:00	QQQ	ETF	44.6	44.69	44.53	44.53	3532232.0
2008-08-04 13:30:00	QQQ	ETF	44.53	44.64	44.51	44.62	2734304.0
2008-08-04 14:00:00	QQQ	ETF	44.61	44.75	44.57	44.72	4260231.0
2008-08-04 14:30:00	QQQ	ETF	44.7299	44.825	44.67	44.7	6900944.0
2008-08-04 15:00:00	QQQ	ETF	44.69	44.73	44.48	44.48	7809719.0
2008-08-04 15:30:00	QQQ	ETF	44.48	44.58	44.3	44.39	13641653.0

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

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