PREVIEW / stock_30min / 2010-12-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-27.parquet
  size:    1.4 MB
  rows:    74,635
  symbols: 3,520

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-12-27 04:00:00	AAPL	Stock	11.5486	11.5486	11.5486	11.5486	6496.0
2010-12-27 04:30:00	AAPL	Stock	11.5343	11.5343	11.5343	11.5343	8400.0
2010-12-27 07:00:00	AAPL	Stock	11.5361	11.5657	11.5357	11.5536	39200.0
2010-12-27 07:30:00	AAPL	Stock	11.5411	11.5414	11.5329	11.5364	50400.0
2010-12-27 08:00:00	AAPL	Stock	11.5329	11.5411	11.5107	11.5171	346052.0
2010-12-27 08:30:00	AAPL	Stock	11.5179	11.5311	11.5161	11.5236	101724.0
2010-12-27 09:00:00	AAPL	Stock	11.5246	11.5429	11.5204	11.5429	811300.0
2010-12-27 09:30:00	AAPL	Stock	11.5418	11.58	11.4829	11.5043	66891384.0
2010-12-27 10:00:00	AAPL	Stock	11.5036	11.5282	11.5011	11.5196	23023924.0
2010-12-27 10:30:00	AAPL	Stock	11.5204	11.525	11.5046	11.5054	14868308.0
2010-12-27 11:00:00	AAPL	Stock	11.5064	11.5211	11.5057	11.5146	11591468.0
2010-12-27 11:30:00	AAPL	Stock	11.5139	11.5214	11.5068	11.5203	9905000.0
2010-12-27 12:00:00	AAPL	Stock	11.52	11.5421	11.5175	11.5336	12023312.0
2010-12-27 12:30:00	AAPL	Stock	11.5325	11.5354	11.5232	11.5354	6405000.0
2010-12-27 13:00:00	AAPL	Stock	11.5343	11.6018	11.5339	11.5961	20320552.0
2010-12-27 13:30:00	AAPL	Stock	11.5964	11.6021	11.5864	11.6007	11950820.0
2010-12-27 14:00:00	AAPL	Stock	11.6014	11.6118	11.5979	11.6082	12843124.0
2010-12-27 14:30:00	AAPL	Stock	11.6096	11.6229	11.6039	11.6143	13001744.0
2010-12-27 15:00:00	AAPL	Stock	11.6139	11.6182	11.6071	11.6111	10669680.0
2010-12-27 15:30:00	AAPL	Stock	11.6114	11.6143	11.5964	11.5964	21717976.0
2010-12-27 16:00:00	AAPL	Stock	11.5957	11.6039	11.5529	11.5975	4364752.0
2010-12-27 16:30:00	AAPL	Stock	11.5971	11.6091	11.5942	11.5964	285068.0
2010-12-27 17:00:00	AAPL	Stock	11.5989	11.6021	11.595	11.6021	278936.0
2010-12-27 17:30:00	AAPL	Stock	11.6018	11.6021	11.5982	11.5982	81116.0
2010-12-27 18:00:00	AAPL	Stock	11.6018	11.6032	11.5957	11.6032	86548.0
2010-12-27 18:30:00	AAPL	Stock	11.5989	11.6025	11.5982	11.6011	143220.0
2010-12-27 19:00:00	AAPL	Stock	11.5982	11.6011	11.5979	11.6011	53116.0
2010-12-27 19:30:00	AAPL	Stock	11.6014	11.6018	11.5964	11.5964	218400.0
2010-12-27 07:00:00	MSFT	Stock	28.1	28.11	28.09	28.11	1400.0
2010-12-27 07:30:00	MSFT	Stock	28.08	28.1	28.08	28.1	1200.0
2010-12-27 08:00:00	MSFT	Stock	28.14	28.14	28.1	28.11	1700.0
2010-12-27 08:30:00	MSFT	Stock	28.12	28.17	28.11	28.17	2900.0
2010-12-27 09:00:00	MSFT	Stock	28.17	28.26	28.11	28.12	47823.0
2010-12-27 09:30:00	MSFT	Stock	28.12	28.2	27.92	27.99	2539860.0
2010-12-27 10:00:00	MSFT	Stock	27.985	28.06	27.88	28.04	2206864.0
2010-12-27 10:30:00	MSFT	Stock	28.05	28.07	27.99	27.995	1078339.0
2010-12-27 11:00:00	MSFT	Stock	27.995	28.03	27.98	27.994	1412731.0
2010-12-27 11:30:00	MSFT	Stock	27.995	28.01	27.98	27.999	787845.0
2010-12-27 12:00:00	MSFT	Stock	28.0	28.02	27.98	28.02	1078446.0
2010-12-27 12:30:00	MSFT	Stock	28.017	28.03	27.99	28.03	916487.0
2010-12-27 13:00:00	MSFT	Stock	28.03	28.17	28.0	28.165	2035879.0
2010-12-27 13:30:00	MSFT	Stock	28.16	28.16	28.11	28.12	859742.0
2010-12-27 14:00:00	MSFT	Stock	28.12	28.12	28.05	28.07	881532.0
2010-12-27 14:30:00	MSFT	Stock	28.07	28.1	28.065	28.08	755786.0
2010-12-27 15:00:00	MSFT	Stock	28.08	28.14	28.06	28.125	1477164.0
2010-12-27 15:30:00	MSFT	Stock	28.12	28.13	28.07	28.07	2585336.0
2010-12-27 16:00:00	MSFT	Stock	28.07	28.14	28.03	28.05	890905.0
2010-12-27 16:30:00	MSFT	Stock	28.04	28.129	28.04	28.096	35000.0
2010-12-27 17:30:00	MSFT	Stock	28.1	28.14	28.09	28.1	7226.0
2010-12-27 18:00:00	MSFT	Stock	28.13	28.14	28.07	28.14	6769.0

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

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