PREVIEW / etf_30min / 2008-08-27

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-27.parquet
  size:    164 KB
  rows:    5,763

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-27 05:00:00	SPY	ETF	127.09	127.09	127.01	127.01	600.0
2008-08-27 05:30:00	SPY	ETF	126.98	127.01	126.98	127.01	6000.0
2008-08-27 06:00:00	SPY	ETF	127.09	127.15	127.06	127.1	105000.0
2008-08-27 06:30:00	SPY	ETF	127.04	127.12	127.01	127.04	21000.0
2008-08-27 07:00:00	SPY	ETF	127.02	127.3	127.02	127.19	118200.0
2008-08-27 07:30:00	SPY	ETF	127.19	127.24	127.11	127.19	160341.0
2008-08-27 08:00:00	SPY	ETF	127.15	127.29	127.01	127.27	1385509.0
2008-08-27 08:30:00	SPY	ETF	127.37	127.99	127.1	127.77	4522044.0
2008-08-27 09:00:00	SPY	ETF	127.76	127.77	127.54	127.56	1558374.0
2008-08-27 09:30:00	SPY	ETF	127.55	127.8	127.3	127.46	15446374.0
2008-08-27 10:00:00	SPY	ETF	127.45	128.07	127.39	127.99	13293721.0
2008-08-27 10:30:00	SPY	ETF	127.9925	128.29	127.91	128.06	14929335.0
2008-08-27 11:00:00	SPY	ETF	128.06	128.08	127.8	127.8	8362985.0
2008-08-27 11:30:00	SPY	ETF	127.8	127.93	127.66	127.93	8008254.0
2008-08-27 12:00:00	SPY	ETF	127.93	128.51	127.79	128.471	14765530.0
2008-08-27 12:30:00	SPY	ETF	128.47	128.83	128.39	128.7	17023695.0
2008-08-27 13:00:00	SPY	ETF	128.7	128.73	128.4	128.53	6238582.0
2008-08-27 13:30:00	SPY	ETF	128.54	128.69	128.42	128.45	6480405.0
2008-08-27 14:00:00	SPY	ETF	128.45	128.63	128.29	128.53	8528458.0
2008-08-27 14:30:00	SPY	ETF	128.53	128.8	128.4	128.4708	8076507.0
2008-08-27 15:00:00	SPY	ETF	128.48	128.64	128.06	128.11	13707820.0
2008-08-27 15:30:00	SPY	ETF	128.1	128.51	127.97	128.46	16590836.0
2008-08-27 16:00:00	SPY	ETF	128.39	128.62	128.2089	128.49	3785150.0
2008-08-27 16:30:00	SPY	ETF	128.49	128.5	127.46	128.44	3060418.0
2008-08-27 17:00:00	SPY	ETF	128.45	128.49	128.4	128.44	423049.0
2008-08-27 17:30:00	SPY	ETF	128.49	128.5	128.41	128.42	34601.0
2008-08-27 18:00:00	SPY	ETF	128.42	128.47	128.41	128.47	56755.0
2008-08-27 18:30:00	SPY	ETF	128.48	128.53	128.41	128.41	75100.0
2008-08-27 19:00:00	SPY	ETF	128.49	128.5	128.44	128.44	5600.0
2008-08-27 19:30:00	SPY	ETF	128.48	128.48	128.43	128.44	7908.0
2008-08-27 06:30:00	QQQ	ETF	46.32	46.33	46.32	46.33	1200.0
2008-08-27 07:00:00	QQQ	ETF	46.34	46.41	46.34	46.4	243855.0
2008-08-27 07:30:00	QQQ	ETF	46.4	46.41	46.37	46.4	51217.0
2008-08-27 08:00:00	QQQ	ETF	46.39	46.41	46.35	46.4	1242525.0
2008-08-27 08:30:00	QQQ	ETF	46.41	46.62	46.38	46.54	1718986.0
2008-08-27 09:00:00	QQQ	ETF	46.54	46.54	46.42	46.44	925130.0
2008-08-27 09:30:00	QQQ	ETF	46.45	46.56	46.29	46.3801	9642683.0
2008-08-27 10:00:00	QQQ	ETF	46.38	46.71	46.37	46.66	10263840.0
2008-08-27 10:30:00	QQQ	ETF	46.67	46.71	46.52	46.59	8156433.0
2008-08-27 11:00:00	QQQ	ETF	46.59	46.62	46.5	46.54	3283501.0
2008-08-27 11:30:00	QQQ	ETF	46.54	46.55	46.44	46.54	4079984.0
2008-08-27 12:00:00	QQQ	ETF	46.54	46.79	46.51	46.765	6195896.0
2008-08-27 12:30:00	QQQ	ETF	46.76	47.04	46.76	47.01	10679404.0
2008-08-27 13:00:00	QQQ	ETF	47.01	47.02	46.86	46.91	5274440.0
2008-08-27 13:30:00	QQQ	ETF	46.91	47.01	46.89	47.0	4581307.0
2008-08-27 14:00:00	QQQ	ETF	46.91	47.0	46.86	46.96	4224430.0
2008-08-27 14:30:00	QQQ	ETF	46.95	47.09	46.89	46.912	8565229.0
2008-08-27 15:00:00	QQQ	ETF	46.91	46.96	46.67	46.7	8661405.0
2008-08-27 15:30:00	QQQ	ETF	46.7	46.78	46.58	46.75	13411502.0
2008-08-27 16:00:00	QQQ	ETF	46.75	46.79	46.6	46.69	3262646.0

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

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