PREVIEW / etf_30min / 2008-08-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-25.parquet
  size:    167 KB
  rows:    5,824

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-25 04:00:00	SPY	ETF	129.09	129.12	129.09	129.12	200.0
2008-08-25 05:30:00	SPY	ETF	129.14	129.14	129.14	129.14	500.0
2008-08-25 06:30:00	SPY	ETF	129.06	129.06	129.03	129.03	12500.0
2008-08-25 07:00:00	SPY	ETF	129.07	129.29	129.07	129.27	77851.0
2008-08-25 07:30:00	SPY	ETF	129.22	129.4	129.1	129.4	79411.0
2008-08-25 08:00:00	SPY	ETF	129.4	129.45	129.12	129.12	634722.0
2008-08-25 08:30:00	SPY	ETF	129.14	129.16	128.62	128.75	2531464.0
2008-08-25 09:00:00	SPY	ETF	128.75	129.15	128.75	128.78	1562023.0
2008-08-25 09:30:00	SPY	ETF	128.8	128.84	128.35	128.48	17792718.0
2008-08-25 10:00:00	SPY	ETF	128.47	128.77	128.17	128.58	16335796.0
2008-08-25 10:30:00	SPY	ETF	128.58	128.6	128.01	128.12	10451147.0
2008-08-25 11:00:00	SPY	ETF	128.12	129.65	127.87	127.96	9185982.0
2008-08-25 11:30:00	SPY	ETF	127.97	128.0	127.22	127.33	9421910.0
2008-08-25 12:00:00	SPY	ETF	127.33	127.35	126.96	127.06	14777742.0
2008-08-25 12:30:00	SPY	ETF	127.06	127.2	126.89	127.09	10029834.0
2008-08-25 13:00:00	SPY	ETF	127.08	127.4	127.04	127.28	13873824.0
2008-08-25 13:30:00	SPY	ETF	127.27	127.48	127.22	127.3486	11656832.0
2008-08-25 14:00:00	SPY	ETF	127.34	127.38	127.08	127.2	11789068.0
2008-08-25 14:30:00	SPY	ETF	127.2	127.54	127.01	127.09	7163347.0
2008-08-25 15:00:00	SPY	ETF	127.09	127.21	126.97	127.05	9573703.0
2008-08-25 15:30:00	SPY	ETF	127.05	127.18	126.75	127.08	18165720.0
2008-08-25 16:00:00	SPY	ETF	127.11	127.13	126.92	126.99	3546922.0
2008-08-25 16:30:00	SPY	ETF	126.99	127.09	126.99	127.01	208183.0
2008-08-25 17:00:00	SPY	ETF	127.01	127.08	127.01	127.02	147930.0
2008-08-25 17:30:00	SPY	ETF	127.01	127.05	127.0	127.05	20990.0
2008-08-25 18:00:00	SPY	ETF	127.07	127.07	127.02	127.02	15168.0
2008-08-25 18:30:00	SPY	ETF	127.07	127.07	127.04	127.04	2400.0
2008-08-25 19:00:00	SPY	ETF	127.04	127.05	127.04	127.05	300.0
2008-08-25 19:30:00	SPY	ETF	127.05	127.05	127.01	127.05	8237.0
2008-08-25 04:00:00	QQQ	ETF	47.29	47.29	47.27	47.27	1000.0
2008-08-25 05:00:00	QQQ	ETF	47.27	47.27	47.27	47.27	200.0
2008-08-25 07:00:00	QQQ	ETF	47.3	47.37	47.3	47.36	2300.0
2008-08-25 07:30:00	QQQ	ETF	47.34	47.41	47.29	47.41	61336.0
2008-08-25 08:00:00	QQQ	ETF	47.4	47.42	47.32	47.32	263137.0
2008-08-25 08:30:00	QQQ	ETF	47.32	47.33	47.12	47.15	1093771.0
2008-08-25 09:00:00	QQQ	ETF	47.16	47.21	47.13	47.15	459974.0
2008-08-25 09:30:00	QQQ	ETF	47.16	47.18	46.97	47.02	12873215.0
2008-08-25 10:00:00	QQQ	ETF	47.02	47.21	46.98	47.14	11485168.0
2008-08-25 10:30:00	QQQ	ETF	47.15	47.16	46.81	46.86	8703532.0
2008-08-25 11:00:00	QQQ	ETF	46.86	46.87	46.69	46.75	9270211.0
2008-08-25 11:30:00	QQQ	ETF	46.75	46.75	46.52	46.53	7398063.0
2008-08-25 12:00:00	QQQ	ETF	46.53	46.58	46.43	46.4717	11248308.0
2008-08-25 12:30:00	QQQ	ETF	46.48	46.54	46.41	46.51	5406980.0
2008-08-25 13:00:00	QQQ	ETF	46.5	46.65	46.49	46.58	6897971.0
2008-08-25 13:30:00	QQQ	ETF	46.57	46.61	46.49	46.54	5916171.0
2008-08-25 14:00:00	QQQ	ETF	46.53	46.59	46.43	46.4799	5002202.0
2008-08-25 14:30:00	QQQ	ETF	46.48	46.63	46.42	46.48	4834672.0
2008-08-25 15:00:00	QQQ	ETF	46.48	46.53	46.43	46.47	8011887.0
2008-08-25 15:30:00	QQQ	ETF	46.47	47.02	46.37	46.55	14675252.0
2008-08-25 16:00:00	QQQ	ETF	46.56	46.6699	46.4626	46.54	8685503.0

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

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