PREVIEW / stock_30min / 2015-08-14

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-08-14.parquet
  size:    1.5 MB
  rows:    80,112
  symbols: 3,462

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
2015-08-14 04:00:00	AAPL	Stock	28.725	28.725	28.725	28.725	1200.0
2015-08-14 04:30:00	AAPL	Stock	28.77	28.77	28.7125	28.7125	1200.0
2015-08-14 05:00:00	AAPL	Stock	28.7125	28.7425	28.7075	28.7425	10964.0
2015-08-14 05:30:00	AAPL	Stock	28.7425	28.7425	28.6625	28.6625	9204.0
2015-08-14 06:00:00	AAPL	Stock	28.7	28.7	28.7	28.7	400.0
2015-08-14 06:30:00	AAPL	Stock	28.6625	28.675	28.6375	28.675	14092.0
2015-08-14 07:00:00	AAPL	Stock	28.6275	28.65	28.6125	28.625	72900.0
2015-08-14 07:30:00	AAPL	Stock	28.6225	28.65	28.6225	28.6375	59968.0
2015-08-14 08:00:00	AAPL	Stock	28.6475	28.6625	28.5475	28.5975	267080.0
2015-08-14 08:30:00	AAPL	Stock	28.6	28.665	28.5925	28.665	154612.0
2015-08-14 09:00:00	AAPL	Stock	28.665	28.685	28.5125	28.58	534628.0
2015-08-14 09:30:00	AAPL	Stock	28.58	28.855	28.5025	28.7745	29597652.0
2015-08-14 10:00:00	AAPL	Stock	28.7775	28.8125	28.6925	28.7725	16178324.0
2015-08-14 10:30:00	AAPL	Stock	28.7725	28.92	28.7025	28.7575	16295228.0
2015-08-14 11:00:00	AAPL	Stock	28.755	28.8125	28.7025	28.765	10181312.0
2015-08-14 11:30:00	AAPL	Stock	28.765	28.8225	28.7475	28.805	7123504.0
2015-08-14 12:00:00	AAPL	Stock	28.8025	28.81	28.725	28.7675	5291652.0
2015-08-14 12:30:00	AAPL	Stock	28.7675	28.8	28.6575	28.71	9091452.0
2015-08-14 13:00:00	AAPL	Stock	28.7112	28.819	28.6775	28.8	8031180.0
2015-08-14 13:30:00	AAPL	Stock	28.8025	28.8475	28.7825	28.8202	5890424.0
2015-08-14 14:00:00	AAPL	Stock	28.82	28.89	28.82	28.875	7331496.0
2015-08-14 14:30:00	AAPL	Stock	28.8725	28.8925	28.8625	28.89	6175176.0
2015-08-14 15:00:00	AAPL	Stock	28.89	29.04	28.89	29.0325	14410640.0
2015-08-14 15:30:00	AAPL	Stock	29.0325	29.0775	28.98	28.99	19018340.0
2015-08-14 16:00:00	AAPL	Stock	28.99	29.005	28.7245	29.005	5430860.0
2015-08-14 16:30:00	AAPL	Stock	29.005	29.005	28.99	29.0025	541784.0
2015-08-14 17:00:00	AAPL	Stock	29.0025	29.0075	28.99	29.0	140800.0
2015-08-14 17:30:00	AAPL	Stock	29.0032	29.01	29.0	29.005	34792.0
2015-08-14 18:00:00	AAPL	Stock	29.0	29.01	28.9925	29.0	49836.0
2015-08-14 18:30:00	AAPL	Stock	29.01	29.01	28.9958	29.005	21336.0
2015-08-14 19:00:00	AAPL	Stock	29.01	29.0125	29.0025	29.0118	39632.0
2015-08-14 19:30:00	AAPL	Stock	29.0125	29.035	29.0125	29.035	47152.0
2015-08-14 07:00:00	MSFT	Stock	46.67	46.68	46.67	46.68	440.0
2015-08-14 07:30:00	MSFT	Stock	46.68	46.68	46.68	46.68	100.0
2015-08-14 08:00:00	MSFT	Stock	46.6	46.65	46.6	46.65	700.0
2015-08-14 08:30:00	MSFT	Stock	46.6	46.6	46.6	46.6	590.0
2015-08-14 09:00:00	MSFT	Stock	46.613	46.78	46.55	46.56	10500.0
2015-08-14 09:30:00	MSFT	Stock	46.55	47.05	46.53	47.01	2122578.0
2015-08-14 10:00:00	MSFT	Stock	47.01	47.02	46.67	46.68	1141459.0
2015-08-14 10:30:00	MSFT	Stock	46.67	46.86	46.67	46.81	1417559.0
2015-08-14 11:00:00	MSFT	Stock	46.8	46.83	46.52	46.585	1520161.0
2015-08-14 11:30:00	MSFT	Stock	46.59	46.81	46.54	46.64	1226139.0
2015-08-14 12:00:00	MSFT	Stock	46.635	46.77	46.635	46.74	995955.0
2015-08-14 12:30:00	MSFT	Stock	46.73	46.81	46.69	46.715	1523366.0
2015-08-14 13:00:00	MSFT	Stock	46.71	46.95	46.67	46.95	793063.0
2015-08-14 13:30:00	MSFT	Stock	46.945	47.01	46.82	46.88	699385.0
2015-08-14 14:00:00	MSFT	Stock	46.884	46.98	46.85	46.87	854577.0
2015-08-14 14:30:00	MSFT	Stock	46.865	47.005	46.84	46.972	727832.0
2015-08-14 15:00:00	MSFT	Stock	46.975	47.1	46.95	47.044	977115.0
2015-08-14 15:30:00	MSFT	Stock	47.04	47.1	46.99	47.0	2166297.0

> showing 50 of 80,112 rows — these rows as CSV

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