PREVIEW / stock_30min / 2016-06-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-10.parquet
  size:    1.6 MB
  rows:    81,557
  symbols: 3,262

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
2016-06-10 04:00:00	AAPL	Stock	24.875	24.875	24.6475	24.6475	13332.0
2016-06-10 04:30:00	AAPL	Stock	24.725	24.725	24.725	24.725	7000.0
2016-06-10 05:00:00	AAPL	Stock	24.73	24.73	24.725	24.725	2400.0
2016-06-10 05:30:00	AAPL	Stock	24.675	24.7375	24.675	24.7375	5600.0
2016-06-10 06:00:00	AAPL	Stock	24.6875	24.7375	24.6875	24.725	8432.0
2016-06-10 06:30:00	AAPL	Stock	24.75	24.7775	24.75	24.7775	26292.0
2016-06-10 07:00:00	AAPL	Stock	24.765	24.8175	24.765	24.8125	28404.0
2016-06-10 07:30:00	AAPL	Stock	24.795	24.795	24.765	24.765	49056.0
2016-06-10 08:00:00	AAPL	Stock	24.7675	24.8175	24.755	24.7775	129512.0
2016-06-10 08:30:00	AAPL	Stock	24.775	24.775	24.7275	24.7375	170124.0
2016-06-10 09:00:00	AAPL	Stock	24.735	24.7625	24.63	24.6325	823608.0
2016-06-10 09:30:00	AAPL	Stock	24.6325	24.775	24.6275	24.6475	20204680.0
2016-06-10 10:00:00	AAPL	Stock	24.65	24.73	24.62	24.71	11881564.0
2016-06-10 10:30:00	AAPL	Stock	24.7125	24.75	24.685	24.6975	7898572.0
2016-06-10 11:00:00	AAPL	Stock	24.6975	24.7725	24.6898	24.745	7000336.0
2016-06-10 11:30:00	AAPL	Stock	24.7438	24.7825	24.7438	24.7575	4230276.0
2016-06-10 12:00:00	AAPL	Stock	24.7572	24.765	24.7025	24.755	5393568.0
2016-06-10 12:30:00	AAPL	Stock	24.755	24.8365	24.7375	24.8225	6576504.0
2016-06-10 13:00:00	AAPL	Stock	24.8225	24.825	24.7875	24.795	3969952.0
2016-06-10 13:30:00	AAPL	Stock	24.7938	24.8	24.725	24.74	6692692.0
2016-06-10 14:00:00	AAPL	Stock	24.7375	24.7575	24.7175	24.73	4827112.0
2016-06-10 14:30:00	AAPL	Stock	24.7322	24.75	24.72	24.7475	3665816.0
2016-06-10 15:00:00	AAPL	Stock	24.748	24.7575	24.6975	24.7532	6251016.0
2016-06-10 15:30:00	AAPL	Stock	24.755	24.7775	24.7	24.71	14211060.0
2016-06-10 16:00:00	AAPL	Stock	24.7075	24.745	24.7025	24.705	7360600.0
2016-06-10 16:30:00	AAPL	Stock	24.7075	24.715	24.7075	24.715	236040.0
2016-06-10 17:00:00	AAPL	Stock	24.7125	24.745	24.7125	24.7125	94660.0
2016-06-10 17:30:00	AAPL	Stock	24.72	24.72	24.7125	24.7125	6000.0
2016-06-10 18:00:00	AAPL	Stock	24.7125	24.72	24.71	24.72	13200.0
2016-06-10 18:30:00	AAPL	Stock	24.7125	24.7425	24.7125	24.725	85160.0
2016-06-10 19:00:00	AAPL	Stock	24.725	24.7325	24.725	24.7325	2800.0
2016-06-10 19:30:00	AAPL	Stock	24.725	24.7425	24.725	24.7375	50120.0
2016-06-10 05:30:00	MSFT	Stock	51.49	51.49	51.3	51.31	1587.0
2016-06-10 06:00:00	MSFT	Stock	51.31	51.31	51.31	51.31	2600.0
2016-06-10 06:30:00	MSFT	Stock	51.21	51.21	51.1	51.1	5397.0
2016-06-10 07:30:00	MSFT	Stock	51.21	51.29	51.21	51.29	300.0
2016-06-10 08:00:00	MSFT	Stock	51.3	51.3	51.17	51.17	4100.0
2016-06-10 08:30:00	MSFT	Stock	51.19	51.19	51.12	51.12	3285.0
2016-06-10 09:00:00	MSFT	Stock	51.1	51.1	51.03	51.03	11072.0
2016-06-10 09:30:00	MSFT	Stock	51.05	51.52	51.04	51.463	2751457.0
2016-06-10 10:00:00	MSFT	Stock	51.47	51.9	51.444	51.85	2194868.0
2016-06-10 10:30:00	MSFT	Stock	51.86	52.05	51.83	51.92	2556504.0
2016-06-10 11:00:00	MSFT	Stock	51.91	51.96	51.815	51.84	1501017.0
2016-06-10 11:30:00	MSFT	Stock	51.85	51.96	51.82	51.94	958341.0
2016-06-10 12:00:00	MSFT	Stock	51.93	51.953	51.83	51.882	858595.0
2016-06-10 12:30:00	MSFT	Stock	51.89	51.9	51.73	51.735	912699.0
2016-06-10 13:00:00	MSFT	Stock	51.732	51.85	51.71	51.82	826171.0
2016-06-10 13:30:00	MSFT	Stock	51.821	51.84	51.49	51.515	1309076.0
2016-06-10 14:00:00	MSFT	Stock	51.51	51.53	51.37	51.43	1533730.0
2016-06-10 14:30:00	MSFT	Stock	51.43	51.45	51.27	51.28	1829679.0

> showing 50 of 81,557 rows — these rows as CSV

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