PREVIEW / stock_30min / 2011-05-31

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-31.parquet
  size:    1.5 MB
  rows:    78,958
  symbols: 3,570

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-31 04:00:00	AAPL	Stock	12.0714	12.145	12.0714	12.145	28784.0
2011-05-31 04:30:00	AAPL	Stock	12.1454	12.1489	12.1454	12.1489	5600.0
2011-05-31 07:00:00	AAPL	Stock	12.1429	12.1557	12.1271	12.1546	376180.0
2011-05-31 07:30:00	AAPL	Stock	12.1582	12.175	12.1339	12.1339	344400.0
2011-05-31 08:00:00	AAPL	Stock	12.1293	12.1425	12.125	12.1257	543676.0
2011-05-31 08:30:00	AAPL	Stock	12.1339	12.1961	12.1339	12.1696	2023056.0
2011-05-31 09:00:00	AAPL	Stock	12.1654	12.2018	12.1636	12.1821	2051336.0
2011-05-31 09:30:00	AAPL	Stock	12.1821	12.2843	12.1786	12.2393	75253472.0
2011-05-31 10:00:00	AAPL	Stock	12.2389	12.2889	12.2361	12.2521	40127220.0
2011-05-31 10:30:00	AAPL	Stock	12.2512	12.2661	12.225	12.2632	23439080.0
2011-05-31 11:00:00	AAPL	Stock	12.2639	12.2707	12.2429	12.2527	14671692.0
2011-05-31 11:30:00	AAPL	Stock	12.2529	12.2646	12.2429	12.2514	10500560.0
2011-05-31 12:00:00	AAPL	Stock	12.2511	12.2643	12.2364	12.2611	11387628.0
2011-05-31 12:30:00	AAPL	Stock	12.2611	12.2818	12.2411	12.2593	18725644.0
2011-05-31 13:00:00	AAPL	Stock	12.2593	12.2829	12.2593	12.2782	11676392.0
2011-05-31 13:30:00	AAPL	Stock	12.2771	12.3082	12.2736	12.3071	18505284.0
2011-05-31 14:00:00	AAPL	Stock	12.3071	12.3421	12.3025	12.3277	33352396.0
2011-05-31 14:30:00	AAPL	Stock	12.3268	12.3507	12.3064	12.34	27479704.0
2011-05-31 15:00:00	AAPL	Stock	12.34	12.37	12.3325	12.3571	31370360.0
2011-05-31 15:30:00	AAPL	Stock	12.3571	12.4193	12.3507	12.4171	60350024.0
2011-05-31 16:00:00	AAPL	Stock	12.4225	12.4332	12.2852	12.4179	23528960.0
2011-05-31 16:30:00	AAPL	Stock	12.4175	12.43	12.2939	12.4225	2241820.0
2011-05-31 17:00:00	AAPL	Stock	12.4246	12.4382	12.2674	12.4375	234612.0
2011-05-31 17:30:00	AAPL	Stock	12.4375	12.4411	12.4223	12.4393	424424.0
2011-05-31 18:00:00	AAPL	Stock	12.4304	12.4411	12.4225	12.4332	231588.0
2011-05-31 18:30:00	AAPL	Stock	12.4332	12.4404	12.4325	12.4404	144760.0
2011-05-31 19:00:00	AAPL	Stock	12.4407	12.4629	12.4407	12.4514	335720.0
2011-05-31 19:30:00	AAPL	Stock	12.4614	12.4643	12.4568	12.4643	201600.0
2011-05-31 04:00:00	MSFT	Stock	24.92	25.05	24.92	25.05	775.0
2011-05-31 05:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	100.0
2011-05-31 06:00:00	MSFT	Stock	25.05	25.05	25.05	25.05	200.0
2011-05-31 06:30:00	MSFT	Stock	25.05	25.05	25.04	25.04	400.0
2011-05-31 07:00:00	MSFT	Stock	25.04	25.04	25.0	25.03	1900.0
2011-05-31 07:30:00	MSFT	Stock	25.04	25.04	25.0	25.0	5150.0
2011-05-31 08:00:00	MSFT	Stock	24.99	24.99	24.9	24.93	27074.0
2011-05-31 08:30:00	MSFT	Stock	24.93	24.93	24.87	24.88	18950.0
2011-05-31 09:00:00	MSFT	Stock	24.88	24.96	24.87	24.96	33477.0
2011-05-31 09:30:00	MSFT	Stock	24.98	25.06	24.8	24.84	7756805.0
2011-05-31 10:00:00	MSFT	Stock	24.84	24.86	24.78	24.788	3605703.0
2011-05-31 10:30:00	MSFT	Stock	24.785	24.82	24.75	24.75	4701471.0
2011-05-31 11:00:00	MSFT	Stock	24.75	24.8	24.7	24.746	2765991.0
2011-05-31 11:30:00	MSFT	Stock	24.75	24.8	24.72	24.73	2431241.0
2011-05-31 12:00:00	MSFT	Stock	24.73	24.78	24.7	24.765	1505425.0
2011-05-31 12:30:00	MSFT	Stock	24.765	24.78	24.73	24.75	1511197.0
2011-05-31 13:00:00	MSFT	Stock	24.75	24.86	24.75	24.846	1355973.0
2011-05-31 13:30:00	MSFT	Stock	24.84	24.94	24.82	24.89	4059361.0
2011-05-31 14:00:00	MSFT	Stock	24.89	24.92	24.87	24.88	1612719.0
2011-05-31 14:30:00	MSFT	Stock	24.88	24.92	24.85	24.915	2503055.0
2011-05-31 15:00:00	MSFT	Stock	24.91	24.94	24.89	24.915	2539805.0
2011-05-31 15:30:00	MSFT	Stock	24.91	25.02	24.89	25.02	8270031.0

> showing 50 of 78,958 rows — these rows as CSV

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