PREVIEW / stock_30min / 2010-06-14

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-14.parquet
  size:    1.4 MB
  rows:    74,054
  symbols: 3,467

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
2010-06-14 04:00:00	AAPL	Stock	9.0943	9.0943	9.0943	9.0943	2800.0
2010-06-14 04:30:00	AAPL	Stock	9.0921	9.1039	9.0921	9.1039	11200.0
2010-06-14 05:00:00	AAPL	Stock	9.1204	9.125	9.1204	9.125	5600.0
2010-06-14 05:30:00	AAPL	Stock	9.1321	9.1729	9.125	9.1521	35056.0
2010-06-14 06:00:00	AAPL	Stock	9.1643	9.1643	9.1643	9.1643	8456.0
2010-06-14 06:30:00	AAPL	Stock	9.1643	9.1643	9.1429	9.1429	23072.0
2010-06-14 07:00:00	AAPL	Stock	9.1293	9.1429	9.1129	9.1339	194600.0
2010-06-14 07:30:00	AAPL	Stock	9.1343	9.1429	9.1214	9.1375	211176.0
2010-06-14 08:00:00	AAPL	Stock	9.1361	9.15	9.0686	9.1429	1383228.0
2010-06-14 08:30:00	AAPL	Stock	9.1429	9.1504	9.1375	9.1471	1218840.0
2010-06-14 09:00:00	AAPL	Stock	9.1457	9.1579	9.1339	9.1411	3138296.0
2010-06-14 09:30:00	AAPL	Stock	9.1407	9.1889	9.1161	9.175	85866508.0
2010-06-14 10:00:00	AAPL	Stock	9.1764	9.2336	9.1721	9.2243	57944460.0
2010-06-14 10:30:00	AAPL	Stock	9.2246	9.2279	9.1864	9.2175	39215204.0
2010-06-14 11:00:00	AAPL	Stock	9.2179	9.2554	9.2093	9.2345	41432272.0
2010-06-14 11:30:00	AAPL	Stock	9.2346	9.25	9.2286	9.2296	20704208.0
2010-06-14 12:00:00	AAPL	Stock	9.2307	9.2475	9.2189	9.2275	20592992.0
2010-06-14 12:30:00	AAPL	Stock	9.2261	9.2336	9.2021	9.2054	20994932.0
2010-06-14 13:00:00	AAPL	Stock	9.2057	9.2136	9.1786	9.1925	35273980.0
2010-06-14 13:30:00	AAPL	Stock	9.1932	9.2171	9.1579	9.1586	33491276.0
2010-06-14 14:00:00	AAPL	Stock	9.1607	9.1761	9.1264	9.1536	54218332.0
2010-06-14 14:30:00	AAPL	Stock	9.1536	9.1578	9.1	9.1471	46594072.0
2010-06-14 15:00:00	AAPL	Stock	9.1464	9.1832	9.1193	9.1436	41800024.0
2010-06-14 15:30:00	AAPL	Stock	9.1436	9.1521	9.0718	9.0779	80404548.0
2010-06-14 16:00:00	AAPL	Stock	9.0782	9.2047	9.0732	9.0779	11430692.0
2010-06-14 16:30:00	AAPL	Stock	9.0786	9.1461	9.0768	9.0868	560112.0
2010-06-14 17:00:00	AAPL	Stock	9.2452	9.2452	9.0832	9.0911	130760.0
2010-06-14 17:30:00	AAPL	Stock	9.0918	9.0993	9.0914	9.0971	88368.0
2010-06-14 18:00:00	AAPL	Stock	9.0993	9.1061	9.0814	9.1018	248696.0
2010-06-14 18:30:00	AAPL	Stock	9.1004	9.1036	9.0929	9.0929	168924.0
2010-06-14 19:00:00	AAPL	Stock	9.1036	9.105	9.0936	9.0964	133168.0
2010-06-14 19:30:00	AAPL	Stock	9.0936	9.1071	9.0936	9.1071	339752.0
2010-06-14 06:00:00	MSFT	Stock	25.91	25.91	25.91	25.91	365.0
2010-06-14 07:00:00	MSFT	Stock	25.9	25.9	25.86	25.86	3700.0
2010-06-14 07:30:00	MSFT	Stock	25.85	25.86	25.84	25.86	1925.0
2010-06-14 08:00:00	MSFT	Stock	25.86	25.9	25.86	25.89	6909.0
2010-06-14 08:30:00	MSFT	Stock	25.88	25.9	25.88	25.88	8065.0
2010-06-14 09:00:00	MSFT	Stock	25.88	25.94	25.79	25.84	81605.0
2010-06-14 09:30:00	MSFT	Stock	25.87	25.96	25.54	25.65	7992150.0
2010-06-14 10:00:00	MSFT	Stock	25.65	25.82	25.63	25.792	5196002.0
2010-06-14 10:30:00	MSFT	Stock	25.8	25.84	25.74	25.815	3939700.0
2010-06-14 11:00:00	MSFT	Stock	25.815	25.84	25.73	25.73	2694882.0
2010-06-14 11:30:00	MSFT	Stock	25.735	25.735	25.61	25.66	3050690.0
2010-06-14 12:00:00	MSFT	Stock	25.66	25.72	25.65	25.685	2216004.0
2010-06-14 12:30:00	MSFT	Stock	25.69	25.77	25.68	25.705	2406417.0
2010-06-14 13:00:00	MSFT	Stock	25.7	25.77	25.67	25.694	3240268.0
2010-06-14 13:30:00	MSFT	Stock	25.7	25.78	25.6	25.61	2305400.0
2010-06-14 14:00:00	MSFT	Stock	25.61	25.65	25.55	25.645	2681412.0
2010-06-14 14:30:00	MSFT	Stock	25.645	25.7	25.56	25.685	2020218.0
2010-06-14 15:00:00	MSFT	Stock	25.685	25.71	25.59	25.592	2629398.0

> showing 50 of 74,054 rows — these rows as CSV

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