PREVIEW / stock_30min / 2013-06-19

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-19.parquet
  size:    1.5 MB
  rows:    78,558
  symbols: 3,518

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-06-19 06:00:00	AAPL	Stock	15.4325	15.4325	15.4325	15.4325	2800.0
2013-06-19 06:30:00	AAPL	Stock	15.4279	15.4279	15.4279	15.4279	2800.0
2013-06-19 07:00:00	AAPL	Stock	15.4221	15.4221	15.4039	15.4086	61600.0
2013-06-19 07:30:00	AAPL	Stock	15.4043	15.4043	15.3929	15.4029	108556.0
2013-06-19 08:00:00	AAPL	Stock	15.4036	15.4154	15.3929	15.4107	178444.0
2013-06-19 08:30:00	AAPL	Stock	15.4018	15.4086	15.3982	15.4071	70924.0
2013-06-19 09:00:00	AAPL	Stock	15.4089	15.4093	15.3861	15.3939	166152.0
2013-06-19 09:30:00	AAPL	Stock	15.3946	15.4164	15.3146	15.3241	33188176.0
2013-06-19 10:00:00	AAPL	Stock	15.3254	15.3371	15.2689	15.3004	29682520.0
2013-06-19 10:30:00	AAPL	Stock	15.3	15.335	15.2839	15.2916	14428736.0
2013-06-19 11:00:00	AAPL	Stock	15.2943	15.3118	15.2479	15.2589	15448048.0
2013-06-19 11:30:00	AAPL	Stock	15.2586	15.2721	15.2321	15.2511	12568024.0
2013-06-19 12:00:00	AAPL	Stock	15.2507	15.2993	15.2471	15.2828	10230528.0
2013-06-19 12:30:00	AAPL	Stock	15.2859	15.2904	15.2579	15.2671	6244504.0
2013-06-19 13:00:00	AAPL	Stock	15.2679	15.2786	15.2571	15.2614	6176492.0
2013-06-19 13:30:00	AAPL	Stock	15.2607	15.2668	15.2411	15.2496	9781072.0
2013-06-19 14:00:00	AAPL	Stock	15.2529	15.2945	15.1936	15.2668	32619048.0
2013-06-19 14:30:00	AAPL	Stock	15.2664	15.29	15.1661	15.1789	26650400.0
2013-06-19 15:00:00	AAPL	Stock	15.1782	15.2243	15.1679	15.2096	21726460.0
2013-06-19 15:30:00	AAPL	Stock	15.2125	15.2214	15.1071	15.1073	46341652.0
2013-06-19 16:00:00	AAPL	Stock	15.1073	15.3177	15.1068	15.1186	22249808.0
2013-06-19 16:30:00	AAPL	Stock	15.1071	15.1314	15.1071	15.1304	2797956.0
2013-06-19 17:00:00	AAPL	Stock	15.1254	15.2406	15.1071	15.125	281260.0
2013-06-19 17:30:00	AAPL	Stock	15.1214	15.1239	15.1168	15.1196	70700.0
2013-06-19 18:00:00	AAPL	Stock	15.1214	15.1214	15.1075	15.1136	94892.0
2013-06-19 18:30:00	AAPL	Stock	15.1107	15.1139	15.1107	15.1139	14000.0
2013-06-19 19:00:00	AAPL	Stock	15.11	15.1179	15.11	15.1179	11900.0
2013-06-19 19:30:00	AAPL	Stock	15.1161	15.1211	15.1107	15.1168	50120.0
2013-06-19 06:00:00	MSFT	Stock	35.02	35.02	35.02	35.02	100.0
2013-06-19 08:30:00	MSFT	Stock	34.94	34.96	34.86	34.88	2620.0
2013-06-19 09:00:00	MSFT	Stock	34.92	35.02	34.92	34.97	8975.0
2013-06-19 09:30:00	MSFT	Stock	34.96	34.98	34.77	34.86	2510454.0
2013-06-19 10:00:00	MSFT	Stock	34.855	35.0	34.83	35.0	1480702.0
2013-06-19 10:30:00	MSFT	Stock	34.995	35.09	34.9	34.93	1826987.0
2013-06-19 11:00:00	MSFT	Stock	34.94	34.94	34.88	34.912	1451042.0
2013-06-19 11:30:00	MSFT	Stock	34.91	35.01	34.88	34.96	1618489.0
2013-06-19 12:00:00	MSFT	Stock	34.96	35.03	34.96	35.0	1313946.0
2013-06-19 12:30:00	MSFT	Stock	34.99	35.01	34.98	34.995	541586.0
2013-06-19 13:00:00	MSFT	Stock	34.993	35.0	34.955	34.98	793480.0
2013-06-19 13:30:00	MSFT	Stock	34.979	35.0	34.95	34.98	948581.0
2013-06-19 14:00:00	MSFT	Stock	34.98	35.0	34.85	34.945	3484359.0
2013-06-19 14:30:00	MSFT	Stock	34.94	35.01	34.61	34.7	3900609.0
2013-06-19 15:00:00	MSFT	Stock	34.7	34.89	34.625	34.88	3019504.0
2013-06-19 15:30:00	MSFT	Stock	34.88	34.9	34.6	34.6	4664416.0
2013-06-19 16:00:00	MSFT	Stock	34.59	35.034	34.41	34.48	2683815.0
2013-06-19 16:30:00	MSFT	Stock	34.59	34.94	34.42	34.59	56664.0
2013-06-19 17:00:00	MSFT	Stock	34.6	34.848	34.51	34.59	60300.0
2013-06-19 17:30:00	MSFT	Stock	34.6	34.6	34.59	34.59	5000.0
2013-06-19 18:00:00	MSFT	Stock	34.54	34.54	34.54	34.54	100.0
2013-06-19 18:30:00	MSFT	Stock	34.58	34.62	34.58	34.62	1900.0

> showing 50 of 78,558 rows — these rows as CSV

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