PREVIEW / stock_30min / 2010-06-21

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-21.parquet
  size:    1.4 MB
  rows:    74,885
  symbols: 3,471

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
2010-06-21 04:00:00	AAPL	Stock	9.9464	9.9536	9.9236	9.9357	103600.0
2010-06-21 04:30:00	AAPL	Stock	9.9375	9.9375	9.8996	9.9286	28000.0
2010-06-21 05:00:00	AAPL	Stock	9.9286	9.9518	9.9286	9.9518	22400.0
2010-06-21 05:30:00	AAPL	Stock	9.9457	9.9457	9.9096	9.9286	39200.0
2010-06-21 06:00:00	AAPL	Stock	9.9454	9.9454	9.9357	9.9357	13972.0
2010-06-21 06:30:00	AAPL	Stock	9.9461	9.95	9.9304	9.9304	64400.0
2010-06-21 07:00:00	AAPL	Stock	9.9429	9.9589	9.9375	9.9518	542276.0
2010-06-21 07:30:00	AAPL	Stock	9.9468	9.9589	9.9207	9.9286	311780.0
2010-06-21 08:00:00	AAPL	Stock	9.9279	9.9346	9.8929	9.9043	3731532.0
2010-06-21 08:30:00	AAPL	Stock	9.8968	9.9107	9.8861	9.8989	1744736.0
2010-06-21 09:00:00	AAPL	Stock	9.8993	9.9311	9.8993	9.9196	3408804.0
2010-06-21 09:30:00	AAPL	Stock	9.9186	9.9625	9.9021	9.9592	96441240.0
2010-06-21 10:00:00	AAPL	Stock	9.9593	9.9646	9.8768	9.8793	72740528.0
2010-06-21 10:30:00	AAPL	Stock	9.8789	9.8954	9.8496	9.8679	61642784.0
2010-06-21 11:00:00	AAPL	Stock	9.8668	9.895	9.8378	9.8657	42752416.0
2010-06-21 11:30:00	AAPL	Stock	9.8657	9.8736	9.8286	9.8465	40276236.0
2010-06-21 12:00:00	AAPL	Stock	9.8471	9.8589	9.8143	9.8182	28735140.0
2010-06-21 12:30:00	AAPL	Stock	9.8182	9.8479	9.8125	9.8471	24954496.0
2010-06-21 13:00:00	AAPL	Stock	9.8475	9.8639	9.8376	9.8536	20352332.0
2010-06-21 13:30:00	AAPL	Stock	9.8542	9.8564	9.7804	9.7825	41826372.0
2010-06-21 14:00:00	AAPL	Stock	9.7818	9.8382	9.7718	9.7871	43354752.0
2010-06-21 14:30:00	AAPL	Stock	9.7875	9.81	9.7282	9.7436	45831380.0
2010-06-21 15:00:00	AAPL	Stock	9.7414	9.7492	9.6179	9.6489	117250756.0
2010-06-21 15:30:00	AAPL	Stock	9.65	9.67	9.5975	9.6557	109192748.0
2010-06-21 16:00:00	AAPL	Stock	9.6554	9.8015	9.643	9.67	8965572.0
2010-06-21 16:30:00	AAPL	Stock	9.6689	9.9276	9.6492	9.6721	1240708.0
2010-06-21 17:00:00	AAPL	Stock	9.6725	9.6775	9.6679	9.6757	447916.0
2010-06-21 17:30:00	AAPL	Stock	9.6764	9.6768	9.6729	9.6768	85820.0
2010-06-21 18:00:00	AAPL	Stock	9.6754	9.6843	9.6489	9.6821	2839620.0
2010-06-21 18:30:00	AAPL	Stock	9.6821	9.6846	9.6818	9.6846	224532.0
2010-06-21 19:00:00	AAPL	Stock	9.6821	9.6921	9.6818	9.6893	188972.0
2010-06-21 19:30:00	AAPL	Stock	9.6893	9.7032	9.6871	9.6996	280644.0
2010-06-21 04:30:00	MSFT	Stock	26.81	26.81	26.81	26.81	100.0
2010-06-21 07:00:00	MSFT	Stock	26.73	26.78	26.73	26.78	2700.0
2010-06-21 07:30:00	MSFT	Stock	26.78	26.79	26.78	26.78	2600.0
2010-06-21 08:00:00	MSFT	Stock	26.78	26.78	26.71	26.72	14428.0
2010-06-21 08:30:00	MSFT	Stock	26.74	26.8	26.74	26.8	7178.0
2010-06-21 09:00:00	MSFT	Stock	26.79	27.0	26.72	26.77	246253.0
2010-06-21 09:30:00	MSFT	Stock	26.77	26.89	26.44	26.56	5111695.0
2010-06-21 10:00:00	MSFT	Stock	26.566	26.61	26.3	26.42	3152646.0
2010-06-21 10:30:00	MSFT	Stock	26.42	26.43	26.25	26.3	4086706.0
2010-06-21 11:00:00	MSFT	Stock	26.305	26.38	26.27	26.32	2603039.0
2010-06-21 11:30:00	MSFT	Stock	26.325	26.36	26.28	26.29	2036210.0
2010-06-21 12:00:00	MSFT	Stock	26.298	26.33	26.24	26.24	2417431.0
2010-06-21 12:30:00	MSFT	Stock	26.24	26.25	26.17	26.2	2824242.0
2010-06-21 13:00:00	MSFT	Stock	26.2	26.29	26.19	26.275	1192623.0
2010-06-21 13:30:00	MSFT	Stock	26.275	26.28	26.13	26.17	1983700.0
2010-06-21 14:00:00	MSFT	Stock	26.18	26.27	26.17	26.2	2174481.0
2010-06-21 14:30:00	MSFT	Stock	26.2	26.23	26.14	26.17	1718583.0
2010-06-21 15:00:00	MSFT	Stock	26.16	26.17	25.94	26.015	6378940.0

> showing 50 of 74,885 rows — these rows as CSV

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