PREVIEW / etf_30min / 2014-03-25

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-03-25.parquet
  size:    335 KB
  rows:    11,301

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
2014-03-25 04:00:00	SPY	ETF	185.38	185.74	185.38	185.74	3825.0
2014-03-25 04:30:00	SPY	ETF	185.59	185.6	185.48	185.48	3400.0
2014-03-25 05:00:00	SPY	ETF	185.46	185.72	185.46	185.69	9423.0
2014-03-25 05:30:00	SPY	ETF	185.72	185.8	185.68	185.76	10351.0
2014-03-25 06:00:00	SPY	ETF	185.74	185.74	185.64	185.7	15115.0
2014-03-25 06:30:00	SPY	ETF	185.72	185.8	185.67	185.75	38225.0
2014-03-25 07:00:00	SPY	ETF	185.78	185.94	185.68	185.91	94454.0
2014-03-25 07:30:00	SPY	ETF	185.91	186.12	185.91	186.0	160226.0
2014-03-25 08:00:00	SPY	ETF	186.01	186.14	185.98	186.131	248613.0
2014-03-25 08:30:00	SPY	ETF	186.14	186.34	186.13	186.3	301066.0
2014-03-25 09:00:00	SPY	ETF	186.28	186.39	186.19	186.38	548393.0
2014-03-25 09:30:00	SPY	ETF	186.37	186.76	186.36	186.58	12163659.0
2014-03-25 10:00:00	SPY	ETF	186.59	186.94	186.32	186.445	12027550.0
2014-03-25 10:30:00	SPY	ETF	186.45	186.47	185.65	185.76	9629521.0
2014-03-25 11:00:00	SPY	ETF	185.755	186.14	185.67	185.92	7346868.0
2014-03-25 11:30:00	SPY	ETF	185.91	185.97	185.34	185.63	6676278.0
2014-03-25 12:00:00	SPY	ETF	185.625	185.77	185.27	185.445	5988825.0
2014-03-25 12:30:00	SPY	ETF	185.45	186.07	185.38	185.97	4839469.0
2014-03-25 13:00:00	SPY	ETF	185.97	186.45	185.88	186.39	5180617.0
2014-03-25 13:30:00	SPY	ETF	186.391	186.54	186.26	186.335	6977345.0
2014-03-25 14:00:00	SPY	ETF	186.33	186.56	186.17	186.195	4741137.0
2014-03-25 14:30:00	SPY	ETF	186.2	186.35	186.1	186.2	4333505.0
2014-03-25 15:00:00	SPY	ETF	186.2	186.55	186.14	186.36	5008029.0
2014-03-25 15:30:00	SPY	ETF	186.36	186.51	186.21	186.34	11458113.0
2014-03-25 16:00:00	SPY	ETF	186.34	186.45	186.2701	186.39	3569277.0
2014-03-25 16:30:00	SPY	ETF	186.41	186.42	186.31	186.37	210348.0
2014-03-25 17:00:00	SPY	ETF	186.37	186.43	186.369	186.43	103133.0
2014-03-25 17:30:00	SPY	ETF	186.41	186.44	186.38	186.43	113191.0
2014-03-25 18:00:00	SPY	ETF	186.41	186.58	186.35	186.56	177492.0
2014-03-25 18:30:00	SPY	ETF	186.54	186.57	186.54	186.57	61115.0
2014-03-25 19:00:00	SPY	ETF	186.57	186.65	186.57	186.63	93212.0
2014-03-25 19:30:00	SPY	ETF	186.6	186.68	186.59	186.68	63316.0
2014-03-25 04:00:00	QQQ	ETF	88.21	88.42	88.21	88.35	17874.0
2014-03-25 04:30:00	QQQ	ETF	88.33	88.33	88.33	88.33	5000.0
2014-03-25 05:30:00	QQQ	ETF	88.36	88.43	88.36	88.43	2900.0
2014-03-25 06:00:00	QQQ	ETF	88.4	88.4	88.4	88.4	200.0
2014-03-25 06:30:00	QQQ	ETF	88.4	88.44	88.38	88.44	2700.0
2014-03-25 07:00:00	QQQ	ETF	88.4	88.44	88.38	88.43	10700.0
2014-03-25 07:30:00	QQQ	ETF	88.48	88.54	88.46	88.54	8260.0
2014-03-25 08:00:00	QQQ	ETF	88.53	88.58	88.37	88.58	23300.0
2014-03-25 08:30:00	QQQ	ETF	88.6	88.68	88.57	88.67	72772.0
2014-03-25 09:00:00	QQQ	ETF	88.65	88.69	88.59	88.68	178917.0
2014-03-25 09:30:00	QQQ	ETF	88.69	89.03	88.68	89.0	5090842.0
2014-03-25 10:00:00	QQQ	ETF	89.01	89.25	88.81	88.91	5251740.0
2014-03-25 10:30:00	QQQ	ETF	88.915	88.93	88.13	88.22	4641520.0
2014-03-25 11:00:00	QQQ	ETF	88.22	88.53	88.16	88.41	3256034.0
2014-03-25 11:30:00	QQQ	ETF	88.4	88.43	87.8	87.979	2979250.0
2014-03-25 12:00:00	QQQ	ETF	87.97	88.09	87.7701	87.89	3832668.0
2014-03-25 12:30:00	QQQ	ETF	87.9	88.39	87.84	88.31	2660491.0
2014-03-25 13:00:00	QQQ	ETF	88.31	88.59	88.2144	88.569	2032390.0

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

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