PREVIEW / etf_30min / 2009-01-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-27.parquet
  size:    203 KB
  rows:    6,671

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-01-27 04:00:00	SPY	ETF	84.78	84.78	84.73	84.73	600.0
2009-01-27 04:30:00	SPY	ETF	84.85	84.85	84.85	84.85	100.0
2009-01-27 05:00:00	SPY	ETF	84.33	84.33	84.21	84.23	2388.0
2009-01-27 06:00:00	SPY	ETF	84.14	84.14	84.14	84.14	1500.0
2009-01-27 06:30:00	SPY	ETF	83.95	84.03	83.8	83.91	23200.0
2009-01-27 07:00:00	SPY	ETF	84.0	84.0	83.67	83.87	322812.0
2009-01-27 07:30:00	SPY	ETF	83.87	84.18	83.76	84.09	436442.0
2009-01-27 08:00:00	SPY	ETF	84.1	84.55	84.06	84.46	873207.0
2009-01-27 08:30:00	SPY	ETF	84.44	84.58	84.23	84.46	1211168.0
2009-01-27 09:00:00	SPY	ETF	84.49	84.52	84.11	84.13	1552197.0
2009-01-27 09:30:00	SPY	ETF	84.13	84.85	83.99	84.42	28352134.0
2009-01-27 10:00:00	SPY	ETF	84.44	84.55	83.56	83.94	32277086.0
2009-01-27 10:30:00	SPY	ETF	83.94	84.58	83.6	84.11	18501172.0
2009-01-27 11:00:00	SPY	ETF	84.11	84.7	84.01	84.58	16451156.0
2009-01-27 11:30:00	SPY	ETF	84.58	84.66	84.19	84.38	15263432.0
2009-01-27 12:00:00	SPY	ETF	84.38	85.13	84.23	85.02	17708812.0
2009-01-27 12:30:00	SPY	ETF	85.02	85.15	84.7	84.86	11624146.0
2009-01-27 13:00:00	SPY	ETF	84.8609	85.07	84.46	84.7	16159498.0
2009-01-27 13:30:00	SPY	ETF	84.69	84.94	84.42	84.44	15138438.0
2009-01-27 14:00:00	SPY	ETF	84.43	84.53	84.1	84.14	16607302.0
2009-01-27 14:30:00	SPY	ETF	84.14	84.77	84.02	84.7	22882007.0
2009-01-27 15:00:00	SPY	ETF	84.7	85.09	84.32	84.94	23815810.0
2009-01-27 15:30:00	SPY	ETF	84.94	84.95	83.3	84.58	23842759.0
2009-01-27 16:00:00	SPY	ETF	84.65	85.0	84.23	84.3	7064019.0
2009-01-27 16:30:00	SPY	ETF	84.33	84.73	84.2	84.57	940263.0
2009-01-27 17:00:00	SPY	ETF	84.57	85.43	84.57	85.26	1307229.0
2009-01-27 17:30:00	SPY	ETF	85.2	85.49	85.2	85.44	153569.0
2009-01-27 18:00:00	SPY	ETF	85.35	85.49	85.25	85.43	139552.0
2009-01-27 18:30:00	SPY	ETF	85.42	85.52	85.36	85.39	106866.0
2009-01-27 19:00:00	SPY	ETF	85.39	85.56	85.33	85.46	69063.0
2009-01-27 19:30:00	SPY	ETF	85.44	85.46	85.3	85.35	86750.0
2009-01-27 04:00:00	QQQ	ETF	29.32	29.34	29.31	29.34	1300.0
2009-01-27 04:30:00	QQQ	ETF	29.25	29.25	29.22	29.22	600.0
2009-01-27 05:00:00	QQQ	ETF	29.19	29.19	29.19	29.19	300.0
2009-01-27 06:00:00	QQQ	ETF	29.22	29.23	29.2	29.2	1050.0
2009-01-27 06:30:00	QQQ	ETF	29.05	29.08	29.05	29.08	1000.0
2009-01-27 07:00:00	QQQ	ETF	29.06	29.06	28.99	29.03	5000.0
2009-01-27 07:30:00	QQQ	ETF	29.11	29.21	29.05	29.17	108507.0
2009-01-27 08:00:00	QQQ	ETF	29.15	29.28	29.01	29.27	328913.0
2009-01-27 08:30:00	QQQ	ETF	29.27	29.28	29.19	29.27	204443.0
2009-01-27 09:00:00	QQQ	ETF	29.28	29.28	29.11	29.14	1086137.0
2009-01-27 09:30:00	QQQ	ETF	29.14	29.49	29.12	29.37	13940128.0
2009-01-27 10:00:00	QQQ	ETF	29.37	29.4	29.13	29.2	12164808.0
2009-01-27 10:30:00	QQQ	ETF	29.2	29.3	29.12	29.28	7169137.0
2009-01-27 11:00:00	QQQ	ETF	29.28	29.45	29.24	29.43	5118639.0
2009-01-27 11:30:00	QQQ	ETF	29.43	29.46	29.28	29.32	4890891.0
2009-01-27 12:00:00	QQQ	ETF	29.32	29.54	29.26	29.52	6357056.0
2009-01-27 12:30:00	QQQ	ETF	29.52	29.57	29.44	29.48	5250547.0
2009-01-27 13:00:00	QQQ	ETF	29.49	29.53	29.36	29.41	5718996.0
2009-01-27 13:30:00	QQQ	ETF	29.41	29.51	29.36	29.36	5420887.0

> showing 50 of 6,671 rows — these rows as CSV

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