PREVIEW / etf_30min / 2009-11-20

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-20.parquet
  size:    232 KB
  rows:    7,707

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-11-20 04:00:00	SPY	ETF	109.89	109.97	109.89	109.95	1404.0
2009-11-20 04:30:00	SPY	ETF	109.95	110.0	109.94	110.0	3886.0
2009-11-20 05:00:00	SPY	ETF	109.95	109.95	109.81	109.86	3150.0
2009-11-20 05:30:00	SPY	ETF	109.8	109.8	109.59	109.59	6429.0
2009-11-20 06:00:00	SPY	ETF	109.6	109.65	109.48	109.57	2441.0
2009-11-20 06:30:00	SPY	ETF	109.48	109.51	109.31	109.36	29568.0
2009-11-20 07:00:00	SPY	ETF	109.35	109.39	108.88	109.05	602721.0
2009-11-20 07:30:00	SPY	ETF	109.06	109.18	108.97	109.13	321031.0
2009-11-20 08:00:00	SPY	ETF	109.15	109.95	109.09	109.23	1053816.0
2009-11-20 08:30:00	SPY	ETF	109.23	109.33	109.11	109.29	1177328.0
2009-11-20 09:00:00	SPY	ETF	109.29	109.35	109.2	109.25	1250734.0
2009-11-20 09:30:00	SPY	ETF	109.25	109.76	109.23	109.43	21756472.0
2009-11-20 10:00:00	SPY	ETF	109.43	109.65	109.19	109.5	12057629.0
2009-11-20 10:30:00	SPY	ETF	109.5	109.52	109.13	109.17	9701281.0
2009-11-20 11:00:00	SPY	ETF	109.16	109.35	109.02	109.0675	10962537.0
2009-11-20 11:30:00	SPY	ETF	109.08	109.28	109.01	109.22	7846838.0
2009-11-20 12:00:00	SPY	ETF	109.22	109.25	109.1	109.151	5198992.0
2009-11-20 12:30:00	SPY	ETF	109.16	109.21	109.05	109.12	3757914.0
2009-11-20 13:00:00	SPY	ETF	109.12	109.24	109.12	109.19	3589195.0
2009-11-20 13:30:00	SPY	ETF	109.19	109.44	109.1	109.37	6132864.0
2009-11-20 14:00:00	SPY	ETF	109.38	109.47	109.32	109.45	4117611.0
2009-11-20 14:30:00	SPY	ETF	109.46	109.57	109.33	109.37	7850084.0
2009-11-20 15:00:00	SPY	ETF	109.36	109.55	109.31	109.54	6248443.0
2009-11-20 15:30:00	SPY	ETF	109.53	109.76	109.4	109.52	20834695.0
2009-11-20 16:00:00	SPY	ETF	109.53	109.62	109.11	109.51	7323950.0
2009-11-20 16:30:00	SPY	ETF	109.51	109.52	109.45	109.5	2008257.0
2009-11-20 17:00:00	SPY	ETF	109.49	109.53	109.48	109.49	58564.0
2009-11-20 17:30:00	SPY	ETF	109.5	109.53	109.47	109.52	33958.0
2009-11-20 18:00:00	SPY	ETF	109.52	109.52	109.48	109.49	12315.0
2009-11-20 18:30:00	SPY	ETF	109.49	109.5	109.47	109.5	5534.0
2009-11-20 19:00:00	SPY	ETF	109.5	109.52	109.5	109.5	4734.0
2009-11-20 19:30:00	SPY	ETF	109.47	109.53	109.47	109.53	5571.0
2009-11-20 04:00:00	QQQ	ETF	43.66	43.66	43.65	43.65	200.0
2009-11-20 05:00:00	QQQ	ETF	43.59	43.59	43.59	43.59	2000.0
2009-11-20 05:30:00	QQQ	ETF	43.52	43.52	43.52	43.52	500.0
2009-11-20 06:30:00	QQQ	ETF	43.49	43.49	43.41	43.42	18000.0
2009-11-20 07:00:00	QQQ	ETF	43.42	43.42	43.26	43.32	47131.0
2009-11-20 07:30:00	QQQ	ETF	43.34	43.38	43.29	43.37	44686.0
2009-11-20 08:00:00	QQQ	ETF	43.38	43.52	43.33	43.39	354200.0
2009-11-20 08:30:00	QQQ	ETF	43.39	43.47	43.38	43.45	795696.0
2009-11-20 09:00:00	QQQ	ETF	43.44	43.48	43.41	43.42	615821.0
2009-11-20 09:30:00	QQQ	ETF	43.42	43.55	43.33	43.35	11588094.0
2009-11-20 10:00:00	QQQ	ETF	43.36	43.435	43.28	43.43	7646624.0
2009-11-20 10:30:00	QQQ	ETF	43.42	43.43	43.3	43.33	4883750.0
2009-11-20 11:00:00	QQQ	ETF	43.3201	43.43	43.28	43.31	2707728.0
2009-11-20 11:30:00	QQQ	ETF	43.31	43.4	43.29	43.34	4101883.0
2009-11-20 12:00:00	QQQ	ETF	43.35	43.36	43.31	43.3219	2526077.0
2009-11-20 12:30:00	QQQ	ETF	43.32	43.34	43.31	43.33	1862329.0
2009-11-20 13:00:00	QQQ	ETF	43.33	43.4	43.3106	43.3605	4631954.0
2009-11-20 13:30:00	QQQ	ETF	43.3699	43.46	43.35	43.45	3859228.0

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

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