PREVIEW / etf_30min / 2010-08-16

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-16.parquet
  size:    249 KB
  rows:    8,334

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-08-16 04:00:00	SPY	ETF	108.11	108.11	107.76	107.76	1057.0
2010-08-16 04:30:00	SPY	ETF	107.9	107.91	107.8	107.8	1800.0
2010-08-16 05:00:00	SPY	ETF	107.86	108.06	107.72	108.06	524.0
2010-08-16 05:30:00	SPY	ETF	108.0	108.0	108.0	108.0	500.0
2010-08-16 06:00:00	SPY	ETF	107.91	107.91	107.88	107.88	1200.0
2010-08-16 06:30:00	SPY	ETF	108.07	108.07	107.95	107.95	14200.0
2010-08-16 07:00:00	SPY	ETF	107.91	107.98	107.79	107.87	100343.0
2010-08-16 07:30:00	SPY	ETF	107.89	107.89	107.65	107.79	254942.0
2010-08-16 08:00:00	SPY	ETF	107.81	108.55	107.61	107.7	1196820.0
2010-08-16 08:30:00	SPY	ETF	107.73	108.07	107.64	107.89	1501873.0
2010-08-16 09:00:00	SPY	ETF	107.89	107.99	107.53	107.57	2735555.0
2010-08-16 09:30:00	SPY	ETF	107.57	108.0	107.18	107.8	25623235.0
2010-08-16 10:00:00	SPY	ETF	107.8	108.4	107.66	108.28	17005297.0
2010-08-16 10:30:00	SPY	ETF	108.28	108.49	108.25	108.33	9559725.0
2010-08-16 11:00:00	SPY	ETF	108.34	108.36	108.07	108.1	8381747.0
2010-08-16 11:30:00	SPY	ETF	108.11	108.45	108.09	108.4	8671987.0
2010-08-16 12:00:00	SPY	ETF	108.4	108.57	108.34	108.55	6751141.0
2010-08-16 12:30:00	SPY	ETF	108.56	108.61	108.3947	108.47	5240480.0
2010-08-16 13:00:00	SPY	ETF	108.48	108.57	108.41	108.47	4015500.0
2010-08-16 13:30:00	SPY	ETF	108.48	108.53	108.31	108.36	3609651.0
2010-08-16 14:00:00	SPY	ETF	108.36	108.46	108.11	108.26	6275468.0
2010-08-16 14:30:00	SPY	ETF	108.26	108.42	107.88	107.93	10904963.0
2010-08-16 15:00:00	SPY	ETF	107.92	108.2134	107.82	108.04	11044728.0
2010-08-16 15:30:00	SPY	ETF	108.03	108.33	107.97	108.28	17765671.0
2010-08-16 16:00:00	SPY	ETF	108.27	108.4519	107.955	108.25	5687712.0
2010-08-16 16:30:00	SPY	ETF	108.26	108.35	108.23	108.29	761915.0
2010-08-16 17:00:00	SPY	ETF	108.31	108.38	108.3	108.31	56964.0
2010-08-16 17:30:00	SPY	ETF	108.34	108.37	108.32	108.36	28870.0
2010-08-16 18:00:00	SPY	ETF	108.33	108.36	108.32	108.34	70955.0
2010-08-16 18:30:00	SPY	ETF	108.33	108.33	108.26	108.29	90572.0
2010-08-16 19:00:00	SPY	ETF	108.29	108.29	108.14	108.18	100988.0
2010-08-16 19:30:00	SPY	ETF	108.18	108.19	108.07	108.11	79755.0
2010-08-16 04:00:00	QQQ	ETF	44.7	44.7	44.6	44.6	2000.0
2010-08-16 06:30:00	QQQ	ETF	44.65	44.67	44.65	44.66	50518.0
2010-08-16 07:00:00	QQQ	ETF	44.63	44.66	44.58	44.58	17148.0
2010-08-16 07:30:00	QQQ	ETF	44.59	44.59	44.53	44.56	9972.0
2010-08-16 08:00:00	QQQ	ETF	44.59	44.61	44.51	44.52	70254.0
2010-08-16 08:30:00	QQQ	ETF	44.52	44.72	44.51	44.61	170371.0
2010-08-16 09:00:00	QQQ	ETF	44.6	44.61	44.48	44.49	371143.0
2010-08-16 09:30:00	QQQ	ETF	44.48	44.81	44.3	44.73	9583250.0
2010-08-16 10:00:00	QQQ	ETF	44.73	44.94	44.67	44.89	4669292.0
2010-08-16 10:30:00	QQQ	ETF	44.89	45.04	44.89	44.98	3745412.0
2010-08-16 11:00:00	QQQ	ETF	44.98	44.99	44.84	44.86	1848735.0
2010-08-16 11:30:00	QQQ	ETF	44.86	45.01	44.85	44.97	2202867.0
2010-08-16 12:00:00	QQQ	ETF	44.97	45.08	44.96	45.07	1643678.0
2010-08-16 12:30:00	QQQ	ETF	45.06	45.11	44.95	44.98	5502343.0
2010-08-16 13:00:00	QQQ	ETF	44.98	45.0102	44.94	44.96	2589503.0
2010-08-16 13:30:00	QQQ	ETF	44.96	44.9902	44.88	44.91	1083941.0
2010-08-16 14:00:00	QQQ	ETF	44.92	44.96	44.82	44.87	1801375.0
2010-08-16 14:30:00	QQQ	ETF	44.87	44.89	44.66	44.679	2553235.0

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

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