PREVIEW / stock_30min / 2013-07-23

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-23.parquet
  size:    1.5 MB
  rows:    79,413
  symbols: 3,504

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
2013-07-23 04:00:00	AAPL	Stock	15.2607	15.2607	15.2607	15.2607	5600.0
2013-07-23 06:30:00	AAPL	Stock	15.2493	15.2529	15.2493	15.2529	14028.0
2013-07-23 07:00:00	AAPL	Stock	15.2554	15.2554	15.2443	15.2482	78400.0
2013-07-23 07:30:00	AAPL	Stock	15.2679	15.3221	15.2639	15.3221	145432.0
2013-07-23 08:00:00	AAPL	Stock	15.3214	15.3389	15.1964	15.2607	582848.0
2013-07-23 08:30:00	AAPL	Stock	15.2607	15.2779	15.2607	15.2696	174860.0
2013-07-23 09:00:00	AAPL	Stock	15.2679	15.2786	15.2143	15.225	428456.0
2013-07-23 09:30:00	AAPL	Stock	15.2171	15.2486	15.0989	15.1164	35863968.0
2013-07-23 10:00:00	AAPL	Stock	15.1196	15.1339	15.0575	15.1054	26497156.0
2013-07-23 10:30:00	AAPL	Stock	15.1078	15.1121	15.0629	15.0984	17482388.0
2013-07-23 11:00:00	AAPL	Stock	15.0982	15.1586	15.0796	15.1407	17215212.0
2013-07-23 11:30:00	AAPL	Stock	15.1407	15.1535	15.1257	15.145	7953540.0
2013-07-23 12:00:00	AAPL	Stock	15.1436	15.1436	15.0832	15.0964	11538408.0
2013-07-23 12:30:00	AAPL	Stock	15.0955	15.1179	15.0832	15.1014	9947476.0
2013-07-23 13:00:00	AAPL	Stock	15.1029	15.1343	15.0978	15.1221	8174712.0
2013-07-23 13:30:00	AAPL	Stock	15.1214	15.135	15.1136	15.1229	7951300.0
2013-07-23 14:00:00	AAPL	Stock	15.1211	15.1264	15.0793	15.0982	9864848.0
2013-07-23 14:30:00	AAPL	Stock	15.1004	15.125	15.0832	15.1143	8692264.0
2013-07-23 15:00:00	AAPL	Stock	15.1143	15.1146	15.0291	15.0307	24408860.0
2013-07-23 15:30:00	AAPL	Stock	15.0325	15.0593	14.9539	14.9636	65141748.0
2013-07-23 16:00:00	AAPL	Stock	14.9639	15.1429	14.9593	14.9982	5823272.0
2013-07-23 16:30:00	AAPL	Stock	14.9982	15.7857	14.9609	15.7404	77292348.0
2013-07-23 17:00:00	AAPL	Stock	15.7321	15.7432	15.0151	15.6071	14256200.0
2013-07-23 17:30:00	AAPL	Stock	15.6068	15.6096	15.3929	15.5	8494164.0
2013-07-23 18:00:00	AAPL	Stock	15.495	15.5089	15.4575	15.4961	1845732.0
2013-07-23 18:30:00	AAPL	Stock	15.4971	15.5357	15.4646	15.5107	1303036.0
2013-07-23 19:00:00	AAPL	Stock	15.5007	15.5643	15.4889	15.5643	957348.0
2013-07-23 19:30:00	AAPL	Stock	15.5579	15.5718	15.5429	15.5493	1038296.0
2013-07-23 04:30:00	MSFT	Stock	31.99	31.99	31.99	31.99	529.0
2013-07-23 05:30:00	MSFT	Stock	31.99	31.99	31.99	31.99	600.0
2013-07-23 06:30:00	MSFT	Stock	32.01	32.01	32.01	32.01	1100.0
2013-07-23 07:00:00	MSFT	Stock	32.03	32.03	31.9	31.9	2800.0
2013-07-23 07:30:00	MSFT	Stock	31.98	32.0	31.98	32.0	9560.0
2013-07-23 08:00:00	MSFT	Stock	32.0	32.0	31.9	31.96	30450.0
2013-07-23 08:30:00	MSFT	Stock	31.95	32.01	31.92	32.01	275792.0
2013-07-23 09:00:00	MSFT	Stock	31.98	32.0	31.89	31.91	91069.0
2013-07-23 09:30:00	MSFT	Stock	31.91	32.03	31.8	31.88	10753550.0
2013-07-23 10:00:00	MSFT	Stock	31.88	31.95	31.75	31.8	5858312.0
2013-07-23 10:30:00	MSFT	Stock	31.8	31.9	31.77	31.79	4108617.0
2013-07-23 11:00:00	MSFT	Stock	31.785	31.84	31.71	31.83	3815787.0
2013-07-23 11:30:00	MSFT	Stock	31.83	31.84	31.72	31.766	2782168.0
2013-07-23 12:00:00	MSFT	Stock	31.77	31.81	31.71	31.79	2342785.0
2013-07-23 12:30:00	MSFT	Stock	31.8	31.84	31.79	31.82	1937774.0
2013-07-23 13:00:00	MSFT	Stock	31.815	31.99	31.81	31.99	3983375.0
2013-07-23 13:30:00	MSFT	Stock	31.985	32.04	31.95	31.951	4967317.0
2013-07-23 14:00:00	MSFT	Stock	31.95	31.95	31.79	31.815	2613360.0
2013-07-23 14:30:00	MSFT	Stock	31.81	31.92	31.8	31.89	3972356.0
2013-07-23 15:00:00	MSFT	Stock	31.88	31.95	31.86	31.946	3169033.0
2013-07-23 15:30:00	MSFT	Stock	31.95	31.97	31.78	31.83	12296335.0
2013-07-23 16:00:00	MSFT	Stock	31.82	31.97	31.7	31.82	2298103.0

> showing 50 of 79,413 rows — these rows as CSV

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