PREVIEW / stock_30min / 2008-06-25

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-06-25.parquet
  size:    1.3 MB
  rows:    69,238
  symbols: 3,347

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
2008-06-25 07:30:00	AAPL	Stock	6.2318	6.2396	6.2318	6.2396	43400.0
2008-06-25 08:00:00	AAPL	Stock	6.2396	6.24	6.22	6.2214	826784.0
2008-06-25 08:30:00	AAPL	Stock	6.2218	6.2461	6.2214	6.2354	1270136.0
2008-06-25 09:00:00	AAPL	Stock	6.2386	6.2468	6.2296	6.2321	1196244.0
2008-06-25 09:30:00	AAPL	Stock	6.2332	6.2839	6.21	6.2607	73305428.0
2008-06-25 10:00:00	AAPL	Stock	6.2604	6.27	6.2336	6.2446	42900228.0
2008-06-25 10:30:00	AAPL	Stock	6.2436	6.3175	6.2414	6.2989	54521488.0
2008-06-25 11:00:00	AAPL	Stock	6.2989	6.315	6.2882	6.3043	28086604.0
2008-06-25 11:30:00	AAPL	Stock	6.3046	6.3071	6.2836	6.3018	23389240.0
2008-06-25 12:00:00	AAPL	Stock	6.3008	6.3157	6.295	6.3082	18082708.0
2008-06-25 12:30:00	AAPL	Stock	6.3082	6.3143	6.295	6.3004	15363152.0
2008-06-25 13:00:00	AAPL	Stock	6.2993	6.3146	6.2893	6.3039	16397892.0
2008-06-25 13:30:00	AAPL	Stock	6.3033	6.3071	6.2929	6.3	14336532.0
2008-06-25 14:00:00	AAPL	Stock	6.3004	6.3554	6.3	6.3139	69193348.0
2008-06-25 14:30:00	AAPL	Stock	6.3129	6.3464	6.2936	6.3429	79793084.0
2008-06-25 15:00:00	AAPL	Stock	6.3432	6.3868	6.3261	6.3432	84052024.0
2008-06-25 15:30:00	AAPL	Stock	6.3432	6.3482	6.3029	6.3354	71585332.0
2008-06-25 16:00:00	AAPL	Stock	6.3354	6.3354	6.1739	6.25	16837856.0
2008-06-25 16:30:00	AAPL	Stock	6.25	6.3354	6.2439	6.25	2712724.0
2008-06-25 17:00:00	AAPL	Stock	6.2536	6.2554	6.2407	6.2532	1000944.0
2008-06-25 17:30:00	AAPL	Stock	6.2536	6.2657	6.2518	6.2589	308560.0
2008-06-25 18:00:00	AAPL	Stock	6.2589	6.3354	6.2529	6.3354	360220.0
2008-06-25 18:30:00	AAPL	Stock	6.2607	6.2643	6.2561	6.2639	234892.0
2008-06-25 19:00:00	AAPL	Stock	6.2593	6.26	6.2564	6.2564	53200.0
2008-06-25 19:30:00	AAPL	Stock	6.2557	6.2632	6.2554	6.2554	78540.0
2008-06-25 07:00:00	MSFT	Stock	27.88	28.8	27.88	28.0	1700.0
2008-06-25 08:00:00	MSFT	Stock	27.9	27.9	27.85	27.87	10426.0
2008-06-25 08:30:00	MSFT	Stock	27.87	28.0	27.81	27.87	18194.0
2008-06-25 09:00:00	MSFT	Stock	27.88	28.04	27.76	27.77	32166.0
2008-06-25 09:30:00	MSFT	Stock	27.79	28.33	27.76	28.17	5190341.0
2008-06-25 10:00:00	MSFT	Stock	28.17	28.26	28.07	28.13	3889780.0
2008-06-25 10:30:00	MSFT	Stock	28.13	28.41	28.13	28.29	4443033.0
2008-06-25 11:00:00	MSFT	Stock	28.29	28.39	28.24	28.36	3800177.0
2008-06-25 11:30:00	MSFT	Stock	28.365	28.42	28.35	28.372	2835634.0
2008-06-25 12:00:00	MSFT	Stock	28.37	28.39	28.35	28.38	1961994.0
2008-06-25 12:30:00	MSFT	Stock	28.38	28.45	28.36	28.379	3308356.0
2008-06-25 13:00:00	MSFT	Stock	28.378	28.4	28.245	28.25	3213032.0
2008-06-25 13:30:00	MSFT	Stock	28.25	28.27	28.18	28.24	2485679.0
2008-06-25 14:00:00	MSFT	Stock	28.24	28.49	28.22	28.36	6381128.0
2008-06-25 14:30:00	MSFT	Stock	28.36	28.56	28.23	28.51	6681072.0
2008-06-25 15:00:00	MSFT	Stock	28.51	28.67	28.42	28.5	6513129.0
2008-06-25 15:30:00	MSFT	Stock	28.51	28.55	28.32	28.35	8592713.0
2008-06-25 16:00:00	MSFT	Stock	28.35	28.48	28.271	28.33	2953213.0
2008-06-25 16:30:00	MSFT	Stock	28.35	28.36	28.29	28.36	342005.0
2008-06-25 17:00:00	MSFT	Stock	28.36	28.36	28.14	28.2	31985.0
2008-06-25 17:30:00	MSFT	Stock	28.2	28.2	28.15	28.15	13550.0
2008-06-25 18:00:00	MSFT	Stock	28.15	28.35	28.15	28.35	21107.0
2008-06-25 18:30:00	MSFT	Stock	28.22	28.25	28.18	28.18	2406.0
2008-06-25 19:00:00	MSFT	Stock	28.21	28.21	28.18	28.2	2206.0
2008-06-25 19:30:00	MSFT	Stock	28.23	28.23	28.2	28.2	1300.0

> showing 50 of 69,238 rows — these rows as CSV

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