PREVIEW / stock_30min / 2015-11-20

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-11-20.parquet
  size:    1.6 MB
  rows:    81,534
  symbols: 3,408

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-11-20 04:00:00	AAPL	Stock	29.7	29.7	29.7	29.7	1444.0
2015-11-20 04:30:00	AAPL	Stock	29.7175	29.7175	29.7175	29.7175	628.0
2015-11-20 05:00:00	AAPL	Stock	29.7	29.7	29.6975	29.7	2800.0
2015-11-20 06:00:00	AAPL	Stock	29.755	29.77	29.7525	29.7525	5920.0
2015-11-20 06:30:00	AAPL	Stock	29.7525	29.7525	29.7525	29.7525	1200.0
2015-11-20 07:00:00	AAPL	Stock	29.725	29.725	29.6675	29.6675	26908.0
2015-11-20 07:30:00	AAPL	Stock	29.7	29.73	29.7	29.725	28596.0
2015-11-20 08:00:00	AAPL	Stock	29.725	29.73	29.665	29.695	196708.0
2015-11-20 08:30:00	AAPL	Stock	29.695	29.7875	29.695	29.7675	169308.0
2015-11-20 09:00:00	AAPL	Stock	29.765	29.835	29.7175	29.835	1528264.0
2015-11-20 09:30:00	AAPL	Stock	29.8	29.92	29.7125	29.905	26070744.0
2015-11-20 10:00:00	AAPL	Stock	29.9025	29.98	29.855	29.97	12041948.0
2015-11-20 10:30:00	AAPL	Stock	29.97	29.975	29.815	29.8355	9969616.0
2015-11-20 11:00:00	AAPL	Stock	29.835	29.91	29.815	29.895	7315120.0
2015-11-20 11:30:00	AAPL	Stock	29.8975	29.9	29.7375	29.79	8878924.0
2015-11-20 12:00:00	AAPL	Stock	29.79	29.8925	29.74	29.87	10145224.0
2015-11-20 12:30:00	AAPL	Stock	29.87	29.9145	29.825	29.8312	6483420.0
2015-11-20 13:00:00	AAPL	Stock	29.8325	29.8875	29.81	29.82	4356792.0
2015-11-20 13:30:00	AAPL	Stock	29.821	29.8272	29.7752	29.815	4555400.0
2015-11-20 14:00:00	AAPL	Stock	29.815	29.83	29.7875	29.8162	4258812.0
2015-11-20 14:30:00	AAPL	Stock	29.8162	29.84	29.785	29.79	4963592.0
2015-11-20 15:00:00	AAPL	Stock	29.7925	29.82	29.765	29.7975	6045512.0
2015-11-20 15:30:00	AAPL	Stock	29.8	29.8275	29.785	29.825	12360572.0
2015-11-20 16:00:00	AAPL	Stock	29.825	29.876	29.81	29.835	7914252.0
2015-11-20 16:30:00	AAPL	Stock	29.835	29.835	29.8225	29.8325	54816.0
2015-11-20 17:00:00	AAPL	Stock	29.825	29.8375	29.825	29.8375	42948.0
2015-11-20 17:30:00	AAPL	Stock	29.835	29.835	29.825	29.8275	539424.0
2015-11-20 18:00:00	AAPL	Stock	29.8325	29.85	29.83	29.8375	31464.0
2015-11-20 18:30:00	AAPL	Stock	29.8325	29.86	29.8325	29.86	20268.0
2015-11-20 19:00:00	AAPL	Stock	29.86	29.875	29.8375	29.855	40064.0
2015-11-20 19:30:00	AAPL	Stock	29.855	29.8725	29.8525	29.8625	45844.0
2015-11-20 07:00:00	MSFT	Stock	54.02	54.03	54.02	54.03	5200.0
2015-11-20 07:30:00	MSFT	Stock	54.07	54.07	54.07	54.07	627.0
2015-11-20 08:00:00	MSFT	Stock	54.0	54.1	54.0	54.1	3932.0
2015-11-20 08:30:00	MSFT	Stock	54.1	54.12	54.09	54.09	13200.0
2015-11-20 09:00:00	MSFT	Stock	54.09	54.3	54.08	54.29	437514.0
2015-11-20 09:30:00	MSFT	Stock	54.25	54.3	53.58	53.76	6721505.0
2015-11-20 10:00:00	MSFT	Stock	53.755	53.92	53.4	53.405	3067523.0
2015-11-20 10:30:00	MSFT	Stock	53.4	53.9	53.265	53.36	2451182.0
2015-11-20 11:00:00	MSFT	Stock	53.36	53.755	53.34	53.66	2094850.0
2015-11-20 11:30:00	MSFT	Stock	53.66	53.71	53.49	53.509	1224623.0
2015-11-20 12:00:00	MSFT	Stock	53.51	53.76	53.47	53.74	1825744.0
2015-11-20 12:30:00	MSFT	Stock	53.738	53.81	53.62	53.776	1409475.0
2015-11-20 13:00:00	MSFT	Stock	53.78	53.95	53.68	53.906	1495404.0
2015-11-20 13:30:00	MSFT	Stock	53.903	54.1	53.86	54.073	2203759.0
2015-11-20 14:00:00	MSFT	Stock	54.078	54.19	54.04	54.06	1554181.0
2015-11-20 14:30:00	MSFT	Stock	54.07	54.25	54.02	54.02	1891544.0
2015-11-20 15:00:00	MSFT	Stock	54.03	54.14	54.01	54.1	1536423.0
2015-11-20 15:30:00	MSFT	Stock	54.105	54.2	54.005	54.18	4205647.0
2015-11-20 16:00:00	MSFT	Stock	54.18	54.23	54.15	54.19	1844801.0

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

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