PREVIEW / stock_30min / 2011-05-12

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-12.parquet
  size:    1.4 MB
  rows:    75,495
  symbols: 3,566

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
2011-05-12 04:00:00	AAPL	Stock	12.3929	12.3929	12.3929	12.3929	5600.0
2011-05-12 04:30:00	AAPL	Stock	12.3293	12.3479	12.3293	12.3479	5600.0
2011-05-12 05:00:00	AAPL	Stock	12.3457	12.3457	12.3457	12.3457	2800.0
2011-05-12 05:30:00	AAPL	Stock	12.33	12.33	12.3214	12.3214	5600.0
2011-05-12 06:00:00	AAPL	Stock	12.3307	12.3307	12.295	12.3107	25200.0
2011-05-12 06:30:00	AAPL	Stock	12.3046	12.3107	12.3046	12.3107	30100.0
2011-05-12 07:00:00	AAPL	Stock	12.3214	12.3354	12.3143	12.3307	124740.0
2011-05-12 07:30:00	AAPL	Stock	12.3275	12.3393	12.315	12.3336	283164.0
2011-05-12 08:00:00	AAPL	Stock	12.3321	12.3414	12.3186	12.3389	1353800.0
2011-05-12 08:30:00	AAPL	Stock	12.3339	12.3614	12.3225	12.3504	1185184.0
2011-05-12 09:00:00	AAPL	Stock	12.3479	12.3746	12.3454	12.3646	926996.0
2011-05-12 09:30:00	AAPL	Stock	12.3614	12.3732	12.2339	12.2679	75826016.0
2011-05-12 10:00:00	AAPL	Stock	12.27	12.3389	12.2239	12.3146	46655588.0
2011-05-12 10:30:00	AAPL	Stock	12.3129	12.3343	12.2846	12.2954	19611228.0
2011-05-12 11:00:00	AAPL	Stock	12.2954	12.3468	12.2832	12.3361	18335044.0
2011-05-12 11:30:00	AAPL	Stock	12.3389	12.3557	12.3183	12.3211	16771972.0
2011-05-12 12:00:00	AAPL	Stock	12.3204	12.3321	12.2982	12.3125	9073736.0
2011-05-12 12:30:00	AAPL	Stock	12.3129	12.3411	12.3054	12.3396	8497104.0
2011-05-12 13:00:00	AAPL	Stock	12.3404	12.3661	12.3395	12.3439	17938928.0
2011-05-12 13:30:00	AAPL	Stock	12.3457	12.3568	12.3236	12.3511	13692196.0
2011-05-12 14:00:00	AAPL	Stock	12.3521	12.3971	12.3514	12.3771	20126036.0
2011-05-12 14:30:00	AAPL	Stock	12.3771	12.3889	12.3625	12.37	12009228.0
2011-05-12 15:00:00	AAPL	Stock	12.3693	12.3862	12.35	12.3689	17895920.0
2011-05-12 15:30:00	AAPL	Stock	12.3686	12.3829	12.3532	12.3782	27969228.0
2011-05-12 16:00:00	AAPL	Stock	12.3771	12.3825	12.3139	12.3757	6941732.0
2011-05-12 16:30:00	AAPL	Stock	12.3746	12.3843	12.3094	12.375	1315804.0
2011-05-12 17:00:00	AAPL	Stock	12.3732	12.3764	12.3654	12.3661	360332.0
2011-05-12 17:30:00	AAPL	Stock	12.3664	12.3664	12.3536	12.36	397264.0
2011-05-12 18:00:00	AAPL	Stock	12.3539	12.3775	12.3429	12.3471	421344.0
2011-05-12 18:30:00	AAPL	Stock	12.345	12.3525	12.34	12.3525	366604.0
2011-05-12 19:00:00	AAPL	Stock	12.3546	12.3571	12.3546	12.3546	39200.0
2011-05-12 19:30:00	AAPL	Stock	12.3504	12.3564	12.3482	12.3539	63840.0
2011-05-12 06:00:00	MSFT	Stock	25.17	25.17	25.17	25.17	100.0
2011-05-12 07:00:00	MSFT	Stock	25.15	25.22	25.15	25.22	800.0
2011-05-12 07:30:00	MSFT	Stock	25.22	25.22	25.21	25.22	800.0
2011-05-12 08:00:00	MSFT	Stock	25.21	25.36	25.19	25.19	30657.0
2011-05-12 08:30:00	MSFT	Stock	25.19	25.25	25.19	25.25	5100.0
2011-05-12 09:00:00	MSFT	Stock	25.25	25.42	25.25	25.36	49940.0
2011-05-12 09:30:00	MSFT	Stock	25.35	25.39	25.2	25.275	8065686.0
2011-05-12 10:00:00	MSFT	Stock	25.275	25.37	25.22	25.24	7199532.0
2011-05-12 10:30:00	MSFT	Stock	25.241	25.28	25.18	25.21	5013329.0
2011-05-12 11:00:00	MSFT	Stock	25.21	25.21	25.1	25.115	8654237.0
2011-05-12 11:30:00	MSFT	Stock	25.115	25.18	25.11	25.13	5026223.0
2011-05-12 12:00:00	MSFT	Stock	25.13	25.21	25.11	25.2	3383526.0
2011-05-12 12:30:00	MSFT	Stock	25.2	25.22	25.15	25.197	3005504.0
2011-05-12 13:00:00	MSFT	Stock	25.2	25.29	25.19	25.26	4080347.0
2011-05-12 13:30:00	MSFT	Stock	25.26	25.32	25.25	25.29	4150003.0
2011-05-12 14:00:00	MSFT	Stock	25.3	25.33	25.22	25.26	5724239.0
2011-05-12 14:30:00	MSFT	Stock	25.26	25.31	25.21	25.23	3939111.0
2011-05-12 15:00:00	MSFT	Stock	25.22	25.31	25.21	25.28	4791513.0

> showing 50 of 75,495 rows — these rows as CSV

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