PREVIEW / etf_30min / 2010-07-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-19.parquet
  size:    251 KB
  rows:    8,377

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-07-19 04:00:00	SPY	ETF	106.93	107.23	106.93	107.2	14200.0
2010-07-19 04:30:00	SPY	ETF	107.2	107.25	107.2	107.23	750.0
2010-07-19 05:00:00	SPY	ETF	107.23	107.38	107.23	107.38	5610.0
2010-07-19 05:30:00	SPY	ETF	107.13	107.22	107.1	107.21	5600.0
2010-07-19 06:00:00	SPY	ETF	107.25	107.39	107.21	107.39	5870.0
2010-07-19 06:30:00	SPY	ETF	107.41	107.46	107.34	107.38	33520.0
2010-07-19 07:00:00	SPY	ETF	107.34	107.42	107.26	107.26	312238.0
2010-07-19 07:30:00	SPY	ETF	107.26	107.26	107.13	107.2	284302.0
2010-07-19 08:00:00	SPY	ETF	107.21	107.3	107.0	107.23	934151.0
2010-07-19 08:30:00	SPY	ETF	107.24	107.24	107.12	107.13	869256.0
2010-07-19 09:00:00	SPY	ETF	107.14	107.15	106.7	107.06	948685.0
2010-07-19 09:30:00	SPY	ETF	107.05	107.43	107.0	107.26	19489090.0
2010-07-19 10:00:00	SPY	ETF	107.22	107.3	106.41	106.42	21423879.0
2010-07-19 10:30:00	SPY	ETF	106.41	107.33	106.22	106.47	14902992.0
2010-07-19 11:00:00	SPY	ETF	106.48	106.91	106.41	106.76	12111836.0
2010-07-19 11:30:00	SPY	ETF	106.76	106.86	106.56	106.82	8108819.0
2010-07-19 12:00:00	SPY	ETF	106.82	106.94	106.56	106.91	8299600.0
2010-07-19 12:30:00	SPY	ETF	106.92	107.19	106.79	106.99	7790100.0
2010-07-19 13:00:00	SPY	ETF	106.99	107.02	106.71	106.7709	5240670.0
2010-07-19 13:30:00	SPY	ETF	106.78	106.91	106.63	106.68	4545516.0
2010-07-19 14:00:00	SPY	ETF	106.67	107.1	106.67	107.02	6751862.0
2010-07-19 14:30:00	SPY	ETF	107.02	107.46	106.67	107.26	12168915.0
2010-07-19 15:00:00	SPY	ETF	107.26	107.63	107.09	107.148	17261192.0
2010-07-19 15:30:00	SPY	ETF	107.14	107.36	106.99	107.32	27334817.0
2010-07-19 16:00:00	SPY	ETF	107.32	107.425	106.665	106.88	7124382.0
2010-07-19 16:30:00	SPY	ETF	106.86	107.29	106.49	106.54	5863415.0
2010-07-19 17:00:00	SPY	ETF	106.53	106.55	106.49	106.49	118522.0
2010-07-19 17:30:00	SPY	ETF	106.49	106.53	106.45	106.48	34878.0
2010-07-19 18:00:00	SPY	ETF	106.46	107.29	106.38	106.4	143247.0
2010-07-19 18:30:00	SPY	ETF	106.39	106.49	106.38	106.44	109567.0
2010-07-19 19:00:00	SPY	ETF	106.41	106.51	106.39	106.51	35723.0
2010-07-19 19:30:00	SPY	ETF	106.5	106.65	106.5	106.65	49842.0
2010-07-19 04:00:00	QQQ	ETF	44.49	44.5	44.49	44.5	300.0
2010-07-19 04:30:00	QQQ	ETF	44.51	44.51	44.51	44.51	2000.0
2010-07-19 05:00:00	QQQ	ETF	44.51	44.51	44.51	44.51	500.0
2010-07-19 06:00:00	QQQ	ETF	44.53	44.58	44.52	44.57	2900.0
2010-07-19 06:30:00	QQQ	ETF	44.58	44.61	44.58	44.6	4200.0
2010-07-19 07:00:00	QQQ	ETF	44.58	44.63	44.56	44.57	123792.0
2010-07-19 07:30:00	QQQ	ETF	44.54	44.54	44.48	44.51	32461.0
2010-07-19 08:00:00	QQQ	ETF	44.51	44.53	44.4	44.53	301667.0
2010-07-19 08:30:00	QQQ	ETF	44.51	44.52	44.46	44.46	254766.0
2010-07-19 09:00:00	QQQ	ETF	44.46	44.48	44.44	44.48	218083.0
2010-07-19 09:30:00	QQQ	ETF	44.48	44.74	44.45	44.59	11092131.0
2010-07-19 10:00:00	QQQ	ETF	44.59	44.67	44.25	44.26	11652442.0
2010-07-19 10:30:00	QQQ	ETF	44.25	44.41	44.1	44.23	9133891.0
2010-07-19 11:00:00	QQQ	ETF	44.22	44.5	44.2	44.45	6057573.0
2010-07-19 11:30:00	QQQ	ETF	44.45	44.5	44.36	44.4601	3162398.0
2010-07-19 12:00:00	QQQ	ETF	44.4601	44.49	44.27	44.47	2676225.0
2010-07-19 12:30:00	QQQ	ETF	44.48	44.56	44.4	44.46	3045226.0
2010-07-19 13:00:00	QQQ	ETF	44.46	44.47	44.32	44.35	1024606.0

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

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