PREVIEW / stock_30min / 2010-07-06

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-06.parquet
  size:    1.4 MB
  rows:    73,796
  symbols: 3,469

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-07-06 04:00:00	AAPL	Stock	8.9286	8.9821	8.9286	8.9821	53200.0
2010-07-06 04:30:00	AAPL	Stock	8.9643	8.9643	8.9643	8.9643	26768.0
2010-07-06 05:00:00	AAPL	Stock	8.9643	8.9911	8.9643	8.9907	16800.0
2010-07-06 05:30:00	AAPL	Stock	8.9643	8.9643	8.9286	8.9632	191072.0
2010-07-06 06:00:00	AAPL	Stock	8.9643	8.9643	8.95	8.95	54516.0
2010-07-06 06:30:00	AAPL	Stock	8.9536	8.9536	8.9414	8.9464	75740.0
2010-07-06 07:00:00	AAPL	Stock	8.9464	8.9521	8.9107	8.9107	199948.0
2010-07-06 07:30:00	AAPL	Stock	8.9107	8.9289	8.8929	8.9268	548968.0
2010-07-06 08:00:00	AAPL	Stock	8.9271	8.9321	8.8571	8.9261	2017232.0
2010-07-06 08:30:00	AAPL	Stock	8.9279	8.9536	8.9184	8.9275	1436484.0
2010-07-06 09:00:00	AAPL	Stock	8.9279	8.9643	8.9279	8.9643	2847712.0
2010-07-06 09:30:00	AAPL	Stock	8.9643	8.9975	8.9375	8.9457	91460376.0
2010-07-06 10:00:00	AAPL	Stock	8.9429	9.0	8.9286	8.9889	57498364.0
2010-07-06 10:30:00	AAPL	Stock	8.9889	9.0286	8.9796	8.9921	43599024.0
2010-07-06 11:00:00	AAPL	Stock	8.9921	9.0046	8.9386	8.9461	35384468.0
2010-07-06 11:30:00	AAPL	Stock	8.9457	8.9721	8.9314	8.9564	31135244.0
2010-07-06 12:00:00	AAPL	Stock	8.9564	8.9757	8.9425	8.9539	28933632.0
2010-07-06 12:30:00	AAPL	Stock	8.9521	8.9529	8.8661	8.8825	45488548.0
2010-07-06 13:00:00	AAPL	Stock	8.8804	8.9139	8.8675	8.8868	26705420.0
2010-07-06 13:30:00	AAPL	Stock	8.8868	8.8896	8.8116	8.8321	43226344.0
2010-07-06 14:00:00	AAPL	Stock	8.8325	8.8618	8.8004	8.8461	42779268.0
2010-07-06 14:30:00	AAPL	Stock	8.8429	8.8653	8.8246	8.8304	27386744.0
2010-07-06 15:00:00	AAPL	Stock	8.8321	8.85	8.7914	8.8282	41390776.0
2010-07-06 15:30:00	AAPL	Stock	8.8304	8.8793	8.8179	8.8786	66980088.0
2010-07-06 16:00:00	AAPL	Stock	8.8793	8.98	8.8541	8.8818	17293388.0
2010-07-06 16:30:00	AAPL	Stock	8.8918	8.8961	8.8221	8.8893	246708.0
2010-07-06 17:00:00	AAPL	Stock	8.8893	8.9036	8.8893	8.9021	208712.0
2010-07-06 17:30:00	AAPL	Stock	8.9029	8.9071	8.9014	8.9014	205660.0
2010-07-06 18:00:00	AAPL	Stock	8.9007	8.9036	8.8214	8.8796	169344.0
2010-07-06 18:30:00	AAPL	Stock	8.9043	8.9057	8.9007	8.9007	53116.0
2010-07-06 19:00:00	AAPL	Stock	8.9018	8.9071	8.9018	8.9071	112000.0
2010-07-06 19:30:00	AAPL	Stock	8.9071	8.9161	8.9043	8.9057	396760.0
2010-07-06 06:00:00	MSFT	Stock	23.67	23.7	23.62	23.62	3600.0
2010-07-06 06:30:00	MSFT	Stock	23.54	23.6	23.54	23.6	1100.0
2010-07-06 07:00:00	MSFT	Stock	23.58	23.65	23.5	23.65	10900.0
2010-07-06 07:30:00	MSFT	Stock	23.6	23.6	23.45	23.58	13328.0
2010-07-06 08:00:00	MSFT	Stock	23.5	23.6	23.49	23.58	27761.0
2010-07-06 08:30:00	MSFT	Stock	23.57	23.58	23.53	23.57	9032.0
2010-07-06 09:00:00	MSFT	Stock	23.58	23.72	23.55	23.68	143581.0
2010-07-06 09:30:00	MSFT	Stock	23.7	23.84	23.63	23.76	7988726.0
2010-07-06 10:00:00	MSFT	Stock	23.76	23.99	23.71	23.939	6865166.0
2010-07-06 10:30:00	MSFT	Stock	23.94	24.06	23.92	23.97	5364264.0
2010-07-06 11:00:00	MSFT	Stock	23.97	23.99	23.87	23.92	4551701.0
2010-07-06 11:30:00	MSFT	Stock	23.91	24.09	23.9	24.03	3154620.0
2010-07-06 12:00:00	MSFT	Stock	24.03	24.04	23.89	23.91	3171047.0
2010-07-06 12:30:00	MSFT	Stock	23.91	23.91	23.75	23.795	3867679.0
2010-07-06 13:00:00	MSFT	Stock	23.792	23.87	23.77	23.85	2666082.0
2010-07-06 13:30:00	MSFT	Stock	23.85	23.88	23.67	23.71	4422098.0
2010-07-06 14:00:00	MSFT	Stock	23.708	23.77	23.584	23.75	4497788.0
2010-07-06 14:30:00	MSFT	Stock	23.748	23.8	23.688	23.7	3005710.0

> showing 50 of 73,796 rows — these rows as CSV

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