PREVIEW / etf_30min / 2010-08-03

all etf 30-min files

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

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-03 04:00:00	SPY	ETF	112.52	112.52	112.37	112.47	23300.0
2010-08-03 04:30:00	SPY	ETF	112.44	112.47	112.44	112.47	1100.0
2010-08-03 05:00:00	SPY	ETF	112.5	112.5	112.5	112.5	100.0
2010-08-03 05:30:00	SPY	ETF	112.5	112.6	112.5	112.5	2456.0
2010-08-03 06:00:00	SPY	ETF	112.62	112.72	112.62	112.68	3750.0
2010-08-03 06:30:00	SPY	ETF	112.68	112.68	112.52	112.52	10725.0
2010-08-03 07:00:00	SPY	ETF	112.52	112.59	112.31	112.34	219300.0
2010-08-03 07:30:00	SPY	ETF	112.36	112.52	112.35	112.51	332767.0
2010-08-03 08:00:00	SPY	ETF	112.52	112.6	112.35	112.48	535724.0
2010-08-03 08:30:00	SPY	ETF	112.45	112.64	112.32	112.59	956026.0
2010-08-03 09:00:00	SPY	ETF	112.59	112.59	112.39	112.47	746863.0
2010-08-03 09:30:00	SPY	ETF	112.48	112.56	112.07	112.17	18848640.0
2010-08-03 10:00:00	SPY	ETF	112.2	112.21	111.85	112.08	17612228.0
2010-08-03 10:30:00	SPY	ETF	112.075	112.53	112.01	112.48	14087670.0
2010-08-03 11:00:00	SPY	ETF	112.48	112.62	112.34	112.44	8010049.0
2010-08-03 11:30:00	SPY	ETF	112.44	112.77	112.4	112.57	10586027.0
2010-08-03 12:00:00	SPY	ETF	112.56	112.58	112.14	112.2	7946271.0
2010-08-03 12:30:00	SPY	ETF	112.21	112.5	112.18	112.33	5280134.0
2010-08-03 13:00:00	SPY	ETF	112.33	112.37	112.12	112.3	5981501.0
2010-08-03 13:30:00	SPY	ETF	112.2981	112.44	112.27	112.33	5342704.0
2010-08-03 14:00:00	SPY	ETF	112.33	112.5	112.26	112.5	6020413.0
2010-08-03 14:30:00	SPY	ETF	112.5	112.51	112.28	112.4	6754412.0
2010-08-03 15:00:00	SPY	ETF	112.4	112.44	112.15	112.2399	8502070.0
2010-08-03 15:30:00	SPY	ETF	112.23	112.3	111.97	112.2	19459027.0
2010-08-03 16:00:00	SPY	ETF	112.2	112.595	111.975	112.35	7138481.0
2010-08-03 16:30:00	SPY	ETF	112.34	112.42	112.29	112.39	169288.0
2010-08-03 17:00:00	SPY	ETF	112.39	112.42	112.35	112.4	96789.0
2010-08-03 17:30:00	SPY	ETF	112.38	112.39	112.33	112.39	53108.0
2010-08-03 18:00:00	SPY	ETF	112.39	112.4	112.22	112.34	144554.0
2010-08-03 18:30:00	SPY	ETF	112.34	112.35	112.32	112.33	24875.0
2010-08-03 19:00:00	SPY	ETF	112.33	112.36	112.3	112.36	5500.0
2010-08-03 19:30:00	SPY	ETF	112.32	112.38	112.32	112.38	12299.0
2010-08-03 04:00:00	QQQ	ETF	46.59	46.59	46.59	46.59	400.0
2010-08-03 05:00:00	QQQ	ETF	46.58	46.58	46.58	46.58	200.0
2010-08-03 06:30:00	QQQ	ETF	46.65	46.66	46.65	46.66	10000.0
2010-08-03 07:00:00	QQQ	ETF	46.61	46.61	46.52	46.55	13328.0
2010-08-03 07:30:00	QQQ	ETF	46.58	46.59	46.58	46.59	3800.0
2010-08-03 08:00:00	QQQ	ETF	46.59	46.658	46.58	46.6	54190.0
2010-08-03 08:30:00	QQQ	ETF	46.59	46.66	46.53	46.65	112965.0
2010-08-03 09:00:00	QQQ	ETF	46.64	46.64	46.6	46.63	117459.0
2010-08-03 09:30:00	QQQ	ETF	46.63	46.7	46.32	46.38	7721347.0
2010-08-03 10:00:00	QQQ	ETF	46.37	46.41	46.25	46.36	4274952.0
2010-08-03 10:30:00	QQQ	ETF	46.36	46.57	46.33	46.56	6617691.0
2010-08-03 11:00:00	QQQ	ETF	46.565	46.63	46.49	46.53	3445946.0
2010-08-03 11:30:00	QQQ	ETF	46.53	46.7	46.53	46.635	5493571.0
2010-08-03 12:00:00	QQQ	ETF	46.63	46.635	46.37	46.41	4596335.0
2010-08-03 12:30:00	QQQ	ETF	46.42	46.55	46.41	46.46	4288745.0
2010-08-03 13:00:00	QQQ	ETF	46.4699	46.5	46.3815	46.47	3538675.0
2010-08-03 13:30:00	QQQ	ETF	46.47	46.55	46.46	46.48	1967162.0
2010-08-03 14:00:00	QQQ	ETF	46.49	46.56	46.45	46.56	1439331.0

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

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