PREVIEW / etf_30min / 2009-07-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-14.parquet
  size:    217 KB
  rows:    7,239

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
2009-07-14 04:00:00	SPY	ETF	90.23	90.23	90.19	90.22	33200.0
2009-07-14 04:30:00	SPY	ETF	90.3	90.34	90.3	90.34	600.0
2009-07-14 05:00:00	SPY	ETF	90.17	90.26	90.11	90.26	800.0
2009-07-14 05:30:00	SPY	ETF	90.35	90.35	90.31	90.32	15182.0
2009-07-14 06:00:00	SPY	ETF	90.24	90.24	90.21	90.21	600.0
2009-07-14 06:30:00	SPY	ETF	90.17	90.24	90.17	90.18	4200.0
2009-07-14 07:00:00	SPY	ETF	90.11	90.34	90.1	90.3	102650.0
2009-07-14 07:30:00	SPY	ETF	90.28	90.77	90.28	90.73	904373.0
2009-07-14 08:00:00	SPY	ETF	90.71	90.83	90.27	90.61	3709952.0
2009-07-14 08:30:00	SPY	ETF	90.62	90.62	89.96	90.18	3930607.0
2009-07-14 09:00:00	SPY	ETF	90.18	90.49	90.05	90.39	1412059.0
2009-07-14 09:30:00	SPY	ETF	90.38	90.59	89.91	90.0078	24741106.0
2009-07-14 10:00:00	SPY	ETF	90.0	90.4	89.96	90.17	14388158.0
2009-07-14 10:30:00	SPY	ETF	90.17	90.19	89.73	90.0	11402447.0
2009-07-14 11:00:00	SPY	ETF	89.99	90.48	89.94	90.4	8920493.0
2009-07-14 11:30:00	SPY	ETF	90.4	90.64	90.27	90.56	9925603.0
2009-07-14 12:00:00	SPY	ETF	90.56	90.61	90.17	90.26	8919628.0
2009-07-14 12:30:00	SPY	ETF	90.26	90.47	90.2	90.34	5067202.0
2009-07-14 13:00:00	SPY	ETF	90.35	90.5	90.24	90.35	5228445.0
2009-07-14 13:30:00	SPY	ETF	90.34	90.46	90.28	90.34	5234971.0
2009-07-14 14:00:00	SPY	ETF	90.34	90.48	90.11	90.29	8878682.0
2009-07-14 14:30:00	SPY	ETF	90.29	90.63	90.17	90.51	13350331.0
2009-07-14 15:00:00	SPY	ETF	90.52	90.63	90.44	90.53	10258558.0
2009-07-14 15:30:00	SPY	ETF	90.53	90.69	90.41	90.68	33037280.0
2009-07-14 16:00:00	SPY	ETF	90.67	91.27	90.03	91.17	7909072.0
2009-07-14 16:30:00	SPY	ETF	91.14	91.69	91.11	91.5	1914340.0
2009-07-14 17:00:00	SPY	ETF	91.51	91.6	91.44	91.58	1256221.0
2009-07-14 17:30:00	SPY	ETF	91.55	91.7	91.53	91.56	260826.0
2009-07-14 18:00:00	SPY	ETF	91.54	91.54	90.63	91.4	227358.0
2009-07-14 18:30:00	SPY	ETF	91.42	91.47	91.4	91.46	16090.0
2009-07-14 19:00:00	SPY	ETF	91.46	91.46	91.43	91.45	11550.0
2009-07-14 19:30:00	SPY	ETF	91.44	91.46	91.41	91.45	36326.0
2009-07-14 05:00:00	QQQ	ETF	35.61	35.61	35.61	35.61	3000.0
2009-07-14 05:30:00	QQQ	ETF	35.66	35.66	35.63	35.63	600.0
2009-07-14 06:00:00	QQQ	ETF	35.59	35.59	35.59	35.59	587.0
2009-07-14 07:00:00	QQQ	ETF	35.56	35.61	35.54	35.58	40700.0
2009-07-14 07:30:00	QQQ	ETF	35.59	35.69	35.59	35.69	255885.0
2009-07-14 08:00:00	QQQ	ETF	35.69	35.74	35.54	35.62	989171.0
2009-07-14 08:30:00	QQQ	ETF	35.62	35.65	35.43	35.46	2050939.0
2009-07-14 09:00:00	QQQ	ETF	35.45	35.55	35.4	35.52	708028.0
2009-07-14 09:30:00	QQQ	ETF	35.52	35.76	35.42	35.48	15799791.0
2009-07-14 10:00:00	QQQ	ETF	35.48	35.68	35.46	35.55	9800519.0
2009-07-14 10:30:00	QQQ	ETF	35.541	35.56	35.4	35.53	6297866.0
2009-07-14 11:00:00	QQQ	ETF	35.53	35.7202	35.5	35.69	10100908.0
2009-07-14 11:30:00	QQQ	ETF	35.7	35.74	35.66	35.72	5046729.0
2009-07-14 12:00:00	QQQ	ETF	35.72	35.72	35.57	35.6	3679441.0
2009-07-14 12:30:00	QQQ	ETF	35.6	35.68	35.59	35.65	2021452.0
2009-07-14 13:00:00	QQQ	ETF	35.66	35.72	35.64	35.69	3399284.0
2009-07-14 13:30:00	QQQ	ETF	35.68	35.71	35.64	35.67	3253507.0
2009-07-14 14:00:00	QQQ	ETF	35.6602	35.73	35.6	35.68	4298929.0

> showing 50 of 7,239 rows — these rows as CSV

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