PREVIEW / stock_30min / 2016-01-21

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-21.parquet
  size:    1.6 MB
  rows:    85,005
  symbols: 3,394

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-01-21 04:00:00	AAPL	Stock	22.755	24.1225	22.755	24.025	21196.0
2016-01-21 04:30:00	AAPL	Stock	24.025	24.075	24.005	24.075	24684.0
2016-01-21 05:00:00	AAPL	Stock	24.0925	24.15	24.0825	24.0825	19440.0
2016-01-21 05:30:00	AAPL	Stock	24.09	24.1075	24.0875	24.0875	13256.0
2016-01-21 06:00:00	AAPL	Stock	24.1	24.1025	24.0575	24.08	16604.0
2016-01-21 06:30:00	AAPL	Stock	24.0075	24.0675	24.0	24.0	8000.0
2016-01-21 07:00:00	AAPL	Stock	24.05	24.075	23.8925	24.075	45596.0
2016-01-21 07:30:00	AAPL	Stock	24.0625	24.19	24.0625	24.1525	22688.0
2016-01-21 08:00:00	AAPL	Stock	24.1525	24.31	24.04	24.275	332548.0
2016-01-21 08:30:00	AAPL	Stock	24.26	24.4025	24.2025	24.225	461632.0
2016-01-21 09:00:00	AAPL	Stock	24.2175	24.3225	24.135	24.3025	417120.0
2016-01-21 09:30:00	AAPL	Stock	24.265	24.3075	23.735	23.7975	24918864.0
2016-01-21 10:00:00	AAPL	Stock	23.81	24.1975	23.795	24.14	19131356.0
2016-01-21 10:30:00	AAPL	Stock	24.1425	24.27	24.0625	24.11	15205176.0
2016-01-21 11:00:00	AAPL	Stock	24.1125	24.3475	24.0675	24.2125	14404216.0
2016-01-21 11:30:00	AAPL	Stock	24.21	24.445	24.2075	24.425	12220304.0
2016-01-21 12:00:00	AAPL	Stock	24.4248	24.47	24.3325	24.41	11774868.0
2016-01-21 12:30:00	AAPL	Stock	24.4125	24.4475	24.29	24.34	9127176.0
2016-01-21 13:00:00	AAPL	Stock	24.3412	24.3975	24.2425	24.245	9437040.0
2016-01-21 13:30:00	AAPL	Stock	24.2475	24.3075	24.1775	24.2075	9371652.0
2016-01-21 14:00:00	AAPL	Stock	24.205	24.2375	23.9625	24.0405	11018616.0
2016-01-21 14:30:00	AAPL	Stock	24.0405	24.2475	24.03	24.2308	10656512.0
2016-01-21 15:00:00	AAPL	Stock	24.2325	24.2375	24.04	24.07	10476252.0
2016-01-21 15:30:00	AAPL	Stock	24.069	24.215	24.0625	24.065	14001660.0
2016-01-21 16:00:00	AAPL	Stock	24.075	24.2112	24.0348	24.08	11902640.0
2016-01-21 16:30:00	AAPL	Stock	24.085	24.1125	24.075	24.075	58760.0
2016-01-21 17:00:00	AAPL	Stock	24.08	24.085	24.075	24.0825	9904.0
2016-01-21 17:30:00	AAPL	Stock	24.075	24.1875	24.075	24.115	138992.0
2016-01-21 18:00:00	AAPL	Stock	24.1225	24.1225	24.0825	24.0825	35700.0
2016-01-21 18:30:00	AAPL	Stock	24.0925	24.105	24.0775	24.09	24080.0
2016-01-21 19:00:00	AAPL	Stock	24.105	24.105	24.08	24.0925	10620.0
2016-01-21 19:30:00	AAPL	Stock	24.11	24.155	24.11	24.1125	28236.0
2016-01-21 04:00:00	MSFT	Stock	50.43	50.43	50.43	50.43	800.0
2016-01-21 06:30:00	MSFT	Stock	50.54	50.54	50.3	50.54	5300.0
2016-01-21 07:00:00	MSFT	Stock	50.54	50.54	50.54	50.54	500.0
2016-01-21 07:30:00	MSFT	Stock	50.7	50.75	50.7	50.7	4700.0
2016-01-21 08:00:00	MSFT	Stock	50.85	51.13	50.85	51.09	1922.0
2016-01-21 08:30:00	MSFT	Stock	51.13	51.44	51.01	51.1	43233.0
2016-01-21 09:00:00	MSFT	Stock	51.12	51.24	50.92	51.18	44711.0
2016-01-21 09:30:00	MSFT	Stock	51.0	51.34	50.42	50.59	3761502.0
2016-01-21 10:00:00	MSFT	Stock	50.595	51.27	50.545	51.13	3521158.0
2016-01-21 10:30:00	MSFT	Stock	51.13	51.44	50.96	51.11	3081304.0
2016-01-21 11:00:00	MSFT	Stock	51.11	51.51	51.04	51.31	2822030.0
2016-01-21 11:30:00	MSFT	Stock	51.31	51.51	51.16	51.49	2052466.0
2016-01-21 12:00:00	MSFT	Stock	51.5	51.58	51.3	51.39	1791308.0
2016-01-21 12:30:00	MSFT	Stock	51.385	51.4	51.0	51.01	1549946.0
2016-01-21 13:00:00	MSFT	Stock	51.02	51.28	50.88	50.89	1761173.0
2016-01-21 13:30:00	MSFT	Stock	50.88	51.06	50.7	50.804	2383783.0
2016-01-21 14:00:00	MSFT	Stock	50.82	50.869	50.3	50.5	2785155.0
2016-01-21 14:30:00	MSFT	Stock	50.5	51.3	50.45	50.76	2591113.0

> showing 50 of 85,005 rows — these rows as CSV

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