PREVIEW / etf_30min / 2009-04-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-24.parquet
  size:    214 KB
  rows:    7,095

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-04-24 04:00:00	SPY	ETF	85.42	85.46	85.35	85.41	1300.0
2009-04-24 04:30:00	SPY	ETF	85.35	85.35	85.16	85.18	700.0
2009-04-24 05:00:00	SPY	ETF	85.13	85.13	85.13	85.13	300.0
2009-04-24 05:30:00	SPY	ETF	85.11	85.15	85.09	85.09	700.0
2009-04-24 06:00:00	SPY	ETF	85.13	85.33	85.13	85.33	21000.0
2009-04-24 06:30:00	SPY	ETF	85.35	85.5	85.35	85.42	26819.0
2009-04-24 07:00:00	SPY	ETF	85.43	85.98	85.41	85.83	221136.0
2009-04-24 07:30:00	SPY	ETF	85.81	85.85	85.59	85.82	273121.0
2009-04-24 08:00:00	SPY	ETF	85.83	86.03	85.68	85.99	698752.0
2009-04-24 08:30:00	SPY	ETF	85.85	86.0	85.37	85.67	3931838.0
2009-04-24 09:00:00	SPY	ETF	85.68	86.14	85.68	86.02	2751406.0
2009-04-24 09:30:00	SPY	ETF	86.03	86.27	85.69	86.27	24079134.0
2009-04-24 10:00:00	SPY	ETF	86.26	86.485	85.75	86.02	25904929.0
2009-04-24 10:30:00	SPY	ETF	86.02	86.47	85.97	86.34	13295130.0
2009-04-24 11:00:00	SPY	ETF	86.34	86.54	86.21	86.44	11276971.0
2009-04-24 11:30:00	SPY	ETF	86.44	86.82	86.41	86.7094	12585447.0
2009-04-24 12:00:00	SPY	ETF	86.71	86.77	86.55	86.63	7700455.0
2009-04-24 12:30:00	SPY	ETF	86.62	86.9	86.61	86.86	12439477.0
2009-04-24 13:00:00	SPY	ETF	86.86	86.96	86.75	86.83	7144654.0
2009-04-24 13:30:00	SPY	ETF	86.81	86.83	86.48	86.57	10865402.0
2009-04-24 14:00:00	SPY	ETF	86.56	86.9	85.74	86.47	43590971.0
2009-04-24 14:30:00	SPY	ETF	86.48	87.14	86.42	87.07	24815253.0
2009-04-24 15:00:00	SPY	ETF	87.07	87.31	86.92	87.02	18507161.0
2009-04-24 15:30:00	SPY	ETF	87.02	87.25	86.12	86.65	44098144.0
2009-04-24 16:00:00	SPY	ETF	86.68	87.17	86.5	87.0	13353681.0
2009-04-24 16:30:00	SPY	ETF	87.0	87.1	86.71	86.98	3057363.0
2009-04-24 17:00:00	SPY	ETF	86.98	87.08	86.25	87.01	4650562.0
2009-04-24 17:30:00	SPY	ETF	87.0	87.07	86.96	87.06	41157.0
2009-04-24 18:00:00	SPY	ETF	87.01	87.05	86.95	86.96	13988.0
2009-04-24 18:30:00	SPY	ETF	87.0	87.02	86.94	86.96	5771.0
2009-04-24 19:00:00	SPY	ETF	86.96	86.98	86.93	86.95	23196.0
2009-04-24 19:30:00	SPY	ETF	86.95	87.04	86.91	86.91	31775.0
2009-04-24 06:00:00	QQQ	ETF	33.08	33.11	33.08	33.11	3100.0
2009-04-24 06:30:00	QQQ	ETF	33.17	33.17	33.16	33.16	31660.0
2009-04-24 07:00:00	QQQ	ETF	33.15	33.36	33.15	33.31	190411.0
2009-04-24 07:30:00	QQQ	ETF	33.27	33.36	33.25	33.33	70200.0
2009-04-24 08:00:00	QQQ	ETF	33.33	33.38	33.3	33.35	241805.0
2009-04-24 08:30:00	QQQ	ETF	33.36	33.42	33.26	33.29	428055.0
2009-04-24 09:00:00	QQQ	ETF	33.29	33.38	33.28	33.36	1132065.0
2009-04-24 09:30:00	QQQ	ETF	33.35	33.37	33.07	33.33	13880829.0
2009-04-24 10:00:00	QQQ	ETF	33.34	33.43	33.25	33.38	10968006.0
2009-04-24 10:30:00	QQQ	ETF	33.37	33.58	33.36	33.52	7365096.0
2009-04-24 11:00:00	QQQ	ETF	33.52	33.63	33.4	33.61	5503174.0
2009-04-24 11:30:00	QQQ	ETF	33.61	33.82	33.6001	33.77	8193207.0
2009-04-24 12:00:00	QQQ	ETF	33.78	33.78	33.65	33.7	6874157.0
2009-04-24 12:30:00	QQQ	ETF	33.691	33.82	33.67	33.78	7540958.0
2009-04-24 13:00:00	QQQ	ETF	33.7801	33.81	33.72	33.76	2821084.0
2009-04-24 13:30:00	QQQ	ETF	33.76	33.76	33.63	33.66	3973854.0
2009-04-24 14:00:00	QQQ	ETF	33.65	33.77	33.4	33.66	19727786.0
2009-04-24 14:30:00	QQQ	ETF	33.66	33.87	33.63	33.848	10819288.0

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

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