PREVIEW / stock_30min / 2010-01-04

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-01-04.parquet
  size:    1.4 MB
  rows:    74,589
  symbols: 3,455

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-04 04:00:00	AAPL	Stock	7.5707	7.5707	7.5707	7.5707	2800.0
2010-01-04 04:30:00	AAPL	Stock	7.5886	7.5886	7.5886	7.5886	5600.0
2010-01-04 05:00:00	AAPL	Stock	7.595	7.6	7.595	7.6	8400.0
2010-01-04 05:30:00	AAPL	Stock	7.5921	7.5921	7.5921	7.5921	2800.0
2010-01-04 06:00:00	AAPL	Stock	7.5964	7.5964	7.5964	7.5964	2800.0
2010-01-04 07:00:00	AAPL	Stock	7.5818	7.6204	7.5818	7.6014	183260.0
2010-01-04 07:30:00	AAPL	Stock	7.595	7.6071	7.595	7.6071	379652.0
2010-01-04 08:00:00	AAPL	Stock	7.6054	7.6104	7.5307	7.5893	3227980.0
2010-01-04 08:30:00	AAPL	Stock	7.5925	7.6104	7.5875	7.6071	1913156.0
2010-01-04 09:00:00	AAPL	Stock	7.6054	7.625	7.5261	7.6243	3349668.0
2010-01-04 09:30:00	AAPL	Stock	7.6218	7.6586	7.5943	7.6179	118182708.0
2010-01-04 10:00:00	AAPL	Stock	7.62	7.6304	7.585	7.6264	66212916.0
2010-01-04 10:30:00	AAPL	Stock	7.6254	7.6364	7.6161	7.6196	38041332.0
2010-01-04 11:00:00	AAPL	Stock	7.6193	7.6239	7.6086	7.6221	26574212.0
2010-01-04 11:30:00	AAPL	Stock	7.6214	7.6414	7.6168	7.6371	26646956.0
2010-01-04 12:00:00	AAPL	Stock	7.6379	7.65	7.6304	7.6496	23420572.0
2010-01-04 12:30:00	AAPL	Stock	7.6496	7.6529	7.625	7.6446	18371304.0
2010-01-04 13:00:00	AAPL	Stock	7.6443	7.6475	7.6293	7.6407	20086052.0
2010-01-04 13:30:00	AAPL	Stock	7.6414	7.6417	7.6257	7.6289	13287484.0
2010-01-04 14:00:00	AAPL	Stock	7.6289	7.6404	7.6264	7.63	15472828.0
2010-01-04 14:30:00	AAPL	Stock	7.6307	7.6532	7.63	7.6425	21886732.0
2010-01-04 15:00:00	AAPL	Stock	7.6421	7.6607	7.6411	7.6471	33712448.0
2010-01-04 15:30:00	AAPL	Stock	7.6471	7.6568	7.6386	7.6493	44883664.0
2010-01-04 16:00:00	AAPL	Stock	7.6507	7.6725	7.6312	7.6607	10445484.0
2010-01-04 16:30:00	AAPL	Stock	7.6607	7.6714	7.6213	7.6675	1149344.0
2010-01-04 17:00:00	AAPL	Stock	7.665	7.6729	7.6629	7.6721	321776.0
2010-01-04 17:30:00	AAPL	Stock	7.6718	7.6729	7.6679	7.6729	412804.0
2010-01-04 18:00:00	AAPL	Stock	7.6729	7.6729	7.6432	7.6705	715344.0
2010-01-04 18:30:00	AAPL	Stock	7.6705	7.6746	7.6704	7.6746	300468.0
2010-01-04 19:00:00	AAPL	Stock	7.6732	7.6786	7.6732	7.6775	573580.0
2010-01-04 19:30:00	AAPL	Stock	7.6768	7.6782	7.6643	7.6654	525084.0
2010-01-04 04:30:00	MSFT	Stock	30.7	30.7	30.7	30.7	1000.0
2010-01-04 05:00:00	MSFT	Stock	30.73	30.75	30.73	30.75	1200.0
2010-01-04 06:00:00	MSFT	Stock	30.75	30.75	30.75	30.75	300.0
2010-01-04 07:30:00	MSFT	Stock	30.79	30.79	30.75	30.75	1200.0
2010-01-04 08:00:00	MSFT	Stock	30.71	30.79	30.69	30.69	10700.0
2010-01-04 08:30:00	MSFT	Stock	30.69	30.7	30.48	30.68	442498.0
2010-01-04 09:00:00	MSFT	Stock	30.7	30.77	30.57	30.62	52357.0
2010-01-04 09:30:00	MSFT	Stock	30.63	30.97	30.59	30.9	5276774.0
2010-01-04 10:00:00	MSFT	Stock	30.91	31.0	30.87	30.99	4016746.0
2010-01-04 10:30:00	MSFT	Stock	31.0	31.0	30.95	30.96	2092497.0
2010-01-04 11:00:00	MSFT	Stock	30.96	31.06	30.96	31.0	2395138.0
2010-01-04 11:30:00	MSFT	Stock	31.002	31.08	30.98	31.05	2179259.0
2010-01-04 12:00:00	MSFT	Stock	31.04	31.06	31.02	31.06	1490579.0
2010-01-04 12:30:00	MSFT	Stock	31.05	31.08	31.01	31.015	1177674.0
2010-01-04 13:00:00	MSFT	Stock	31.03	31.04	30.95	31.0	1774079.0
2010-01-04 13:30:00	MSFT	Stock	31.01	31.01	30.95	30.96	1415076.0
2010-01-04 14:00:00	MSFT	Stock	30.955	31.01	30.95	31.01	1053475.0
2010-01-04 14:30:00	MSFT	Stock	31.001	31.09	31.0	31.07	1905508.0
2010-01-04 15:00:00	MSFT	Stock	31.072	31.1	30.97	30.98	2535025.0

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

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