PREVIEW / etf_30min / 2010-08-10

all etf 30-min files

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

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-10 04:00:00	SPY	ETF	112.35	112.84	112.21	112.45	5215.0
2010-08-10 04:30:00	SPY	ETF	112.41	112.46	112.41	112.46	650.0
2010-08-10 05:00:00	SPY	ETF	112.3	112.3	112.26	112.3	10300.0
2010-08-10 05:30:00	SPY	ETF	112.29	112.33	112.29	112.33	1750.0
2010-08-10 06:00:00	SPY	ETF	112.41	112.49	112.33	112.33	3700.0
2010-08-10 06:30:00	SPY	ETF	112.41	112.46	112.38	112.45	38200.0
2010-08-10 07:00:00	SPY	ETF	112.45	112.53	112.32	112.37	599190.0
2010-08-10 07:30:00	SPY	ETF	112.34	112.39	112.24	112.27	452053.0
2010-08-10 08:00:00	SPY	ETF	112.27	112.72	111.86	112.03	3129784.0
2010-08-10 08:30:00	SPY	ETF	112.02	113.02	111.81	112.01	2904273.0
2010-08-10 09:00:00	SPY	ETF	112.0	113.01	111.94	112.04	1338987.0
2010-08-10 09:30:00	SPY	ETF	112.03	112.23	111.3701	111.67	25082979.0
2010-08-10 10:00:00	SPY	ETF	111.67	111.92	111.53	111.85	14220628.0
2010-08-10 10:30:00	SPY	ETF	111.85	111.86	111.57	111.67	8107110.0
2010-08-10 11:00:00	SPY	ETF	111.67	111.92	111.65	111.9	7442336.0
2010-08-10 11:30:00	SPY	ETF	111.89	112.03	111.87	111.96	6818105.0
2010-08-10 12:00:00	SPY	ETF	111.96	111.99	111.85	111.98	5123244.0
2010-08-10 12:30:00	SPY	ETF	111.98	111.98	111.82	111.87	5638138.0
2010-08-10 13:00:00	SPY	ETF	111.87	111.88	111.58	111.61	5804715.0
2010-08-10 13:30:00	SPY	ETF	111.605	111.8	111.55	111.73	6671191.0
2010-08-10 14:00:00	SPY	ETF	111.73	112.71	111.73	112.4	49174171.0
2010-08-10 14:30:00	SPY	ETF	112.39	112.98	112.37	112.58	35292181.0
2010-08-10 15:00:00	SPY	ETF	112.59	112.85	112.16	112.51	22251832.0
2010-08-10 15:30:00	SPY	ETF	112.51	112.78	112.3	112.42	26391697.0
2010-08-10 16:00:00	SPY	ETF	112.42	112.825	111.555	112.48	8479055.0
2010-08-10 16:30:00	SPY	ETF	112.47	113.0254	112.44	112.45	3649952.0
2010-08-10 17:00:00	SPY	ETF	112.47	113.0255	112.44	112.46	3543886.0
2010-08-10 17:30:00	SPY	ETF	112.46	112.51	112.45	112.5	38932.0
2010-08-10 18:00:00	SPY	ETF	112.48	112.48	112.39	112.42	125227.0
2010-08-10 18:30:00	SPY	ETF	112.43	112.46	112.43	112.45	3050.0
2010-08-10 19:00:00	SPY	ETF	112.43	112.43	112.4	112.4	30309.0
2010-08-10 19:30:00	SPY	ETF	112.41	112.44	112.23	112.23	68191.0
2010-08-10 04:00:00	QQQ	ETF	47.02	47.02	46.78	46.8	13361.0
2010-08-10 05:00:00	QQQ	ETF	46.81	46.81	46.81	46.81	7440.0
2010-08-10 05:30:00	QQQ	ETF	46.78	46.78	46.78	46.78	400.0
2010-08-10 06:00:00	QQQ	ETF	46.9	46.9	46.9	46.9	300.0
2010-08-10 06:30:00	QQQ	ETF	46.86	46.88	46.86	46.88	900.0
2010-08-10 07:00:00	QQQ	ETF	46.87	46.9	46.83	46.84	245750.0
2010-08-10 07:30:00	QQQ	ETF	46.83	46.84	46.78	46.8	449232.0
2010-08-10 08:00:00	QQQ	ETF	46.8	46.87	46.61	46.67	3314642.0
2010-08-10 08:30:00	QQQ	ETF	46.65	46.71	46.6	46.69	507164.0
2010-08-10 09:00:00	QQQ	ETF	46.69	46.75	46.65	46.71	441960.0
2010-08-10 09:30:00	QQQ	ETF	46.72	46.77	46.28	46.37	11766157.0
2010-08-10 10:00:00	QQQ	ETF	46.38	46.54	46.34	46.52	5973224.0
2010-08-10 10:30:00	QQQ	ETF	46.51	46.52	46.4	46.42	2751435.0
2010-08-10 11:00:00	QQQ	ETF	46.43	46.53	46.417	46.53	2187239.0
2010-08-10 11:30:00	QQQ	ETF	46.53	46.61	46.52	46.5721	2889344.0
2010-08-10 12:00:00	QQQ	ETF	46.58	46.5996	46.52	46.5799	1875273.0
2010-08-10 12:30:00	QQQ	ETF	46.58	46.58	46.48	46.5	1392119.0
2010-08-10 13:00:00	QQQ	ETF	46.5	46.5	46.31	46.325	2111335.0

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

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