PREVIEW / etf_30min / 2009-11-10

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-10.parquet
  size:    233 KB
  rows:    7,790

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-10 04:00:00	SPY	ETF	109.42	109.42	109.39	109.39	1500.0
2009-11-10 04:30:00	SPY	ETF	109.37	109.4	109.37	109.4	1100.0
2009-11-10 05:00:00	SPY	ETF	109.34	109.34	109.17	109.29	19700.0
2009-11-10 05:30:00	SPY	ETF	109.31	109.44	109.31	109.44	600.0
2009-11-10 06:00:00	SPY	ETF	109.43	109.49	109.43	109.45	1508.0
2009-11-10 06:30:00	SPY	ETF	109.42	109.46	109.35	109.35	2700.0
2009-11-10 07:00:00	SPY	ETF	109.36	109.4	109.32	109.33	91026.0
2009-11-10 07:30:00	SPY	ETF	109.33	109.37	109.23	109.36	125982.0
2009-11-10 08:00:00	SPY	ETF	109.38	109.4	109.23	109.32	716716.0
2009-11-10 08:30:00	SPY	ETF	109.32	109.36	109.22	109.27	557764.0
2009-11-10 09:00:00	SPY	ETF	109.27	109.63	109.15	109.32	1412606.0
2009-11-10 09:30:00	SPY	ETF	109.31	109.82	109.26	109.6	19467105.0
2009-11-10 10:00:00	SPY	ETF	109.6	109.88	109.52	109.87	13270568.0
2009-11-10 10:30:00	SPY	ETF	109.87	109.93	109.29	109.33	17080829.0
2009-11-10 11:00:00	SPY	ETF	109.33	109.44	109.13	109.3101	17670503.0
2009-11-10 11:30:00	SPY	ETF	109.31	109.55	109.15	109.32	10583705.0
2009-11-10 12:00:00	SPY	ETF	109.32	109.37	109.0	109.0	7259062.0
2009-11-10 12:30:00	SPY	ETF	109.0	109.36	108.97	109.33	11345295.0
2009-11-10 13:00:00	SPY	ETF	109.33	109.38	109.12	109.22	6203547.0
2009-11-10 13:30:00	SPY	ETF	109.22	109.36	109.12	109.33	5555243.0
2009-11-10 14:00:00	SPY	ETF	109.3225	109.53	109.25	109.47	5889949.0
2009-11-10 14:30:00	SPY	ETF	109.48	109.66	109.47	109.59	8003009.0
2009-11-10 15:00:00	SPY	ETF	109.5925	109.8	109.49	109.7	8588800.0
2009-11-10 15:30:00	SPY	ETF	109.7	109.71	109.4	109.58	16506265.0
2009-11-10 16:00:00	SPY	ETF	109.59	109.715	109.01	109.65	17764610.0
2009-11-10 16:30:00	SPY	ETF	109.65	109.84	109.5697	109.83	1149839.0
2009-11-10 17:00:00	SPY	ETF	109.82	109.86	109.77	109.85	40453.0
2009-11-10 17:30:00	SPY	ETF	109.86	109.89	109.82	109.85	33850.0
2009-11-10 18:00:00	SPY	ETF	109.83	109.85	109.8	109.84	33690.0
2009-11-10 18:30:00	SPY	ETF	109.83	109.9	109.83	109.88	33239.0
2009-11-10 19:00:00	SPY	ETF	109.9	110.14	109.9	110.1	82451.0
2009-11-10 19:30:00	SPY	ETF	110.08	110.1	110.03	110.05	108961.0
2009-11-10 05:30:00	QQQ	ETF	43.48	43.48	43.48	43.48	100.0
2009-11-10 06:00:00	QQQ	ETF	43.47	43.47	43.47	43.47	100.0
2009-11-10 07:00:00	QQQ	ETF	43.45	43.49	43.45	43.45	4900.0
2009-11-10 07:30:00	QQQ	ETF	43.42	43.45	43.39	43.45	65345.0
2009-11-10 08:00:00	QQQ	ETF	43.45	43.46	43.41	43.44	181919.0
2009-11-10 08:30:00	QQQ	ETF	43.46	43.46	43.41	43.43	298844.0
2009-11-10 09:00:00	QQQ	ETF	43.42	43.45	43.4	43.45	419085.0
2009-11-10 09:30:00	QQQ	ETF	43.45	43.75	43.43	43.6799	12236231.0
2009-11-10 10:00:00	QQQ	ETF	43.68	43.75	43.63	43.738	6567368.0
2009-11-10 10:30:00	QQQ	ETF	43.7394	43.7714	43.46	43.47	7413019.0
2009-11-10 11:00:00	QQQ	ETF	43.4701	43.52	43.4	43.5	5132606.0
2009-11-10 11:30:00	QQQ	ETF	43.49	43.57	43.42	43.492	3368178.0
2009-11-10 12:00:00	QQQ	ETF	43.492	43.56	43.42	43.42	3333562.0
2009-11-10 12:30:00	QQQ	ETF	43.42	43.575	43.41	43.5699	3816577.0
2009-11-10 13:00:00	QQQ	ETF	43.57	43.59	43.495	43.5201	3438827.0
2009-11-10 13:30:00	QQQ	ETF	43.53	43.58	43.48	43.5699	3464772.0
2009-11-10 14:00:00	QQQ	ETF	43.57	43.62	43.54	43.61	4661211.0
2009-11-10 14:30:00	QQQ	ETF	43.61	43.7	43.6001	43.68	4181265.0

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

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