PREVIEW / etf_30min / 2012-09-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-19.parquet
  size:    288 KB
  rows:    9,923

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
2012-09-19 04:00:00	SPY	ETF	147.02	147.06	147.02	147.06	1849.0
2012-09-19 04:30:00	SPY	ETF	146.93	146.93	146.71	146.72	8149.0
2012-09-19 05:00:00	SPY	ETF	146.8	146.8	146.8	146.8	200.0
2012-09-19 05:30:00	SPY	ETF	146.81	146.85	146.75	146.76	7445.0
2012-09-19 06:00:00	SPY	ETF	146.69	146.8	146.69	146.77	3700.0
2012-09-19 06:30:00	SPY	ETF	146.77	146.82	146.74	146.75	40300.0
2012-09-19 07:00:00	SPY	ETF	146.75	146.78	146.65	146.75	49068.0
2012-09-19 07:30:00	SPY	ETF	146.72	146.78	146.65	146.68	102045.0
2012-09-19 08:00:00	SPY	ETF	146.68	146.85	146.63	146.84	238636.0
2012-09-19 08:30:00	SPY	ETF	146.84	146.85	146.72	146.83	309840.0
2012-09-19 09:00:00	SPY	ETF	146.83	146.91	146.3855	146.79	427897.0
2012-09-19 09:30:00	SPY	ETF	146.79	146.8	146.41	146.52	10609371.0
2012-09-19 10:00:00	SPY	ETF	146.53	146.97	146.52	146.72	11952881.0
2012-09-19 10:30:00	SPY	ETF	146.71	146.77	146.48	146.675	11555187.0
2012-09-19 11:00:00	SPY	ETF	146.67	147.06	146.62	146.975	7605357.0
2012-09-19 11:30:00	SPY	ETF	146.98	147.06	146.9	146.95	3611205.0
2012-09-19 12:00:00	SPY	ETF	146.957	147.16	146.88	147.13	4951256.0
2012-09-19 12:30:00	SPY	ETF	147.13	147.17	147.01	147.0798	3369516.0
2012-09-19 13:00:00	SPY	ETF	147.075	147.11	146.91	146.935	4886434.0
2012-09-19 13:30:00	SPY	ETF	146.94	147.02	146.83	146.925	5540292.0
2012-09-19 14:00:00	SPY	ETF	146.93	147.09	146.91	147.01	3702514.0
2012-09-19 14:30:00	SPY	ETF	147.015	147.12	146.97	147.115	3743177.0
2012-09-19 15:00:00	SPY	ETF	147.12	147.16	147.01	147.015	5372031.0
2012-09-19 15:30:00	SPY	ETF	147.01	147.05	146.7	146.7	15718519.0
2012-09-19 16:00:00	SPY	ETF	146.7	146.9075	146.45	146.61	9959100.0
2012-09-19 16:30:00	SPY	ETF	146.63	146.66	146.42	146.45	15466971.0
2012-09-19 17:00:00	SPY	ETF	146.46	146.53	146.46	146.5	6582675.0
2012-09-19 17:30:00	SPY	ETF	146.51	146.52	146.49	146.52	38038.0
2012-09-19 18:00:00	SPY	ETF	146.51	146.53	146.49	146.53	76348.0
2012-09-19 18:30:00	SPY	ETF	146.54	146.59	146.54	146.59	12200.0
2012-09-19 19:00:00	SPY	ETF	146.6	146.63	146.59	146.59	16500.0
2012-09-19 19:30:00	SPY	ETF	146.56	146.63	146.54	146.54	44990.0
2012-09-19 07:00:00	QQQ	ETF	70.3	70.32	70.3	70.32	200.0
2012-09-19 07:30:00	QQQ	ETF	70.3	70.31	70.29	70.31	12300.0
2012-09-19 08:00:00	QQQ	ETF	70.29	70.36	70.27	70.33	23515.0
2012-09-19 08:30:00	QQQ	ETF	70.34	70.34	70.3	70.3	43463.0
2012-09-19 09:00:00	QQQ	ETF	70.3	70.33	70.27	70.28	91986.0
2012-09-19 09:30:00	QQQ	ETF	70.29	70.31	70.09	70.2	3238076.0
2012-09-19 10:00:00	QQQ	ETF	70.22	70.35	70.19	70.2	2507629.0
2012-09-19 10:30:00	QQQ	ETF	70.2	70.24	70.06	70.2	1937944.0
2012-09-19 11:00:00	QQQ	ETF	70.21	70.37	70.19	70.34	1925488.0
2012-09-19 11:30:00	QQQ	ETF	70.34	70.42	70.3	70.35	1203941.0
2012-09-19 12:00:00	QQQ	ETF	70.3587	70.48	70.31	70.471	1456615.0
2012-09-19 12:30:00	QQQ	ETF	70.47	70.49	70.42	70.4399	543636.0
2012-09-19 13:00:00	QQQ	ETF	70.4391	70.46	70.3709	70.42	1345747.0
2012-09-19 13:30:00	QQQ	ETF	70.43	70.46	70.36	70.42	639629.0
2012-09-19 14:00:00	QQQ	ETF	70.41	70.52	70.4	70.49	889922.0
2012-09-19 14:30:00	QQQ	ETF	70.5	70.55	70.49	70.54	722849.0
2012-09-19 15:00:00	QQQ	ETF	70.54	70.58	70.5	70.54	1721791.0
2012-09-19 15:30:00	QQQ	ETF	70.54	70.54	70.38	70.39	3490292.0

> showing 50 of 9,923 rows — these rows as CSV

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