PREVIEW / etf_30min / 2010-09-15

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-15.parquet
  size:    250 KB
  rows:    8,274

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-09-15 04:00:00	SPY	ETF	112.5	112.84	112.5	112.72	600.0
2010-09-15 04:30:00	SPY	ETF	112.71	112.72	112.64	112.64	13600.0
2010-09-15 05:00:00	SPY	ETF	112.56	112.62	112.55	112.56	974.0
2010-09-15 05:30:00	SPY	ETF	112.52	112.52	112.44	112.45	4500.0
2010-09-15 06:00:00	SPY	ETF	112.42	112.42	112.24	112.33	5054.0
2010-09-15 06:30:00	SPY	ETF	112.31	112.39	112.21	112.21	65532.0
2010-09-15 07:00:00	SPY	ETF	112.24	112.42	112.21	112.36	66599.0
2010-09-15 07:30:00	SPY	ETF	112.36	112.52	112.36	112.42	451068.0
2010-09-15 08:00:00	SPY	ETF	112.42	112.44	112.09	112.11	1966060.0
2010-09-15 08:30:00	SPY	ETF	112.12	112.26	112.0	112.25	2117083.0
2010-09-15 09:00:00	SPY	ETF	112.24	112.35	112.13	112.33	1888035.0
2010-09-15 09:30:00	SPY	ETF	112.32	112.42	111.98	112.41	22243071.0
2010-09-15 10:00:00	SPY	ETF	112.4	112.81	112.37	112.6	21211510.0
2010-09-15 10:30:00	SPY	ETF	112.61	112.78	112.49	112.77	12394169.0
2010-09-15 11:00:00	SPY	ETF	112.78	112.8	112.43	112.61	9867385.0
2010-09-15 11:30:00	SPY	ETF	112.61	112.9	112.54	112.8	8537430.0
2010-09-15 12:00:00	SPY	ETF	112.81	112.92	112.71	112.81	6001312.0
2010-09-15 12:30:00	SPY	ETF	112.8	112.87	112.7	112.78	4479145.0
2010-09-15 13:00:00	SPY	ETF	112.79	113.03	112.78	112.8534	5984816.0
2010-09-15 13:30:00	SPY	ETF	112.86	112.95	112.78	112.92	5631939.0
2010-09-15 14:00:00	SPY	ETF	112.92	112.98	112.71	112.75	5050594.0
2010-09-15 14:30:00	SPY	ETF	112.76	112.83	112.58	112.7901	8643499.0
2010-09-15 15:00:00	SPY	ETF	112.8	113.21	112.74	113.15	14442634.0
2010-09-15 15:30:00	SPY	ETF	113.16	113.2	112.98	113.11	21415767.0
2010-09-15 16:00:00	SPY	ETF	113.11	113.24	112.0956	113.23	7747236.0
2010-09-15 16:30:00	SPY	ETF	113.22	113.23	113.06	113.09	3385119.0
2010-09-15 17:00:00	SPY	ETF	113.1	113.15	113.09	113.15	194492.0
2010-09-15 17:30:00	SPY	ETF	113.12	113.13	113.1	113.13	99045.0
2010-09-15 18:00:00	SPY	ETF	113.13	113.16	113.08	113.08	110819.0
2010-09-15 18:30:00	SPY	ETF	113.08	113.11	113.06	113.09	28544.0
2010-09-15 19:00:00	SPY	ETF	113.08	113.15	113.08	113.13	24118.0
2010-09-15 19:30:00	SPY	ETF	113.14	113.16	113.07	113.07	31260.0
2010-09-15 04:00:00	QQQ	ETF	47.5	47.52	47.5	47.51	3100.0
2010-09-15 04:30:00	QQQ	ETF	47.45	47.45	47.45	47.45	14080.0
2010-09-15 06:30:00	QQQ	ETF	47.34	47.34	47.34	47.34	100.0
2010-09-15 07:00:00	QQQ	ETF	47.29	47.35	47.27	47.35	3600.0
2010-09-15 07:30:00	QQQ	ETF	47.36	47.41	47.36	47.36	70455.0
2010-09-15 08:00:00	QQQ	ETF	47.38	47.38	47.12	47.12	896139.0
2010-09-15 08:30:00	QQQ	ETF	47.11	47.3	47.07	47.26	456424.0
2010-09-15 09:00:00	QQQ	ETF	47.26	47.37	47.22	47.35	664684.0
2010-09-15 09:30:00	QQQ	ETF	47.35	47.41	47.19	47.39	8559972.0
2010-09-15 10:00:00	QQQ	ETF	47.39	47.54	47.35	47.48	6704632.0
2010-09-15 10:30:00	QQQ	ETF	47.48	47.54	47.43	47.5301	3730202.0
2010-09-15 11:00:00	QQQ	ETF	47.54	47.54	47.4	47.46	2597070.0
2010-09-15 11:30:00	QQQ	ETF	47.46	47.61	47.46	47.579	3418416.0
2010-09-15 12:00:00	QQQ	ETF	47.57	47.67	47.57	47.64	3007759.0
2010-09-15 12:30:00	QQQ	ETF	47.64	47.66	47.6	47.625	1964085.0
2010-09-15 13:00:00	QQQ	ETF	47.63	47.7	47.62	47.6286	2507313.0
2010-09-15 13:30:00	QQQ	ETF	47.62	47.67	47.6	47.66	1787840.0
2010-09-15 14:00:00	QQQ	ETF	47.6615	47.68	47.59	47.61	1605773.0

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

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