PREVIEW / stock_30min / 2010-04-19

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-19.parquet
  size:    1.4 MB
  rows:    74,523
  symbols: 3,492

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-04-19 04:00:00	AAPL	Stock	8.8068	8.8107	8.8064	8.8107	28000.0
2010-04-19 05:00:00	AAPL	Stock	8.7743	8.7743	8.7536	8.7536	10836.0
2010-04-19 05:30:00	AAPL	Stock	8.7679	8.7768	8.7679	8.7768	25004.0
2010-04-19 06:00:00	AAPL	Stock	8.7554	8.7625	8.7504	8.7504	23800.0
2010-04-19 06:30:00	AAPL	Stock	8.75	8.7625	8.75	8.7625	11480.0
2010-04-19 07:00:00	AAPL	Stock	8.7625	8.775	8.7625	8.7679	61768.0
2010-04-19 07:30:00	AAPL	Stock	8.7679	8.8186	8.7625	8.8036	138880.0
2010-04-19 08:00:00	AAPL	Stock	8.7857	8.8193	8.7786	8.7854	1289484.0
2010-04-19 08:30:00	AAPL	Stock	8.7857	8.845	8.7839	8.8396	1256080.0
2010-04-19 09:00:00	AAPL	Stock	8.8396	8.8479	8.8214	8.8218	1326836.0
2010-04-19 09:30:00	AAPL	Stock	8.8218	8.8532	8.8036	8.8339	63642180.0
2010-04-19 10:00:00	AAPL	Stock	8.8339	8.8482	8.8036	8.8107	47229196.0
2010-04-19 10:30:00	AAPL	Stock	8.8105	8.8136	8.7668	8.7707	46363800.0
2010-04-19 11:00:00	AAPL	Stock	8.7707	8.8064	8.7661	8.78	29145452.0
2010-04-19 11:30:00	AAPL	Stock	8.7804	8.7925	8.6893	8.6989	42930636.0
2010-04-19 12:00:00	AAPL	Stock	8.6975	8.7161	8.6718	8.7036	47485508.0
2010-04-19 12:30:00	AAPL	Stock	8.7036	8.7371	8.7004	8.7168	24857308.0
2010-04-19 13:00:00	AAPL	Stock	8.7161	8.7161	8.6346	8.6779	59866016.0
2010-04-19 13:30:00	AAPL	Stock	8.6761	8.6875	8.645	8.6521	31801308.0
2010-04-19 14:00:00	AAPL	Stock	8.6521	8.7132	8.6457	8.6954	38109064.0
2010-04-19 14:30:00	AAPL	Stock	8.6968	8.7696	8.6893	8.7679	34392512.0
2010-04-19 15:00:00	AAPL	Stock	8.7679	8.8089	8.7536	8.8011	40533416.0
2010-04-19 15:30:00	AAPL	Stock	8.8011	8.8243	8.775	8.8243	42944020.0
2010-04-19 16:00:00	AAPL	Stock	8.8243	8.8352	8.7126	8.8193	8600368.0
2010-04-19 16:30:00	AAPL	Stock	8.8017	8.823	8.7422	8.8089	424172.0
2010-04-19 17:00:00	AAPL	Stock	8.6806	8.8125	8.6806	8.8125	236460.0
2010-04-19 17:30:00	AAPL	Stock	8.8143	8.8168	8.8114	8.8143	125104.0
2010-04-19 18:00:00	AAPL	Stock	8.8179	8.8214	8.8143	8.8143	94108.0
2010-04-19 18:30:00	AAPL	Stock	8.8179	8.8207	8.8154	8.8154	52836.0
2010-04-19 19:00:00	AAPL	Stock	8.8207	8.8214	8.8143	8.8161	130088.0
2010-04-19 19:30:00	AAPL	Stock	8.8175	8.8179	8.8096	8.8179	224000.0
2010-04-19 20:00:00	AAPL	Stock	8.7786	8.7786	8.7786	8.7786	5600.0
2010-04-19 07:00:00	MSFT	Stock	30.72	30.72	30.72	30.72	5800.0
2010-04-19 07:30:00	MSFT	Stock	30.61	30.62	30.61	30.62	300.0
2010-04-19 08:00:00	MSFT	Stock	30.67	30.83	30.67	30.75	12720.0
2010-04-19 08:30:00	MSFT	Stock	30.75	30.8	30.65	30.75	29239.0
2010-04-19 09:00:00	MSFT	Stock	30.76	30.82	30.75	30.76	48175.0
2010-04-19 09:30:00	MSFT	Stock	30.77	31.25	30.76	30.97	11977317.0
2010-04-19 10:00:00	MSFT	Stock	30.97	31.01	30.84	30.9	7251625.0
2010-04-19 10:30:00	MSFT	Stock	30.89	30.93	30.84	30.895	3713356.0
2010-04-19 11:00:00	MSFT	Stock	30.892	30.92	30.8	30.82	3500596.0
2010-04-19 11:30:00	MSFT	Stock	30.83	30.89	30.79	30.83	3306124.0
2010-04-19 12:00:00	MSFT	Stock	30.825	30.91	30.8	30.88	3484166.0
2010-04-19 12:30:00	MSFT	Stock	30.88	30.92	30.84	30.919	2025505.0
2010-04-19 13:00:00	MSFT	Stock	30.92	30.92	30.81	30.87	3253815.0
2010-04-19 13:30:00	MSFT	Stock	30.865	30.91	30.84	30.855	2098854.0
2010-04-19 14:00:00	MSFT	Stock	30.85	30.99	30.83	30.985	3254691.0
2010-04-19 14:30:00	MSFT	Stock	30.99	31.04	30.97	31.02	4029866.0
2010-04-19 15:00:00	MSFT	Stock	31.02	31.06	30.96	31.06	6072906.0
2010-04-19 15:30:00	MSFT	Stock	31.06	31.07	30.95	31.03	7030913.0

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

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