PREVIEW / stock_30min / 2014-08-19

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-19.parquet
  size:    1.6 MB
  rows:    82,337
  symbols: 3,571

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
2014-08-19 04:00:00	AAPL	Stock	24.85	24.915	24.85	24.9	39744.0
2014-08-19 04:30:00	AAPL	Stock	24.9	24.92	24.8975	24.9	8840.0
2014-08-19 05:00:00	AAPL	Stock	24.9	24.9	24.9	24.9	3464.0
2014-08-19 05:30:00	AAPL	Stock	24.905	24.905	24.885	24.9	5288.0
2014-08-19 06:00:00	AAPL	Stock	24.9	24.9	24.875	24.875	27200.0
2014-08-19 06:30:00	AAPL	Stock	24.8875	24.8875	24.85	24.8625	124432.0
2014-08-19 07:00:00	AAPL	Stock	24.85	24.875	24.85	24.8725	66424.0
2014-08-19 07:30:00	AAPL	Stock	24.8725	24.9	24.8725	24.8875	332556.0
2014-08-19 08:00:00	AAPL	Stock	24.8875	24.91	24.79	24.895	476460.0
2014-08-19 08:30:00	AAPL	Stock	24.8875	24.9075	24.8775	24.8875	433184.0
2014-08-19 09:00:00	AAPL	Stock	24.8875	24.895	24.8425	24.855	694840.0
2014-08-19 09:30:00	AAPL	Stock	24.855	24.97	24.83	24.9587	32341164.0
2014-08-19 10:00:00	AAPL	Stock	24.9575	24.985	24.89	24.9425	21249496.0
2014-08-19 10:30:00	AAPL	Stock	24.9425	24.965	24.9025	24.9398	10857704.0
2014-08-19 11:00:00	AAPL	Stock	24.9388	24.95	24.8875	24.935	10957764.0
2014-08-19 11:30:00	AAPL	Stock	24.935	25.0	24.935	24.995	20198348.0
2014-08-19 12:00:00	AAPL	Stock	24.995	25.1	24.96	25.0868	40911640.0
2014-08-19 12:30:00	AAPL	Stock	25.0862	25.1312	25.055	25.08	19232320.0
2014-08-19 13:00:00	AAPL	Stock	25.08	25.1175	25.0525	25.1075	12530952.0
2014-08-19 13:30:00	AAPL	Stock	25.1075	25.1375	25.0675	25.105	12316268.0
2014-08-19 14:00:00	AAPL	Stock	25.1075	25.145	25.09	25.14	10027608.0
2014-08-19 14:30:00	AAPL	Stock	25.14	25.155	25.0825	25.1	11978712.0
2014-08-19 15:00:00	AAPL	Stock	25.0975	25.16	25.0975	25.1425	13906120.0
2014-08-19 15:30:00	AAPL	Stock	25.14	25.17	25.07	25.1375	26421476.0
2014-08-19 16:00:00	AAPL	Stock	25.14	25.14	25.0975	25.12	11620192.0
2014-08-19 16:30:00	AAPL	Stock	25.115	25.143	25.11	25.125	918568.0
2014-08-19 17:00:00	AAPL	Stock	25.1275	25.1275	25.1125	25.1225	51484.0
2014-08-19 17:30:00	AAPL	Stock	25.1225	25.14	25.1125	25.115	262908.0
2014-08-19 18:00:00	AAPL	Stock	25.1175	25.1175	25.095	25.1	93800.0
2014-08-19 18:30:00	AAPL	Stock	25.1	25.14	25.08	25.095	294468.0
2014-08-19 19:00:00	AAPL	Stock	25.095	25.095	25.0825	25.09	64132.0
2014-08-19 19:30:00	AAPL	Stock	25.0925	25.1075	25.0875	25.1075	84792.0
2014-08-19 04:00:00	MSFT	Stock	45.08	45.1	45.08	45.1	200.0
2014-08-19 07:30:00	MSFT	Stock	44.99	45.0	44.99	45.0	780.0
2014-08-19 08:00:00	MSFT	Stock	44.98	44.98	44.75	44.93	7065.0
2014-08-19 08:30:00	MSFT	Stock	44.94	44.94	44.88	44.94	4800.0
2014-08-19 09:00:00	MSFT	Stock	44.9	45.0	44.9	44.99	29597.0
2014-08-19 09:30:00	MSFT	Stock	44.98	45.02	44.83	44.95	3040836.0
2014-08-19 10:00:00	MSFT	Stock	44.94	45.12	44.88	45.105	1725173.0
2014-08-19 10:30:00	MSFT	Stock	45.105	45.25	45.1	45.22	2254577.0
2014-08-19 11:00:00	MSFT	Stock	45.225	45.25	45.1	45.11	1645402.0
2014-08-19 11:30:00	MSFT	Stock	45.12	45.13	45.01	45.053	1557689.0
2014-08-19 12:00:00	MSFT	Stock	45.05	45.09	45.03	45.089	1092608.0
2014-08-19 12:30:00	MSFT	Stock	45.09	45.12	45.03	45.04	786323.0
2014-08-19 13:00:00	MSFT	Stock	45.04	45.07	45.03	45.04	638781.0
2014-08-19 13:30:00	MSFT	Stock	45.04	45.06	45.0	45.045	1261584.0
2014-08-19 14:00:00	MSFT	Stock	45.041	45.12	45.03	45.07	1271552.0
2014-08-19 14:30:00	MSFT	Stock	45.07	45.1	45.07	45.09	897440.0
2014-08-19 15:00:00	MSFT	Stock	45.09	45.18	45.09	45.12	1356062.0
2014-08-19 15:30:00	MSFT	Stock	45.13	45.34	45.12	45.33	5692373.0

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

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