PREVIEW / stock_30min / 2012-03-08

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-08.parquet
  size:    1.4 MB
  rows:    77,369
  symbols: 3,509

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-03-08 04:00:00	AAPL	Stock	19.0064	19.0554	19.0064	19.0482	79464.0
2012-03-08 04:30:00	AAPL	Stock	19.0482	19.075	19.0482	19.0696	22400.0
2012-03-08 05:00:00	AAPL	Stock	19.0507	19.0607	19.0507	19.0593	67200.0
2012-03-08 05:30:00	AAPL	Stock	19.0464	19.0464	19.0357	19.0357	53200.0
2012-03-08 06:00:00	AAPL	Stock	19.0464	19.0464	19.0143	19.0411	94920.0
2012-03-08 06:30:00	AAPL	Stock	19.0393	19.0589	19.0393	19.0589	86940.0
2012-03-08 07:00:00	AAPL	Stock	19.0639	19.0961	19.0536	19.0804	740992.0
2012-03-08 07:30:00	AAPL	Stock	19.0732	19.0743	19.0393	19.0618	525868.0
2012-03-08 08:00:00	AAPL	Stock	19.0614	19.1086	19.0093	19.0643	3271352.0
2012-03-08 08:30:00	AAPL	Stock	19.0636	19.0714	19.0196	19.0229	1923348.0
2012-03-08 09:00:00	AAPL	Stock	19.0296	19.1054	19.0286	19.1	2783032.0
2012-03-08 09:30:00	AAPL	Stock	19.0961	19.1389	19.0268	19.0647	67672668.0
2012-03-08 10:00:00	AAPL	Stock	19.0696	19.0804	19.0043	19.0736	46011812.0
2012-03-08 10:30:00	AAPL	Stock	19.0704	19.1129	19.0485	19.1057	29418844.0
2012-03-08 11:00:00	AAPL	Stock	19.1054	19.1207	19.0814	19.1161	21252028.0
2012-03-08 11:30:00	AAPL	Stock	19.1171	19.1879	19.1079	19.1806	31318812.0
2012-03-08 12:00:00	AAPL	Stock	19.1809	19.2454	19.1575	19.2322	31921736.0
2012-03-08 12:30:00	AAPL	Stock	19.2364	19.2804	19.2323	19.27	35677460.0
2012-03-08 13:00:00	AAPL	Stock	19.27	19.3054	19.2504	19.2954	25586036.0
2012-03-08 13:30:00	AAPL	Stock	19.2943	19.3457	19.2929	19.3344	31374364.0
2012-03-08 14:00:00	AAPL	Stock	19.3343	19.3846	19.25	19.3146	53899020.0
2012-03-08 14:30:00	AAPL	Stock	19.3164	19.3824	19.2889	19.3349	29976996.0
2012-03-08 15:00:00	AAPL	Stock	19.3347	19.3925	19.3307	19.3725	27538560.0
2012-03-08 15:30:00	AAPL	Stock	19.3729	19.3746	19.3161	19.3482	56430304.0
2012-03-08 16:00:00	AAPL	Stock	19.3571	19.3675	19.1011	19.3568	8812412.0
2012-03-08 16:30:00	AAPL	Stock	19.3543	19.3589	19.3479	19.35	224336.0
2012-03-08 17:00:00	AAPL	Stock	19.3471	19.3568	19.3396	19.3536	431144.0
2012-03-08 17:30:00	AAPL	Stock	19.3525	19.3571	19.3464	19.3568	203952.0
2012-03-08 18:00:00	AAPL	Stock	19.355	19.355	19.3468	19.3536	78792.0
2012-03-08 18:30:00	AAPL	Stock	19.3568	19.3611	19.3536	19.3607	344036.0
2012-03-08 19:00:00	AAPL	Stock	19.3618	19.3707	19.35	19.3521	716772.0
2012-03-08 19:30:00	AAPL	Stock	19.3536	19.3621	19.3529	19.3532	403480.0
2012-03-08 05:30:00	MSFT	Stock	32.05	32.05	32.05	32.05	100.0
2012-03-08 07:00:00	MSFT	Stock	32.15	32.15	32.15	32.15	500.0
2012-03-08 07:30:00	MSFT	Stock	32.15	32.15	32.13	32.13	875.0
2012-03-08 08:00:00	MSFT	Stock	32.15	32.15	31.91	32.04	23162.0
2012-03-08 08:30:00	MSFT	Stock	32.05	32.06	31.97	31.99	22622.0
2012-03-08 09:00:00	MSFT	Stock	31.99	32.06	31.99	32.03	12869.0
2012-03-08 09:30:00	MSFT	Stock	32.04	32.15	31.9	32.13	4999430.0
2012-03-08 10:00:00	MSFT	Stock	32.13	32.21	31.92	31.995	3710518.0
2012-03-08 10:30:00	MSFT	Stock	31.995	32.13	31.965	32.068	4515669.0
2012-03-08 11:00:00	MSFT	Stock	32.07	32.14	32.025	32.05	3208146.0
2012-03-08 11:30:00	MSFT	Stock	32.045	32.11	32.04	32.09	2494759.0
2012-03-08 12:00:00	MSFT	Stock	32.09	32.14	32.087	32.14	1756612.0
2012-03-08 12:30:00	MSFT	Stock	32.135	32.15	32.09	32.115	1664766.0
2012-03-08 13:00:00	MSFT	Stock	32.115	32.17	32.092	32.145	1255328.0
2012-03-08 13:30:00	MSFT	Stock	32.142	32.16	32.09	32.1	1024182.0
2012-03-08 14:00:00	MSFT	Stock	32.1	32.12	32.035	32.08	1430426.0
2012-03-08 14:30:00	MSFT	Stock	32.073	32.13	32.03	32.13	1953720.0
2012-03-08 15:00:00	MSFT	Stock	32.125	32.17	32.08	32.098	1469908.0

> showing 50 of 77,369 rows — these rows as CSV

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