PREVIEW / etf_30min / 2009-12-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-23.parquet
  size:    234 KB
  rows:    7,836

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-12-23 04:00:00	SPY	ETF	112.07	112.07	112.07	112.07	200.0
2009-12-23 05:00:00	SPY	ETF	112.2	112.2	112.2	112.2	300.0
2009-12-23 06:00:00	SPY	ETF	111.86	111.86	111.86	111.86	300.0
2009-12-23 06:30:00	SPY	ETF	112.18	112.18	112.15	112.15	400.0
2009-12-23 07:00:00	SPY	ETF	112.17	112.17	112.09	112.14	56918.0
2009-12-23 07:30:00	SPY	ETF	112.14	112.23	112.12	112.22	196576.0
2009-12-23 08:00:00	SPY	ETF	112.21	112.26	112.03	112.04	1349972.0
2009-12-23 08:30:00	SPY	ETF	112.04	112.13	111.96	112.05	1028228.0
2009-12-23 09:00:00	SPY	ETF	112.04	112.08	112.0	112.01	559095.0
2009-12-23 09:30:00	SPY	ETF	112.0	112.1	111.9	111.95	11172284.0
2009-12-23 10:00:00	SPY	ETF	111.93	111.948	111.5	111.57	13391399.0
2009-12-23 10:30:00	SPY	ETF	111.58	111.9	111.575	111.75	10083175.0
2009-12-23 11:00:00	SPY	ETF	111.75	111.86	111.72	111.81	4987101.0
2009-12-23 11:30:00	SPY	ETF	111.81	111.96	111.81	111.895	4170099.0
2009-12-23 12:00:00	SPY	ETF	111.91	111.91	111.815	111.875	2574232.0
2009-12-23 12:30:00	SPY	ETF	111.87	112.03	111.84	111.97	3204891.0
2009-12-23 13:00:00	SPY	ETF	111.9609	112.03	111.9	111.97	3676754.0
2009-12-23 13:30:00	SPY	ETF	111.975	112.11	111.94	112.0225	7783069.0
2009-12-23 14:00:00	SPY	ETF	112.03	112.1	111.98	112.0	4880680.0
2009-12-23 14:30:00	SPY	ETF	112.01	112.09	111.98	112.0	5468184.0
2009-12-23 15:00:00	SPY	ETF	112.0099	112.04	111.7	111.94	4532994.0
2009-12-23 15:30:00	SPY	ETF	111.935	112.08	111.85	111.97	14453815.0
2009-12-23 16:00:00	SPY	ETF	111.95	112.07	111.5897	111.92	8575184.0
2009-12-23 16:30:00	SPY	ETF	111.9	111.98	111.7434	111.96	7870179.0
2009-12-23 17:00:00	SPY	ETF	111.98	112.04	111.98	112.0	1023941.0
2009-12-23 17:30:00	SPY	ETF	111.97	112.03	111.97	112.02	7356.0
2009-12-23 18:00:00	SPY	ETF	112.02	112.02	111.95	111.95	23792.0
2009-12-23 18:30:00	SPY	ETF	112.02	112.02	111.96	111.97	1945.0
2009-12-23 19:00:00	SPY	ETF	111.97	111.99	111.95	111.95	1923.0
2009-12-23 19:30:00	SPY	ETF	111.95	111.97	111.92	111.95	14976.0
2009-12-23 04:00:00	QQQ	ETF	45.32	45.32	45.32	45.32	250.0
2009-12-23 07:00:00	QQQ	ETF	45.45	45.45	45.4	45.45	18500.0
2009-12-23 07:30:00	QQQ	ETF	45.44	45.47	45.4	45.46	6950.0
2009-12-23 08:00:00	QQQ	ETF	45.46	45.47	45.39	45.39	710224.0
2009-12-23 08:30:00	QQQ	ETF	45.37	45.41	45.34	45.36	1821985.0
2009-12-23 09:00:00	QQQ	ETF	45.35	45.37	45.31	45.32	1379565.0
2009-12-23 09:30:00	QQQ	ETF	45.32	45.42	45.26	45.3776	8213556.0
2009-12-23 10:00:00	QQQ	ETF	45.37	45.38	45.21	45.25	10503194.0
2009-12-23 10:30:00	QQQ	ETF	45.26	45.42	45.26	45.37	6320242.0
2009-12-23 11:00:00	QQQ	ETF	45.37	45.42	45.32	45.4	4843234.0
2009-12-23 11:30:00	QQQ	ETF	45.4	45.47	45.39	45.44	2421657.0
2009-12-23 12:00:00	QQQ	ETF	45.44	45.46	45.41	45.46	1729763.0
2009-12-23 12:30:00	QQQ	ETF	45.46	45.5	45.43	45.46	1275551.0
2009-12-23 13:00:00	QQQ	ETF	45.46	45.52	45.45	45.48	2583037.0
2009-12-23 13:30:00	QQQ	ETF	45.48	45.53	45.47	45.509	2867532.0
2009-12-23 14:00:00	QQQ	ETF	45.5	45.57	45.5	45.53	1809517.0
2009-12-23 14:30:00	QQQ	ETF	45.5225	45.57	45.2289	45.53	3102669.0
2009-12-23 15:00:00	QQQ	ETF	45.53	45.539	45.48	45.49	1731364.0
2009-12-23 15:30:00	QQQ	ETF	45.48	45.57	45.45	45.56	6589765.0
2009-12-23 16:00:00	QQQ	ETF	45.55	45.6185	45.5	45.58	4016334.0

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

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