PREVIEW / stock_30min / 2015-04-06

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-06.parquet
  size:    1.6 MB
  rows:    82,536
  symbols: 3,526

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-04-06 04:00:00	AAPL	Stock	31.2825	31.305	31.125	31.125	17916.0
2015-04-06 04:30:00	AAPL	Stock	31.1275	31.1275	31.125	31.125	3596.0
2015-04-06 05:00:00	AAPL	Stock	31.125	31.125	31.125	31.125	3120.0
2015-04-06 06:00:00	AAPL	Stock	31.15	31.15	31.1125	31.1425	10004.0
2015-04-06 06:30:00	AAPL	Stock	31.1375	31.1375	31.0925	31.0925	4800.0
2015-04-06 07:00:00	AAPL	Stock	31.135	31.1625	31.125	31.1275	82780.0
2015-04-06 07:30:00	AAPL	Stock	31.13	31.17	31.1275	31.15	65056.0
2015-04-06 08:00:00	AAPL	Stock	31.1575	31.165	31.085	31.0875	437468.0
2015-04-06 08:30:00	AAPL	Stock	31.0875	31.1322	31.0875	31.1198	262060.0
2015-04-06 09:00:00	AAPL	Stock	31.115	31.1475	31.095	31.1175	491248.0
2015-04-06 09:30:00	AAPL	Stock	31.1175	31.4625	31.0825	31.4475	19849008.0
2015-04-06 10:00:00	AAPL	Stock	31.4498	31.7655	31.4498	31.725	21236424.0
2015-04-06 10:30:00	AAPL	Stock	31.72	31.79	31.6925	31.7475	12716016.0
2015-04-06 11:00:00	AAPL	Stock	31.7475	31.7975	31.6675	31.69	8141328.0
2015-04-06 11:30:00	AAPL	Stock	31.69	31.7925	31.68	31.7835	8020852.0
2015-04-06 12:00:00	AAPL	Stock	31.7825	31.83	31.7675	31.7938	7822272.0
2015-04-06 12:30:00	AAPL	Stock	31.795	31.805	31.7575	31.7875	4608692.0
2015-04-06 13:00:00	AAPL	Stock	31.785	31.8275	31.785	31.82	4411188.0
2015-04-06 13:30:00	AAPL	Stock	31.8212	31.84	31.7825	31.798	5550436.0
2015-04-06 14:00:00	AAPL	Stock	31.8	31.81	31.735	31.7872	6363540.0
2015-04-06 14:30:00	AAPL	Stock	31.785	31.81	31.765	31.81	3967356.0
2015-04-06 15:00:00	AAPL	Stock	31.8085	31.8625	31.775	31.8388	9164960.0
2015-04-06 15:30:00	AAPL	Stock	31.8375	31.8775	31.805	31.835	14777020.0
2015-04-06 16:00:00	AAPL	Stock	31.8375	31.8625	31.825	31.86	6188792.0
2015-04-06 16:30:00	AAPL	Stock	31.86	31.86	31.674	31.85	73516.0
2015-04-06 17:00:00	AAPL	Stock	31.85	31.87	31.8475	31.8625	43320.0
2015-04-06 17:30:00	AAPL	Stock	31.855	31.8725	31.8375	31.8725	65584.0
2015-04-06 18:00:00	AAPL	Stock	31.8625	31.875	31.855	31.8725	67532.0
2015-04-06 18:30:00	AAPL	Stock	31.875	31.875	31.8575	31.8698	42528.0
2015-04-06 19:00:00	AAPL	Stock	31.8698	31.875	31.8698	31.875	58336.0
2015-04-06 19:30:00	AAPL	Stock	31.875	31.8875	31.8625	31.8625	150356.0
2015-04-06 04:00:00	MSFT	Stock	40.15	40.15	40.15	40.15	100.0
2015-04-06 05:00:00	MSFT	Stock	40.27	40.27	40.27	40.27	800.0
2015-04-06 05:30:00	MSFT	Stock	40.25	40.27	40.25	40.27	1500.0
2015-04-06 06:00:00	MSFT	Stock	40.25	40.4	40.25	40.4	1500.0
2015-04-06 06:30:00	MSFT	Stock	40.35	40.43	40.35	40.43	200.0
2015-04-06 07:00:00	MSFT	Stock	40.43	40.45	40.43	40.45	1300.0
2015-04-06 07:30:00	MSFT	Stock	40.45	40.51	40.45	40.51	3600.0
2015-04-06 08:00:00	MSFT	Stock	40.45	40.5	40.43	40.43	8300.0
2015-04-06 08:30:00	MSFT	Stock	40.43	40.45	40.41	40.45	10096.0
2015-04-06 09:00:00	MSFT	Stock	40.44	40.45	40.34	40.34	35339.0
2015-04-06 09:30:00	MSFT	Stock	40.34	40.65	40.18	40.58	4452265.0
2015-04-06 10:00:00	MSFT	Stock	40.59	40.78	40.55	40.77	2427600.0
2015-04-06 10:30:00	MSFT	Stock	40.77	40.97	40.765	40.945	2445525.0
2015-04-06 11:00:00	MSFT	Stock	40.94	41.12	40.94	41.115	2197171.0
2015-04-06 11:30:00	MSFT	Stock	41.11	41.13	41.03	41.105	1433342.0
2015-04-06 12:00:00	MSFT	Stock	41.11	41.175	41.08	41.155	1444094.0
2015-04-06 12:30:00	MSFT	Stock	41.15	41.31	41.145	41.3	1407485.0
2015-04-06 13:00:00	MSFT	Stock	41.3	41.46	41.3	41.45	1977532.0
2015-04-06 13:30:00	MSFT	Stock	41.445	41.47	41.4	41.447	1301131.0

> showing 50 of 82,536 rows — these rows as CSV

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