PREVIEW / etf_30min / 2010-10-08

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-08.parquet
  size:    257 KB
  rows:    8,638

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
2010-10-08 04:00:00	SPY	ETF	115.98	116.06	115.9	115.94	600.0
2010-10-08 04:30:00	SPY	ETF	115.85	115.89	115.78	115.78	400.0
2010-10-08 05:00:00	SPY	ETF	115.8	115.8	115.8	115.8	500.0
2010-10-08 05:30:00	SPY	ETF	115.89	115.89	115.81	115.81	1200.0
2010-10-08 06:00:00	SPY	ETF	115.71	115.71	115.61	115.61	21300.0
2010-10-08 06:30:00	SPY	ETF	115.66	115.7	115.6	115.6	351170.0
2010-10-08 07:00:00	SPY	ETF	115.6	115.7	115.5	115.68	1653750.0
2010-10-08 07:30:00	SPY	ETF	115.7	115.72	115.54	115.62	152800.0
2010-10-08 08:00:00	SPY	ETF	115.62	116.1	115.58	115.75	1553068.0
2010-10-08 08:30:00	SPY	ETF	115.77	116.34	115.02	115.69	9390936.0
2010-10-08 09:00:00	SPY	ETF	115.69	116.12	115.53	116.05	4626909.0
2010-10-08 09:30:00	SPY	ETF	116.05	116.21	115.74	116.09	21455965.0
2010-10-08 10:00:00	SPY	ETF	116.09	116.18	115.61	115.68	17033524.0
2010-10-08 10:30:00	SPY	ETF	115.68	116.15	115.64	116.0999	10485550.0
2010-10-08 11:00:00	SPY	ETF	116.1	116.48	116.095	116.41	12811719.0
2010-10-08 11:30:00	SPY	ETF	116.41	116.62	116.38	116.51	10029634.0
2010-10-08 12:00:00	SPY	ETF	116.5062	116.55	116.35	116.39	5570280.0
2010-10-08 12:30:00	SPY	ETF	116.39	116.71	116.36	116.62	5771081.0
2010-10-08 13:00:00	SPY	ETF	116.63	116.65	116.46	116.555	5148999.0
2010-10-08 13:30:00	SPY	ETF	116.55	116.56	116.29	116.38	8622429.0
2010-10-08 14:00:00	SPY	ETF	116.39	116.55	116.23	116.49	7896481.0
2010-10-08 14:30:00	SPY	ETF	116.49	116.64	116.43	116.46	7749174.0
2010-10-08 15:00:00	SPY	ETF	116.46	116.73	116.45	116.56	9708726.0
2010-10-08 15:30:00	SPY	ETF	116.57	116.86	116.52	116.55	22559189.0
2010-10-08 16:00:00	SPY	ETF	116.55	116.7534	115.755	116.56	12414209.0
2010-10-08 16:30:00	SPY	ETF	116.59	116.64	116.53	116.56	249759.0
2010-10-08 17:00:00	SPY	ETF	116.56	116.58	116.47	116.54	357187.0
2010-10-08 17:30:00	SPY	ETF	116.51	116.55	116.42	116.48	178501.0
2010-10-08 18:00:00	SPY	ETF	116.48	116.56	116.46	116.56	81562.0
2010-10-08 18:30:00	SPY	ETF	116.5	116.51	116.48	116.49	19677.0
2010-10-08 19:00:00	SPY	ETF	116.49	116.57	116.49	116.57	24812.0
2010-10-08 19:30:00	SPY	ETF	116.56	116.56	116.51	116.53	7389.0
2010-10-08 05:00:00	QQQ	ETF	49.3	49.3	49.3	49.3	5000.0
2010-10-08 06:00:00	QQQ	ETF	49.32	49.32	49.3	49.3	400.0
2010-10-08 06:30:00	QQQ	ETF	49.36	49.36	49.36	49.36	100.0
2010-10-08 07:00:00	QQQ	ETF	49.31	49.34	49.26	49.34	6094.0
2010-10-08 07:30:00	QQQ	ETF	49.35	49.35	49.27	49.32	7534.0
2010-10-08 08:00:00	QQQ	ETF	49.32	49.38	49.29	49.35	757173.0
2010-10-08 08:30:00	QQQ	ETF	49.34	49.62	48.74	49.26	5172537.0
2010-10-08 09:00:00	QQQ	ETF	49.25	49.47	49.2	49.45	443641.0
2010-10-08 09:30:00	QQQ	ETF	49.45	49.492	49.26	49.4	8511393.0
2010-10-08 10:00:00	QQQ	ETF	49.4001	49.44	49.1	49.13	6247363.0
2010-10-08 10:30:00	QQQ	ETF	49.13	49.35	49.08	49.32	4886751.0
2010-10-08 11:00:00	QQQ	ETF	49.32	49.63	49.32	49.59	5776657.0
2010-10-08 11:30:00	QQQ	ETF	49.59	49.77	49.59	49.72	5210930.0
2010-10-08 12:00:00	QQQ	ETF	49.72	49.7425	49.59	49.63	3706728.0
2010-10-08 12:30:00	QQQ	ETF	49.6325	49.87	49.61	49.7696	4782215.0
2010-10-08 13:00:00	QQQ	ETF	49.77	49.8	49.72	49.76	1294519.0
2010-10-08 13:30:00	QQQ	ETF	49.77	49.77	49.6	49.65	2734137.0
2010-10-08 14:00:00	QQQ	ETF	49.655	49.75	49.56	49.72	3600576.0

> showing 50 of 8,638 rows — these rows as CSV

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