PREVIEW / etf_30min / 2009-01-14

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-01-14.parquet
  size:    207 KB
  rows:    6,799

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-14 04:00:00	SPY	ETF	87.1	87.15	87.1	87.12	1400.0
2009-01-14 04:30:00	SPY	ETF	86.95	86.95	86.64	86.64	1513.0
2009-01-14 05:00:00	SPY	ETF	86.61	86.68	86.49	86.65	10300.0
2009-01-14 05:30:00	SPY	ETF	86.66	86.85	86.66	86.84	1280.0
2009-01-14 06:00:00	SPY	ETF	86.87	86.93	86.61	86.61	18580.0
2009-01-14 06:30:00	SPY	ETF	86.6	86.6	86.26	86.48	27986.0
2009-01-14 07:00:00	SPY	ETF	86.49	86.64	86.49	86.55	540985.0
2009-01-14 07:30:00	SPY	ETF	86.55	86.63	86.34	86.38	529174.0
2009-01-14 08:00:00	SPY	ETF	86.38	86.575	85.85	86.12	1935315.0
2009-01-14 08:30:00	SPY	ETF	86.07	86.12	85.46	85.64	3830721.0
2009-01-14 09:00:00	SPY	ETF	85.63	85.64	85.17	85.55	3915614.0
2009-01-14 09:30:00	SPY	ETF	85.54	85.75	83.16	84.97	38058589.0
2009-01-14 10:00:00	SPY	ETF	84.98	85.2	84.51	84.65	39620393.0
2009-01-14 10:30:00	SPY	ETF	84.65	84.65	83.8	84.11	38463603.0
2009-01-14 11:00:00	SPY	ETF	84.11	84.3	83.69	84.1975	29117957.0
2009-01-14 11:30:00	SPY	ETF	84.215	84.51	84.1	84.4	20437735.0
2009-01-14 12:00:00	SPY	ETF	84.4	84.49	84.1	84.28	16231356.0
2009-01-14 12:30:00	SPY	ETF	84.28	84.62	83.98	84.56	18673822.0
2009-01-14 13:00:00	SPY	ETF	84.56	84.65	84.07	84.11	17763327.0
2009-01-14 13:30:00	SPY	ETF	84.12	84.4	84.04	84.24	14146979.0
2009-01-14 14:00:00	SPY	ETF	84.25	84.7	84.04	84.52	28390282.0
2009-01-14 14:30:00	SPY	ETF	84.52	85.04	84.5	84.585	31587054.0
2009-01-14 15:00:00	SPY	ETF	84.58	84.59	83.8	84.1	39336670.0
2009-01-14 15:30:00	SPY	ETF	84.1	84.6	83.71	84.35	51892811.0
2009-01-14 16:00:00	SPY	ETF	84.33	84.4	84.01	84.37	20705165.0
2009-01-14 16:30:00	SPY	ETF	84.37	87.2194	83.69	84.07	11397492.0
2009-01-14 17:00:00	SPY	ETF	84.06	84.28	83.7	83.75	2927683.0
2009-01-14 17:30:00	SPY	ETF	83.73	83.83	83.6	83.72	233774.0
2009-01-14 18:00:00	SPY	ETF	83.72	83.77	83.52	83.65	210490.0
2009-01-14 18:30:00	SPY	ETF	83.68	83.98	83.62	83.89	110893.0
2009-01-14 19:00:00	SPY	ETF	83.92	83.98	83.79	83.8	66944.0
2009-01-14 19:30:00	SPY	ETF	83.85	83.88	83.76	83.88	47819.0
2009-01-14 04:30:00	QQQ	ETF	29.51	29.51	29.49	29.49	322.0
2009-01-14 05:00:00	QQQ	ETF	29.45	29.45	29.41	29.41	322.0
2009-01-14 05:30:00	QQQ	ETF	29.46	29.46	29.46	29.46	111.0
2009-01-14 06:00:00	QQQ	ETF	29.49	29.49	29.39	29.39	1144.0
2009-01-14 06:30:00	QQQ	ETF	29.4	29.4	29.31	29.36	2241.0
2009-01-14 07:00:00	QQQ	ETF	29.38	29.47	29.34	29.41	260789.0
2009-01-14 07:30:00	QQQ	ETF	29.43	29.44	29.39	29.39	139916.0
2009-01-14 08:00:00	QQQ	ETF	29.54	29.54	29.22	29.32	1383753.0
2009-01-14 08:30:00	QQQ	ETF	29.32	29.34	29.11	29.17	568856.0
2009-01-14 09:00:00	QQQ	ETF	29.17	29.21	29.06	29.17	711923.0
2009-01-14 09:30:00	QQQ	ETF	29.17	29.28	28.87	29.0	18148623.0
2009-01-14 10:00:00	QQQ	ETF	29.0	29.08	28.84	28.89	11392219.0
2009-01-14 10:30:00	QQQ	ETF	28.9	29.07	28.619	28.71	11387732.0
2009-01-14 11:00:00	QQQ	ETF	28.72	28.8	28.55	28.76	6696573.0
2009-01-14 11:30:00	QQQ	ETF	28.77	28.89	28.69	28.84	8461676.0
2009-01-14 12:00:00	QQQ	ETF	28.832	28.87	28.7	28.73	5272868.0
2009-01-14 12:30:00	QQQ	ETF	28.74	28.83	28.63	28.82	5593856.0
2009-01-14 13:00:00	QQQ	ETF	28.82	28.84	28.67	28.69	3381162.0

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

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