PREVIEW / etf_30min / 2013-01-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-08.parquet
  size:    294 KB
  rows:    10,103

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-01-08 04:00:00	SPY	ETF	145.63	145.63	145.63	145.63	500.0
2013-01-08 05:00:00	SPY	ETF	145.69	145.69	145.59	145.67	16300.0
2013-01-08 05:30:00	SPY	ETF	145.69	145.84	145.69	145.84	33300.0
2013-01-08 06:00:00	SPY	ETF	145.85	145.86	145.76	145.86	3500.0
2013-01-08 06:30:00	SPY	ETF	145.86	145.99	145.84	145.94	94305.0
2013-01-08 07:00:00	SPY	ETF	145.94	145.97	145.87	145.87	32372.0
2013-01-08 07:30:00	SPY	ETF	145.85	145.87	145.71	145.78	95278.0
2013-01-08 08:00:00	SPY	ETF	145.79	145.87	145.7	145.75	295251.0
2013-01-08 08:30:00	SPY	ETF	145.75	145.85	145.59	145.66	262494.0
2013-01-08 09:00:00	SPY	ETF	145.65	145.72	145.55	145.71	625194.0
2013-01-08 09:30:00	SPY	ETF	145.71	145.91	145.51	145.54	12091855.0
2013-01-08 10:00:00	SPY	ETF	145.53	145.59	145.23	145.37	11394920.0
2013-01-08 10:30:00	SPY	ETF	145.36	145.39	145.09	145.17	9368790.0
2013-01-08 11:00:00	SPY	ETF	145.17	145.23	144.98	145.105	7784254.0
2013-01-08 11:30:00	SPY	ETF	145.105	145.3	145.09	145.2875	6841976.0
2013-01-08 12:00:00	SPY	ETF	145.28	145.37	145.25	145.259	5066176.0
2013-01-08 12:30:00	SPY	ETF	145.25	145.3	145.1	145.13	5221139.0
2013-01-08 13:00:00	SPY	ETF	145.135	145.36	145.13	145.329	4301379.0
2013-01-08 13:30:00	SPY	ETF	145.32	145.42	145.29	145.395	7611259.0
2013-01-08 14:00:00	SPY	ETF	145.39	145.52	145.33	145.3701	5681531.0
2013-01-08 14:30:00	SPY	ETF	145.375	145.43	145.24	145.31	2690636.0
2013-01-08 15:00:00	SPY	ETF	145.31	145.63	145.3	145.59	4963398.0
2013-01-08 15:30:00	SPY	ETF	145.58	145.62	145.29	145.54	13779472.0
2013-01-08 16:00:00	SPY	ETF	145.53	146.0369	145.2	145.6	15228681.0
2013-01-08 16:30:00	SPY	ETF	145.59	146.0369	145.5	145.5	4179627.0
2013-01-08 17:00:00	SPY	ETF	145.5	145.55	145.48	145.55	419872.0
2013-01-08 17:30:00	SPY	ETF	145.57	145.57	145.51	145.53	12180.0
2013-01-08 18:00:00	SPY	ETF	145.53	145.62	145.53	145.62	10726.0
2013-01-08 18:30:00	SPY	ETF	145.6	145.62	145.6	145.6	4132.0
2013-01-08 19:00:00	SPY	ETF	145.6	145.8	145.6	145.76	28683.0
2013-01-08 19:30:00	SPY	ETF	145.71	145.71	145.6	145.67	87700.0
2013-01-08 06:00:00	QQQ	ETF	66.58	66.58	66.58	66.58	600.0
2013-01-08 06:30:00	QQQ	ETF	66.68	66.69	66.68	66.69	950.0
2013-01-08 07:00:00	QQQ	ETF	66.66	66.66	66.61	66.61	2300.0
2013-01-08 07:30:00	QQQ	ETF	66.62	66.62	66.6	66.6	300.0
2013-01-08 08:00:00	QQQ	ETF	66.58	66.59	66.54	66.54	16435.0
2013-01-08 08:30:00	QQQ	ETF	66.55	66.7	66.55	66.6	459400.0
2013-01-08 09:00:00	QQQ	ETF	66.59	66.65	66.57	66.64	202010.0
2013-01-08 09:30:00	QQQ	ETF	66.64	66.815	66.47	66.5	4562409.0
2013-01-08 10:00:00	QQQ	ETF	66.5	66.54	66.39	66.49	2089796.0
2013-01-08 10:30:00	QQQ	ETF	66.49	66.5	66.26	66.3	2239878.0
2013-01-08 11:00:00	QQQ	ETF	66.305	66.35	66.17	66.21	1602145.0
2013-01-08 11:30:00	QQQ	ETF	66.22	66.33	66.21	66.32	1490896.0
2013-01-08 12:00:00	QQQ	ETF	66.32	66.38	66.29	66.29	857394.0
2013-01-08 12:30:00	QQQ	ETF	66.291	66.32	66.2	66.235	1161087.0
2013-01-08 13:00:00	QQQ	ETF	66.235	66.44	66.23	66.41	1187275.0
2013-01-08 13:30:00	QQQ	ETF	66.41	66.5	66.39	66.47	904554.0
2013-01-08 14:00:00	QQQ	ETF	66.48	66.5499	66.43	66.46	1086541.0
2013-01-08 14:30:00	QQQ	ETF	66.46	66.51	66.35	66.4	608893.0
2013-01-08 15:00:00	QQQ	ETF	66.39	66.61	66.39	66.58	1218646.0

> showing 50 of 10,103 rows — these rows as CSV

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