PREVIEW / etf_30min / 2008-08-18

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-08-18.parquet
  size:    171 KB
  rows:    5,959

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-18 05:30:00	SPY	ETF	129.97	129.99	129.97	129.98	10000.0
2008-08-18 06:00:00	SPY	ETF	130.0	130.39	130.0	130.38	5300.0
2008-08-18 06:30:00	SPY	ETF	130.63	130.79	130.37	130.79	92200.0
2008-08-18 07:00:00	SPY	ETF	130.71	130.79	130.53	130.6	80654.0
2008-08-18 07:30:00	SPY	ETF	130.63	130.65	130.51	130.52	80430.0
2008-08-18 08:00:00	SPY	ETF	130.53	130.69	130.45	130.52	691512.0
2008-08-18 08:30:00	SPY	ETF	130.51	130.76	130.47	130.76	365343.0
2008-08-18 09:00:00	SPY	ETF	130.77	130.79	130.44	130.44	775745.0
2008-08-18 09:30:00	SPY	ETF	130.43	130.48	129.44	129.635	21875180.0
2008-08-18 10:00:00	SPY	ETF	129.64	129.68	129.27	129.57	13430423.0
2008-08-18 10:30:00	SPY	ETF	129.57	129.8	129.45	129.73	12630721.0
2008-08-18 11:00:00	SPY	ETF	129.72	129.85	129.55	129.67	10734933.0
2008-08-18 11:30:00	SPY	ETF	129.67	129.69	129.08	129.09	7062679.0
2008-08-18 12:00:00	SPY	ETF	129.09	129.09	128.81	129.06	11914306.0
2008-08-18 12:30:00	SPY	ETF	129.06	129.09	128.44	128.51	11412126.0
2008-08-18 13:00:00	SPY	ETF	128.51	128.73	128.41	128.65	7569284.0
2008-08-18 13:30:00	SPY	ETF	128.64	128.71	128.2	128.2	7588568.0
2008-08-18 14:00:00	SPY	ETF	128.2	128.33	127.92	128.07	11958987.0
2008-08-18 14:30:00	SPY	ETF	128.07	128.18	127.85	128.13	9552887.0
2008-08-18 15:00:00	SPY	ETF	128.13	128.29	127.7	128.09	17480065.0
2008-08-18 15:30:00	SPY	ETF	128.09	128.32	127.66	128.25	20201425.0
2008-08-18 16:00:00	SPY	ETF	128.28	128.47	128.19	128.45	2272880.0
2008-08-18 16:30:00	SPY	ETF	128.43	128.54	128.39	128.47	177405.0
2008-08-18 17:00:00	SPY	ETF	128.49	128.54	128.39	128.5	1028000.0
2008-08-18 17:30:00	SPY	ETF	128.53	128.54	128.47	128.51	51826.0
2008-08-18 18:00:00	SPY	ETF	128.51	128.53	128.42	128.45	63756.0
2008-08-18 18:30:00	SPY	ETF	128.47	128.52	128.39	128.49	234864.0
2008-08-18 19:00:00	SPY	ETF	128.45	128.5	128.45	128.46	9850.0
2008-08-18 19:30:00	SPY	ETF	128.46	128.46	128.37	128.38	48030.0
2008-08-18 04:00:00	QQQ	ETF	48.11	48.11	48.11	48.11	800.0
2008-08-18 06:00:00	QQQ	ETF	48.48	48.48	48.47	48.48	3500.0
2008-08-18 06:30:00	QQQ	ETF	48.46	48.5	48.4	48.5	111200.0
2008-08-18 07:00:00	QQQ	ETF	48.51	48.51	48.42	48.45	74161.0
2008-08-18 07:30:00	QQQ	ETF	48.45	48.45	48.39	48.41	76351.0
2008-08-18 08:00:00	QQQ	ETF	48.41	48.45	48.38	48.4	457918.0
2008-08-18 08:30:00	QQQ	ETF	48.39	48.49	48.37	48.47	286655.0
2008-08-18 09:00:00	QQQ	ETF	48.47	48.47	48.29	48.29	739506.0
2008-08-18 09:30:00	QQQ	ETF	48.29	48.31	47.9	48.07	21811376.0
2008-08-18 10:00:00	QQQ	ETF	48.07	48.09	47.84	47.9617	10309181.0
2008-08-18 10:30:00	QQQ	ETF	47.97	48.13	47.93	48.09	11908935.0
2008-08-18 11:00:00	QQQ	ETF	48.09	48.15	47.99	48.08	5996401.0
2008-08-18 11:30:00	QQQ	ETF	48.08	48.09	47.87	47.8701	2986444.0
2008-08-18 12:00:00	QQQ	ETF	47.87	47.88	47.64	47.72	10876113.0
2008-08-18 12:30:00	QQQ	ETF	47.72	47.73	47.47	47.52	6788675.0
2008-08-18 13:00:00	QQQ	ETF	47.53	47.72	47.52	47.67	5800587.0
2008-08-18 13:30:00	QQQ	ETF	47.67	47.67	47.41	47.42	6832096.0
2008-08-18 14:00:00	QQQ	ETF	47.42	47.53	47.37	47.46	7069437.0
2008-08-18 14:30:00	QQQ	ETF	47.45	47.46	47.34	47.4299	5131999.0
2008-08-18 15:00:00	QQQ	ETF	47.422	47.52	47.26	47.44	10295715.0
2008-08-18 15:30:00	QQQ	ETF	47.44	47.6	47.28	47.59	14046464.0

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

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