PREVIEW / stock_30min / 2008-07-08

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-07-08.parquet
  size:    1.3 MB
  rows:    69,724
  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-07-08 04:00:00	AAPL	Stock	6.2393	6.2393	6.2179	6.2179	8400.0
2008-07-08 04:30:00	AAPL	Stock	6.2179	6.2179	6.2179	6.2179	5600.0
2008-07-08 07:00:00	AAPL	Stock	6.2268	6.2268	6.2268	6.2268	21000.0
2008-07-08 07:30:00	AAPL	Stock	6.2318	6.2393	6.2161	6.2161	154028.0
2008-07-08 08:00:00	AAPL	Stock	6.2196	6.2668	6.2179	6.2643	2033948.0
2008-07-08 08:30:00	AAPL	Stock	6.2643	6.2804	6.2525	6.26	1503264.0
2008-07-08 09:00:00	AAPL	Stock	6.2618	6.2818	6.2607	6.2679	1480864.0
2008-07-08 09:30:00	AAPL	Stock	6.2643	6.3304	6.2264	6.2868	111606180.0
2008-07-08 10:00:00	AAPL	Stock	6.2854	6.3036	6.2346	6.2518	91358120.0
2008-07-08 10:30:00	AAPL	Stock	6.2514	6.2768	6.2018	6.2096	73759728.0
2008-07-08 11:00:00	AAPL	Stock	6.21	6.2775	6.1693	6.2675	79995496.0
2008-07-08 11:30:00	AAPL	Stock	6.2675	6.2682	6.2321	6.2411	37995048.0
2008-07-08 12:00:00	AAPL	Stock	6.2411	6.3021	6.2214	6.3018	44119572.0
2008-07-08 12:30:00	AAPL	Stock	6.3	6.3161	6.2932	6.3089	44653056.0
2008-07-08 13:00:00	AAPL	Stock	6.3089	6.3214	6.2679	6.2896	43690976.0
2008-07-08 13:30:00	AAPL	Stock	6.2904	6.2943	6.2571	6.2796	38840228.0
2008-07-08 14:00:00	AAPL	Stock	6.2808	6.3529	6.2761	6.3446	64924048.0
2008-07-08 14:30:00	AAPL	Stock	6.345	6.3907	6.3421	6.3857	75157432.0
2008-07-08 15:00:00	AAPL	Stock	6.3854	6.3986	6.36	6.3911	63562604.0
2008-07-08 15:30:00	AAPL	Stock	6.3904	6.4179	6.3796	6.4175	86448292.0
2008-07-08 16:00:00	AAPL	Stock	6.4175	6.4175	6.2996	6.4175	14085932.0
2008-07-08 16:30:00	AAPL	Stock	6.4011	6.4175	6.4011	6.4175	2183328.0
2008-07-08 17:00:00	AAPL	Stock	6.4114	6.4211	6.4071	6.4154	326228.0
2008-07-08 17:30:00	AAPL	Stock	6.4125	6.4218	6.4114	6.4143	221536.0
2008-07-08 18:00:00	AAPL	Stock	6.4143	6.4161	6.4111	6.4111	181440.0
2008-07-08 18:30:00	AAPL	Stock	6.4125	6.4157	6.4125	6.4157	31080.0
2008-07-08 19:00:00	AAPL	Stock	6.4161	6.4193	6.4157	6.4161	49476.0
2008-07-08 19:30:00	AAPL	Stock	6.4193	6.4218	6.4168	6.42	79240.0
2008-07-08 07:30:00	MSFT	Stock	26.03	26.03	25.9	25.9	3600.0
2008-07-08 08:00:00	MSFT	Stock	25.9	26.06	25.9	26.04	4760.0
2008-07-08 08:30:00	MSFT	Stock	26.04	26.15	26.03	26.03	6250.0
2008-07-08 09:00:00	MSFT	Stock	26.05	26.07	25.8	25.92	109958.0
2008-07-08 09:30:00	MSFT	Stock	25.92	26.14	25.73	25.96	6780351.0
2008-07-08 10:00:00	MSFT	Stock	25.95	26.2	25.88	25.99	4824649.0
2008-07-08 10:30:00	MSFT	Stock	25.99	26.09	25.822	25.951	3527146.0
2008-07-08 11:00:00	MSFT	Stock	25.96	26.04	25.82	26.03	4268770.0
2008-07-08 11:30:00	MSFT	Stock	26.03	26.04	25.87	25.9	2935682.0
2008-07-08 12:00:00	MSFT	Stock	25.91	26.04	25.875	26.01	2509997.0
2008-07-08 12:30:00	MSFT	Stock	26.0	26.06	25.95	25.97	2056336.0
2008-07-08 13:00:00	MSFT	Stock	25.972	26.05	25.8	25.81	3368786.0
2008-07-08 13:30:00	MSFT	Stock	25.82	25.82	25.54	25.54	4854076.0
2008-07-08 14:00:00	MSFT	Stock	25.54	25.61	25.52	25.55	5649664.0
2008-07-08 14:30:00	MSFT	Stock	25.54	25.7	25.51	25.68	5660046.0
2008-07-08 15:00:00	MSFT	Stock	25.68	25.81	25.63	25.8	6090114.0
2008-07-08 15:30:00	MSFT	Stock	25.79	25.89	25.74	25.84	8619342.0
2008-07-08 16:00:00	MSFT	Stock	25.83	25.915	25.7	25.85	3112158.0
2008-07-08 16:30:00	MSFT	Stock	25.73	25.85	25.71	25.85	234255.0
2008-07-08 17:00:00	MSFT	Stock	25.73	25.8	25.73	25.75	15828.0
2008-07-08 17:30:00	MSFT	Stock	25.75	25.79	25.75	25.79	3950.0
2008-07-08 18:00:00	MSFT	Stock	25.75	25.82	25.75	25.82	11279.0

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

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