PREVIEW / etf_30min / 2008-08-22

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-22.parquet
  size:    161 KB
  rows:    5,663

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-22 05:00:00	SPY	ETF	128.02	128.18	128.02	128.11	300.0
2008-08-22 05:30:00	SPY	ETF	128.02	128.02	128.02	128.02	1000.0
2008-08-22 06:00:00	SPY	ETF	128.0	128.0	128.0	128.0	1000.0
2008-08-22 06:30:00	SPY	ETF	128.02	128.02	128.02	128.02	2000.0
2008-08-22 07:00:00	SPY	ETF	128.01	128.22	128.01	128.19	139638.0
2008-08-22 07:30:00	SPY	ETF	128.23	129.09	128.23	128.85	2549699.0
2008-08-22 08:00:00	SPY	ETF	128.84	128.98	128.33	128.64	3771410.0
2008-08-22 08:30:00	SPY	ETF	128.64	128.86	128.57	128.86	1428594.0
2008-08-22 09:00:00	SPY	ETF	128.84	129.0	128.69	128.69	3932240.0
2008-08-22 09:30:00	SPY	ETF	128.67	129.24	128.56	129.15	23822589.0
2008-08-22 10:00:00	SPY	ETF	129.15	129.565	128.92	129.45	19009645.0
2008-08-22 10:30:00	SPY	ETF	129.45	129.645	129.26	129.27	11814493.0
2008-08-22 11:00:00	SPY	ETF	129.28	129.4	129.13	129.15	10535616.0
2008-08-22 11:30:00	SPY	ETF	129.16	129.21	128.93	129.05	8965628.0
2008-08-22 12:00:00	SPY	ETF	129.06	129.06	128.59	128.71	10040497.0
2008-08-22 12:30:00	SPY	ETF	128.71	128.99	128.66	128.97	6527935.0
2008-08-22 13:00:00	SPY	ETF	128.97	129.31	128.93	129.27	8725404.0
2008-08-22 13:30:00	SPY	ETF	129.27	129.391	129.12	129.28	6114464.0
2008-08-22 14:00:00	SPY	ETF	129.28	129.38	128.97	129.25	9573117.0
2008-08-22 14:30:00	SPY	ETF	129.25	129.5	129.1	129.19	9297676.0
2008-08-22 15:00:00	SPY	ETF	129.19	129.34	129.02	129.21	8148727.0
2008-08-22 15:30:00	SPY	ETF	129.21	129.56	129.21	129.52	16047401.0
2008-08-22 16:00:00	SPY	ETF	129.45	129.65	128.62	129.53	3550735.0
2008-08-22 16:30:00	SPY	ETF	129.53	129.67	129.53	129.6	1092072.0
2008-08-22 17:00:00	SPY	ETF	129.61	129.65	129.5	129.65	23696.0
2008-08-22 17:30:00	SPY	ETF	129.65	129.65	129.54	129.54	26980.0
2008-08-22 18:00:00	SPY	ETF	129.53	129.54	129.48	129.54	19133.0
2008-08-22 18:30:00	SPY	ETF	129.46	129.49	129.46	129.49	276.0
2008-08-22 19:00:00	SPY	ETF	129.49	129.53	129.49	129.53	10996.0
2008-08-22 19:30:00	SPY	ETF	129.52	129.58	129.52	129.58	16600.0
2008-08-22 04:00:00	QQQ	ETF	46.92	46.92	46.92	46.92	100.0
2008-08-22 05:00:00	QQQ	ETF	46.98	46.98	46.98	46.98	300.0
2008-08-22 06:30:00	QQQ	ETF	47.0	47.0	47.0	47.0	100.0
2008-08-22 07:00:00	QQQ	ETF	46.97	47.05	46.95	47.05	84475.0
2008-08-22 07:30:00	QQQ	ETF	47.02	47.36	47.02	47.25	778141.0
2008-08-22 08:00:00	QQQ	ETF	47.26	47.27	47.08	47.11	1417536.0
2008-08-22 08:30:00	QQQ	ETF	47.11	47.17	47.06	47.17	1130084.0
2008-08-22 09:00:00	QQQ	ETF	47.16	47.24	47.11	47.12	1690489.0
2008-08-22 09:30:00	QQQ	ETF	47.13	47.4	47.08	47.31	13931631.0
2008-08-22 10:00:00	QQQ	ETF	47.32	47.49	47.24	47.43	10543140.0
2008-08-22 10:30:00	QQQ	ETF	47.43	47.56	47.37	47.3999	8698385.0
2008-08-22 11:00:00	QQQ	ETF	47.392	47.45	47.31	47.34	4281389.0
2008-08-22 11:30:00	QQQ	ETF	47.35	47.4	47.3	47.37	4491490.0
2008-08-22 12:00:00	QQQ	ETF	47.37	47.37	47.17	47.262	5375414.0
2008-08-22 12:30:00	QQQ	ETF	47.27	47.37	47.22	47.36	3111161.0
2008-08-22 13:00:00	QQQ	ETF	47.36	47.49	47.335	47.47	4729145.0
2008-08-22 13:30:00	QQQ	ETF	47.4601	47.53	47.43	47.5	3642132.0
2008-08-22 14:00:00	QQQ	ETF	47.51	47.65	47.41	47.57	4664858.0
2008-08-22 14:30:00	QQQ	ETF	47.57	47.68	47.5117	47.55	4221112.0
2008-08-22 15:00:00	QQQ	ETF	47.55	47.6	47.46	47.4901	3564236.0

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

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