PREVIEW / etf_30min / 2009-05-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-05-21.parquet
  size:    222 KB
  rows:    7,368

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-05-21 04:00:00	SPY	ETF	90.07	90.07	89.99	89.99	665.0
2009-05-21 04:30:00	SPY	ETF	89.98	89.98	89.87	89.87	500.0
2009-05-21 05:00:00	SPY	ETF	89.94	89.98	89.85	89.98	3441.0
2009-05-21 05:30:00	SPY	ETF	89.78	90.02	89.78	90.0	5700.0
2009-05-21 06:00:00	SPY	ETF	90.02	90.11	89.97	89.97	39650.0
2009-05-21 06:30:00	SPY	ETF	89.98	89.98	89.92	89.98	7079.0
2009-05-21 07:00:00	SPY	ETF	89.96	90.0	89.81	89.85	336403.0
2009-05-21 07:30:00	SPY	ETF	89.86	90.08	89.85	90.03	493954.0
2009-05-21 08:00:00	SPY	ETF	90.02	90.2	89.87	90.06	980848.0
2009-05-21 08:30:00	SPY	ETF	90.07	90.07	89.44	89.45	2816131.0
2009-05-21 09:00:00	SPY	ETF	89.45	89.48	89.29	89.44	2238296.0
2009-05-21 09:30:00	SPY	ETF	89.46	89.8	89.25	89.36	32194807.0
2009-05-21 10:00:00	SPY	ETF	89.36	89.74	89.0	89.079	33551440.0
2009-05-21 10:30:00	SPY	ETF	89.0722	89.26	88.8	88.82	14711390.0
2009-05-21 11:00:00	SPY	ETF	88.82	89.02	88.72	88.99	12317588.0
2009-05-21 11:30:00	SPY	ETF	88.98	89.39	88.91	89.36	12315429.0
2009-05-21 12:00:00	SPY	ETF	89.36	89.46	89.06	89.139	10620616.0
2009-05-21 12:30:00	SPY	ETF	89.14	89.34	89.08	89.31	7780297.0
2009-05-21 13:00:00	SPY	ETF	89.325	89.43	88.8	88.909	13190949.0
2009-05-21 13:30:00	SPY	ETF	88.89	89.05	88.74	88.94	11344546.0
2009-05-21 14:00:00	SPY	ETF	88.93	89.07	88.39	88.54	20043243.0
2009-05-21 14:30:00	SPY	ETF	88.54	88.95	88.26	88.51	18184394.0
2009-05-21 15:00:00	SPY	ETF	88.51	88.69	88.37	88.53	17319601.0
2009-05-21 15:30:00	SPY	ETF	88.52	89.22	88.5	89.2	32177052.0
2009-05-21 16:00:00	SPY	ETF	89.23	90.6774	88.61	89.34	13609773.0
2009-05-21 16:30:00	SPY	ETF	89.35	90.6772	89.3	89.5	1677623.0
2009-05-21 17:00:00	SPY	ETF	89.49	89.53	89.4	89.44	106212.0
2009-05-21 17:30:00	SPY	ETF	89.44	89.48	89.4	89.46	37394.0
2009-05-21 18:00:00	SPY	ETF	89.46	89.7706	88.27	89.43	514885.0
2009-05-21 18:30:00	SPY	ETF	89.44	89.5	89.43	89.5	19575.0
2009-05-21 19:00:00	SPY	ETF	89.5	89.5	89.46	89.49	5325.0
2009-05-21 19:30:00	SPY	ETF	89.47	89.47	89.36	89.36	22869.0
2009-05-21 04:00:00	QQQ	ETF	34.18	34.18	34.18	34.18	133.0
2009-05-21 04:30:00	QQQ	ETF	34.16	34.16	34.07	34.07	3167.0
2009-05-21 06:30:00	QQQ	ETF	34.11	34.11	34.11	34.11	100.0
2009-05-21 07:00:00	QQQ	ETF	34.12	34.14	34.05	34.06	139775.0
2009-05-21 07:30:00	QQQ	ETF	34.07	34.15	34.07	34.15	11300.0
2009-05-21 08:00:00	QQQ	ETF	34.12	34.15	34.09	34.15	459346.0
2009-05-21 08:30:00	QQQ	ETF	34.15	34.15	33.96	33.96	1110190.0
2009-05-21 09:00:00	QQQ	ETF	33.95	34.04	33.92	34.02	885558.0
2009-05-21 09:30:00	QQQ	ETF	34.02	34.26	33.84	34.01	19234427.0
2009-05-21 10:00:00	QQQ	ETF	34.01	34.16	33.76	33.83	19182771.0
2009-05-21 10:30:00	QQQ	ETF	33.82	33.9	33.63	33.65	8284081.0
2009-05-21 11:00:00	QQQ	ETF	33.66	33.67	33.51	33.57	7971412.0
2009-05-21 11:30:00	QQQ	ETF	33.57	33.73	33.54	33.71	6092638.0
2009-05-21 12:00:00	QQQ	ETF	33.7	33.74	33.53	33.5699	5367911.0
2009-05-21 12:30:00	QQQ	ETF	33.56	33.66	33.55	33.6499	3385709.0
2009-05-21 13:00:00	QQQ	ETF	33.64	33.71	33.47	33.51	5579039.0
2009-05-21 13:30:00	QQQ	ETF	33.51	33.6	33.45	33.54	5390729.0
2009-05-21 14:00:00	QQQ	ETF	33.53	33.62	33.36	33.4	8445297.0

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

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