PREVIEW / stock_30min / 2010-01-15

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-15.parquet
  size:    1.4 MB
  rows:    72,762
  symbols: 3,439

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-01-15 06:30:00	AAPL	Stock	7.5086	7.5232	7.5086	7.5232	8400.0
2010-01-15 07:00:00	AAPL	Stock	7.4918	7.4918	7.4639	7.4643	175224.0
2010-01-15 07:30:00	AAPL	Stock	7.4732	7.4732	7.4657	7.4657	14000.0
2010-01-15 08:00:00	AAPL	Stock	7.4761	7.5	7.4721	7.4925	578648.0
2010-01-15 08:30:00	AAPL	Stock	7.4857	7.4911	7.4757	7.4854	289800.0
2010-01-15 09:00:00	AAPL	Stock	7.4861	7.5489	7.4825	7.5318	3472952.0
2010-01-15 09:30:00	AAPL	Stock	7.5329	7.5571	7.4764	7.4975	82930176.0
2010-01-15 10:00:00	AAPL	Stock	7.4999	7.5068	7.4421	7.4514	70086996.0
2010-01-15 10:30:00	AAPL	Stock	7.4507	7.4611	7.4139	7.4429	44908500.0
2010-01-15 11:00:00	AAPL	Stock	7.4432	7.4514	7.4329	7.4396	20113660.0
2010-01-15 11:30:00	AAPL	Stock	7.4396	7.4404	7.3964	7.405	33482120.0
2010-01-15 12:00:00	AAPL	Stock	7.405	7.4204	7.3793	7.3796	27195896.0
2010-01-15 12:30:00	AAPL	Stock	7.3793	7.3918	7.3621	7.3791	38815616.0
2010-01-15 13:00:00	AAPL	Stock	7.3804	7.3979	7.3764	7.3918	20471332.0
2010-01-15 13:30:00	AAPL	Stock	7.3918	7.41	7.3818	7.4089	24328892.0
2010-01-15 14:00:00	AAPL	Stock	7.4096	7.4182	7.4018	7.4039	22760276.0
2010-01-15 14:30:00	AAPL	Stock	7.4036	7.4036	7.3907	7.3963	22221808.0
2010-01-15 15:00:00	AAPL	Stock	7.3963	7.4089	7.3882	7.3916	33828200.0
2010-01-15 15:30:00	AAPL	Stock	7.3914	7.3957	7.3525	7.3536	81579876.0
2010-01-15 16:00:00	AAPL	Stock	7.3536	7.4349	7.3502	7.3607	13743324.0
2010-01-15 16:30:00	AAPL	Stock	7.3976	7.3976	7.3593	7.3607	2401952.0
2010-01-15 17:00:00	AAPL	Stock	7.3571	7.3614	7.3546	7.3561	137480.0
2010-01-15 17:30:00	AAPL	Stock	7.3571	7.3589	7.3504	7.3536	219940.0
2010-01-15 18:00:00	AAPL	Stock	7.3525	7.3604	7.3525	7.3604	53200.0
2010-01-15 18:30:00	AAPL	Stock	7.3611	7.3643	7.3604	7.3625	110824.0
2010-01-15 19:00:00	AAPL	Stock	7.3625	7.3629	7.3604	7.3614	28616.0
2010-01-15 19:30:00	AAPL	Stock	7.3625	7.3625	7.3571	7.3571	108836.0
2010-01-15 04:00:00	MSFT	Stock	31.16	31.16	31.16	31.16	1266.0
2010-01-15 05:30:00	MSFT	Stock	31.0	31.0	30.97	30.97	200.0
2010-01-15 07:00:00	MSFT	Stock	30.98	30.98	30.92	30.93	6200.0
2010-01-15 07:30:00	MSFT	Stock	31.0	31.0	30.95	31.0	1535.0
2010-01-15 08:00:00	MSFT	Stock	31.0	31.13	31.0	31.12	29360.0
2010-01-15 08:30:00	MSFT	Stock	31.12	31.15	30.96	31.08	184969.0
2010-01-15 09:00:00	MSFT	Stock	31.06	31.14	30.95	31.14	301759.0
2010-01-15 09:30:00	MSFT	Stock	31.08	31.24	30.83	30.9	12034004.0
2010-01-15 10:00:00	MSFT	Stock	30.9	30.96	30.73	30.83	10084791.0
2010-01-15 10:30:00	MSFT	Stock	30.82	30.9	30.77	30.79	5571084.0
2010-01-15 11:00:00	MSFT	Stock	30.79	30.885	30.73	30.79	4023793.0
2010-01-15 11:30:00	MSFT	Stock	30.79	30.815	30.72	30.778	3562239.0
2010-01-15 12:00:00	MSFT	Stock	30.775	30.845	30.72	30.72	3107005.0
2010-01-15 12:30:00	MSFT	Stock	30.72	30.87	30.71	30.86	3348922.0
2010-01-15 13:00:00	MSFT	Stock	30.86	30.87	30.79	30.845	2631332.0
2010-01-15 13:30:00	MSFT	Stock	30.85	30.9	30.79	30.815	2897382.0
2010-01-15 14:00:00	MSFT	Stock	30.814	30.86	30.76	30.76	2644582.0
2010-01-15 14:30:00	MSFT	Stock	30.76	30.84	30.73	30.832	2482418.0
2010-01-15 15:00:00	MSFT	Stock	30.84	30.91	30.83	30.91	2856785.0
2010-01-15 15:30:00	MSFT	Stock	30.91	30.95	30.83	30.85	8146132.0
2010-01-15 16:00:00	MSFT	Stock	30.86	30.921	30.8	30.83	6059706.0
2010-01-15 16:30:00	MSFT	Stock	30.823	30.83	30.77	30.81	23100.0
2010-01-15 17:00:00	MSFT	Stock	30.789	30.86	30.789	30.85	1862.0

> showing 50 of 72,762 rows — these rows as CSV

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