PREVIEW / etf_30min / 2013-12-03

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-03.parquet
  size:    333 KB
  rows:    11,236

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
2013-12-03 04:00:00	SPY	ETF	180.66	180.66	180.32	180.32	2927.0
2013-12-03 04:30:00	SPY	ETF	180.29	180.29	180.23	180.24	1649.0
2013-12-03 05:00:00	SPY	ETF	180.24	180.24	180.14	180.14	9194.0
2013-12-03 05:30:00	SPY	ETF	180.11	180.14	180.05	180.05	3300.0
2013-12-03 06:00:00	SPY	ETF	180.07	180.07	179.9	179.94	60286.0
2013-12-03 06:30:00	SPY	ETF	179.94	179.94	179.89	179.93	60261.0
2013-12-03 07:00:00	SPY	ETF	179.94	180.05	179.94	180.0	112792.0
2013-12-03 07:30:00	SPY	ETF	180.0	180.05	179.89	180.05	285717.0
2013-12-03 08:00:00	SPY	ETF	180.05	180.1	179.94	180.05	159131.0
2013-12-03 08:30:00	SPY	ETF	180.05	180.06	179.89	179.9	351048.0
2013-12-03 09:00:00	SPY	ETF	179.9	179.99	179.76	179.95	2335983.0
2013-12-03 09:30:00	SPY	ETF	179.94	180.29	179.84	180.27	13301007.0
2013-12-03 10:00:00	SPY	ETF	180.27	180.39	180.11	180.15	11015173.0
2013-12-03 10:30:00	SPY	ETF	180.155	180.37	180.13	180.28	4966323.0
2013-12-03 11:00:00	SPY	ETF	180.29	180.318	179.7699	179.8104	8102583.0
2013-12-03 11:30:00	SPY	ETF	179.82	179.85	179.47	179.691	8229061.0
2013-12-03 12:00:00	SPY	ETF	179.69	179.87	179.61	179.72	4763227.0
2013-12-03 12:30:00	SPY	ETF	179.73	179.84	179.67	179.7616	2316062.0
2013-12-03 13:00:00	SPY	ETF	179.7607	179.79	179.31	179.375	5763326.0
2013-12-03 13:30:00	SPY	ETF	179.38	179.53	179.31	179.405	5238475.0
2013-12-03 14:00:00	SPY	ETF	179.41	179.44	179.17	179.38	5933440.0
2013-12-03 14:30:00	SPY	ETF	179.39	179.74	179.34	179.73	5086966.0
2013-12-03 15:00:00	SPY	ETF	179.73	179.73	179.4	179.48	4178213.0
2013-12-03 15:30:00	SPY	ETF	179.48	179.97	179.42	179.88	13661703.0
2013-12-03 16:00:00	SPY	ETF	179.88	180.5056	179.68	179.7	10195508.0
2013-12-03 16:30:00	SPY	ETF	179.69	179.9355	179.63	179.7	2310800.0
2013-12-03 17:00:00	SPY	ETF	179.7	179.8437	179.7	179.8437	116282.0
2013-12-03 17:30:00	SPY	ETF	179.71	179.73	179.66	179.73	46413.0
2013-12-03 18:00:00	SPY	ETF	179.73	179.8	179.7	179.79	55688.0
2013-12-03 18:30:00	SPY	ETF	179.75	179.77	179.7	179.73	124855.0
2013-12-03 19:00:00	SPY	ETF	179.76	179.79	179.73	179.79	46700.0
2013-12-03 19:30:00	SPY	ETF	179.77	179.84	179.75	179.82	91175.0
2013-12-03 04:00:00	QQQ	ETF	85.49	85.49	85.49	85.49	1200.0
2013-12-03 04:30:00	QQQ	ETF	85.5	85.5	85.5	85.5	800.0
2013-12-03 05:00:00	QQQ	ETF	85.48	85.48	85.45	85.45	35000.0
2013-12-03 05:30:00	QQQ	ETF	85.44	85.44	85.41	85.41	6600.0
2013-12-03 06:00:00	QQQ	ETF	85.39	85.39	85.35	85.38	3900.0
2013-12-03 06:30:00	QQQ	ETF	85.35	85.38	85.35	85.38	2400.0
2013-12-03 07:00:00	QQQ	ETF	85.4	85.42	85.38	85.4	15900.0
2013-12-03 07:30:00	QQQ	ETF	85.39	85.41	85.35	85.4	13905.0
2013-12-03 08:00:00	QQQ	ETF	85.36	85.4	85.36	85.39	48443.0
2013-12-03 08:30:00	QQQ	ETF	85.4	85.41	85.36	85.38	139227.0
2013-12-03 09:00:00	QQQ	ETF	85.38	85.46	85.35	85.43	224321.0
2013-12-03 09:30:00	QQQ	ETF	85.42	85.565	85.32	85.5095	5159925.0
2013-12-03 10:00:00	QQQ	ETF	85.51	85.64	85.43	85.49	3396757.0
2013-12-03 10:30:00	QQQ	ETF	85.5	85.59	85.49	85.51	1293466.0
2013-12-03 11:00:00	QQQ	ETF	85.52	85.56	85.35	85.389	2831851.0
2013-12-03 11:30:00	QQQ	ETF	85.38	85.38	85.18	85.3	2591423.0
2013-12-03 12:00:00	QQQ	ETF	85.29	85.36	85.25	85.271	1152657.0
2013-12-03 12:30:00	QQQ	ETF	85.27	85.36	85.25	85.35	692054.0

> showing 50 of 11,236 rows — these rows as CSV

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