PREVIEW / etf_30min / 2009-01-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-16.parquet
  size:    208 KB
  rows:    6,838

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-16 04:00:00	SPY	ETF	85.2	85.4	85.14	85.4	12900.0
2009-01-16 04:30:00	SPY	ETF	85.35	85.75	85.35	85.75	3519.0
2009-01-16 05:00:00	SPY	ETF	85.6	85.68	85.6	85.68	2600.0
2009-01-16 05:30:00	SPY	ETF	85.75	85.76	85.35	85.35	1300.0
2009-01-16 06:00:00	SPY	ETF	85.25	85.43	85.2	85.4	27000.0
2009-01-16 06:30:00	SPY	ETF	85.59	86.16	85.56	85.99	191100.0
2009-01-16 07:00:00	SPY	ETF	86.0	86.07	85.76	85.77	543348.0
2009-01-16 07:30:00	SPY	ETF	85.78	86.02	85.59	85.84	744580.0
2009-01-16 08:00:00	SPY	ETF	85.85	86.08	85.28	85.56	1991123.0
2009-01-16 08:30:00	SPY	ETF	85.56	85.66	85.0	85.51	2980896.0
2009-01-16 09:00:00	SPY	ETF	85.52	85.88	85.1	85.87	2562802.0
2009-01-16 09:30:00	SPY	ETF	85.86	85.9876	85.13	85.25	41287211.0
2009-01-16 10:00:00	SPY	ETF	85.25	85.9	84.89	85.25	25602758.0
2009-01-16 10:30:00	SPY	ETF	85.25	85.59	84.91	85.04	23509519.0
2009-01-16 11:00:00	SPY	ETF	85.04	85.1	84.63	84.94	20728715.0
2009-01-16 11:30:00	SPY	ETF	84.959	85.04	83.84	84.04	26000729.0
2009-01-16 12:00:00	SPY	ETF	84.04	84.42	83.05	83.24	24791530.0
2009-01-16 12:30:00	SPY	ETF	83.24	83.95	83.2	83.84	21750606.0
2009-01-16 13:00:00	SPY	ETF	83.84	84.11	83.47	83.78	19569856.0
2009-01-16 13:30:00	SPY	ETF	83.78	84.44	83.7	84.37	22909534.0
2009-01-16 14:00:00	SPY	ETF	84.37	85.3	84.06	84.54	28900463.0
2009-01-16 14:30:00	SPY	ETF	84.5475	85.0	84.2	84.97	26445963.0
2009-01-16 15:00:00	SPY	ETF	84.97	85.51	84.62	84.76	38310669.0
2009-01-16 15:30:00	SPY	ETF	84.76	85.28	84.66	84.98	46050602.0
2009-01-16 16:00:00	SPY	ETF	84.97	85.31	84.7625	85.25	16880149.0
2009-01-16 16:30:00	SPY	ETF	85.28	85.32	85.25	85.29	136826.0
2009-01-16 17:00:00	SPY	ETF	85.3	85.55	85.29	85.42	496872.0
2009-01-16 17:30:00	SPY	ETF	85.42	85.54	85.42	85.43	352112.0
2009-01-16 18:00:00	SPY	ETF	85.43	85.5	85.4	85.45	37901.0
2009-01-16 18:30:00	SPY	ETF	85.41	85.52	85.4	85.46	40745.0
2009-01-16 19:00:00	SPY	ETF	85.46	85.49	85.43	85.43	8681.0
2009-01-16 19:30:00	SPY	ETF	85.42	85.45	85.42	85.42	8194.0
2009-01-16 04:00:00	QQQ	ETF	29.26	29.26	29.26	29.26	200.0
2009-01-16 05:00:00	QQQ	ETF	29.45	29.45	29.45	29.45	100.0
2009-01-16 05:30:00	QQQ	ETF	29.39	29.39	29.39	29.39	100.0
2009-01-16 06:00:00	QQQ	ETF	29.39	29.39	29.39	29.39	100.0
2009-01-16 06:30:00	QQQ	ETF	29.35	29.57	29.35	29.53	85982.0
2009-01-16 07:00:00	QQQ	ETF	29.53	29.53	29.45	29.47	236614.0
2009-01-16 07:30:00	QQQ	ETF	29.48	29.55	29.45	29.5	90620.0
2009-01-16 08:00:00	QQQ	ETF	29.51	29.51	29.33	29.41	762218.0
2009-01-16 08:30:00	QQQ	ETF	29.41	29.46	29.33	29.43	1063985.0
2009-01-16 09:00:00	QQQ	ETF	29.41	29.54	29.32	29.53	2387626.0
2009-01-16 09:30:00	QQQ	ETF	29.52	29.6	29.26	29.31	25727065.0
2009-01-16 10:00:00	QQQ	ETF	29.31	29.47	29.16	29.26	13566423.0
2009-01-16 10:30:00	QQQ	ETF	29.26	29.43	29.2	29.28	7685985.0
2009-01-16 11:00:00	QQQ	ETF	29.28	29.3	29.13	29.22	8904552.0
2009-01-16 11:30:00	QQQ	ETF	29.23	29.27	28.95	29.0201	11374941.0
2009-01-16 12:00:00	QQQ	ETF	29.0205	29.06	28.7	28.79	11863838.0
2009-01-16 12:30:00	QQQ	ETF	28.79	29.0	28.75	28.98	9494118.0
2009-01-16 13:00:00	QQQ	ETF	28.98	29.05	28.85	28.97	7511094.0

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

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