PREVIEW / stock_30min / 2010-07-13

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-07-13.parquet
  size:    1.4 MB
  rows:    75,648
  symbols: 3,479

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-13 05:30:00	AAPL	Stock	9.2675	9.2675	9.2675	9.2675	2800.0
2010-07-13 06:30:00	AAPL	Stock	9.2661	9.2661	9.2661	9.2661	2800.0
2010-07-13 07:00:00	AAPL	Stock	9.2018	9.2464	9.2018	9.2464	70000.0
2010-07-13 07:30:00	AAPL	Stock	9.2411	9.2464	9.2221	9.2321	198800.0
2010-07-13 08:00:00	AAPL	Stock	9.2286	9.2464	9.2068	9.2286	1248128.0
2010-07-13 08:30:00	AAPL	Stock	9.2268	9.2332	9.1893	9.1911	2052848.0
2010-07-13 09:00:00	AAPL	Stock	9.1961	9.2214	9.1532	9.1546	6274408.0
2010-07-13 09:30:00	AAPL	Stock	9.1557	9.1571	8.8011	8.9214	302329384.0
2010-07-13 10:00:00	AAPL	Stock	8.9214	8.9525	8.8464	8.8871	151440240.0
2010-07-13 10:30:00	AAPL	Stock	8.8871	8.8896	8.8011	8.8605	116937856.0
2010-07-13 11:00:00	AAPL	Stock	8.8597	8.9257	8.8571	8.9089	76493480.0
2010-07-13 11:30:00	AAPL	Stock	8.9082	8.9561	8.9072	8.9254	64862924.0
2010-07-13 12:00:00	AAPL	Stock	8.9243	8.9643	8.8968	8.9609	42704116.0
2010-07-13 12:30:00	AAPL	Stock	8.9597	8.9911	8.9234	8.9339	58386104.0
2010-07-13 13:00:00	AAPL	Stock	8.9325	8.9579	8.9071	8.9146	42115108.0
2010-07-13 13:30:00	AAPL	Stock	8.9157	8.9514	8.9054	8.9332	35720188.0
2010-07-13 14:00:00	AAPL	Stock	8.9318	8.9964	8.9254	8.9548	53305112.0
2010-07-13 14:30:00	AAPL	Stock	8.9554	9.0311	8.9429	9.0296	63176680.0
2010-07-13 15:00:00	AAPL	Stock	9.0286	9.0536	9.0054	9.0271	62470996.0
2010-07-13 15:30:00	AAPL	Stock	9.0261	9.0336	8.9868	9.0039	86182320.0
2010-07-13 16:00:00	AAPL	Stock	9.0039	9.0961	8.9386	9.0464	15132684.0
2010-07-13 16:30:00	AAPL	Stock	9.0464	9.0682	8.9007	9.0571	3852212.0
2010-07-13 17:00:00	AAPL	Stock	9.0586	9.0707	9.0571	9.0607	791644.0
2010-07-13 17:30:00	AAPL	Stock	9.0625	9.0679	9.0571	9.0675	635348.0
2010-07-13 18:00:00	AAPL	Stock	9.0671	9.0707	8.9929	9.0643	596848.0
2010-07-13 18:30:00	AAPL	Stock	9.0646	9.0829	9.0646	9.0771	889616.0
2010-07-13 19:00:00	AAPL	Stock	9.075	9.08	9.0714	9.075	165816.0
2010-07-13 19:30:00	AAPL	Stock	9.0743	9.0871	9.0714	9.0825	381836.0
2010-07-13 05:30:00	MSFT	Stock	24.96	24.96	24.96	24.96	100.0
2010-07-13 06:00:00	MSFT	Stock	24.99	24.99	24.99	24.99	100.0
2010-07-13 06:30:00	MSFT	Stock	25.05	25.05	25.05	25.05	200.0
2010-07-13 07:00:00	MSFT	Stock	25.05	25.05	25.04	25.04	2930.0
2010-07-13 07:30:00	MSFT	Stock	25.07	25.07	25.0	25.0	5903.0
2010-07-13 08:00:00	MSFT	Stock	25.05	25.1	25.0	25.1	19697.0
2010-07-13 08:30:00	MSFT	Stock	25.1	25.14	25.08	25.08	17230.0
2010-07-13 09:00:00	MSFT	Stock	25.12	25.13	25.05	25.13	123954.0
2010-07-13 09:30:00	MSFT	Stock	25.14	25.22	24.98	25.05	6947370.0
2010-07-13 10:00:00	MSFT	Stock	25.045	25.11	24.975	25.0	4583600.0
2010-07-13 10:30:00	MSFT	Stock	25.0	25.0	24.9	24.985	2932377.0
2010-07-13 11:00:00	MSFT	Stock	24.98	25.01	24.93	24.97	3424783.0
2010-07-13 11:30:00	MSFT	Stock	24.97	25.19	24.97	25.141	5122206.0
2010-07-13 12:00:00	MSFT	Stock	25.14	25.23	25.14	25.22	3909371.0
2010-07-13 12:30:00	MSFT	Stock	25.215	25.28	25.2	25.27	3756426.0
2010-07-13 13:00:00	MSFT	Stock	25.27	25.3	25.12	25.13	3099903.0
2010-07-13 13:30:00	MSFT	Stock	25.125	25.16	25.08	25.1	2600597.0
2010-07-13 14:00:00	MSFT	Stock	25.1	25.16	25.08	25.119	2088463.0
2010-07-13 14:30:00	MSFT	Stock	25.12	25.19	25.1	25.138	2177362.0
2010-07-13 15:00:00	MSFT	Stock	25.135	25.2	25.12	25.145	3609995.0
2010-07-13 15:30:00	MSFT	Stock	25.145	25.2	25.09	25.12	7434423.0
2010-07-13 16:00:00	MSFT	Stock	25.12	25.75	25.01	25.65	2917273.0

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

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