PREVIEW / stock_30min / 2007-04-19

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-19.parquet
  size:    1.0 MB
  rows:    56,569
  symbols: 2,575

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
2007-04-19 04:00:00	AAPL	Stock	3.2057	3.2057	3.2057	3.2057	2800.0
2007-04-19 06:00:00	AAPL	Stock	3.2143	3.2143	3.2075	3.2075	16800.0
2007-04-19 07:30:00	AAPL	Stock	3.2236	3.2236	3.2236	3.2236	26628.0
2007-04-19 08:00:00	AAPL	Stock	3.2179	3.2211	3.2107	3.2211	347480.0
2007-04-19 08:30:00	AAPL	Stock	3.2196	3.2196	3.2143	3.215	292040.0
2007-04-19 09:00:00	AAPL	Stock	3.215	3.2243	3.2143	3.2207	2224964.0
2007-04-19 09:30:00	AAPL	Stock	3.2211	3.2525	3.2082	3.2461	82318264.0
2007-04-19 10:00:00	AAPL	Stock	3.2461	3.2536	3.2321	3.2396	55527556.0
2007-04-19 10:30:00	AAPL	Stock	3.24	3.2418	3.2329	3.2407	21639744.0
2007-04-19 11:00:00	AAPL	Stock	3.2411	3.2589	3.2371	3.2539	38896564.0
2007-04-19 11:30:00	AAPL	Stock	3.2539	3.2543	3.2443	3.2475	29818208.0
2007-04-19 12:00:00	AAPL	Stock	3.2475	3.2518	3.2429	3.2439	18854332.0
2007-04-19 12:30:00	AAPL	Stock	3.2436	3.2468	3.2364	3.2386	26522160.0
2007-04-19 13:00:00	AAPL	Stock	3.2386	3.2432	3.2329	3.2361	21205044.0
2007-04-19 13:30:00	AAPL	Stock	3.2357	3.2361	3.2236	3.2275	19310676.0
2007-04-19 14:00:00	AAPL	Stock	3.2271	3.2318	3.2161	3.2196	23892456.0
2007-04-19 14:30:00	AAPL	Stock	3.2193	3.2257	3.215	3.2161	17989636.0
2007-04-19 15:00:00	AAPL	Stock	3.2161	3.2304	3.2161	3.2229	19133828.0
2007-04-19 15:30:00	AAPL	Stock	3.2232	3.2243	3.2146	3.2239	35701820.0
2007-04-19 16:00:00	AAPL	Stock	3.22	3.2286	3.215	3.2221	3891776.0
2007-04-19 16:30:00	AAPL	Stock	3.2221	3.2246	3.2171	3.2246	644812.0
2007-04-19 17:00:00	AAPL	Stock	3.2246	3.2275	3.2232	3.2232	1102696.0
2007-04-19 17:30:00	AAPL	Stock	3.2232	3.225	3.2214	3.2214	140000.0
2007-04-19 18:00:00	AAPL	Stock	3.2214	3.225	3.2214	3.225	155820.0
2007-04-19 18:30:00	AAPL	Stock	3.225	3.225	3.225	3.225	124068.0
2007-04-19 19:00:00	AAPL	Stock	3.2192	3.2275	3.2189	3.2275	73500.0
2007-04-19 19:30:00	AAPL	Stock	3.2282	3.2282	3.2264	3.2282	48104.0
2007-04-19 08:00:00	MSFT	Stock	28.45	28.45	28.37	28.38	2500.0
2007-04-19 08:30:00	MSFT	Stock	28.43	28.43	28.37	28.39	9170.0
2007-04-19 09:00:00	MSFT	Stock	28.39	28.39	28.33	28.34	38079.0
2007-04-19 09:30:00	MSFT	Stock	28.34	28.66	28.26	28.55	5561911.0
2007-04-19 10:00:00	MSFT	Stock	28.545	28.74	28.5	28.68	4547351.0
2007-04-19 10:30:00	MSFT	Stock	28.68	28.72	28.65	28.7	2701451.0
2007-04-19 11:00:00	MSFT	Stock	28.7	28.84	28.65	28.78	3035257.0
2007-04-19 11:30:00	MSFT	Stock	28.78	28.89	28.65	28.86	1991517.0
2007-04-19 12:00:00	MSFT	Stock	28.85	28.88	28.78	28.79	2860071.0
2007-04-19 12:30:00	MSFT	Stock	28.79	28.8	28.74	28.76	1430007.0
2007-04-19 13:00:00	MSFT	Stock	28.76	28.77	28.66	28.67	1558475.0
2007-04-19 13:30:00	MSFT	Stock	28.66	28.7	28.66	28.69	1450667.0
2007-04-19 14:00:00	MSFT	Stock	28.69	28.76	28.65	28.7	4992119.0
2007-04-19 14:30:00	MSFT	Stock	28.7	28.75	28.64	28.67	2216719.0
2007-04-19 15:00:00	MSFT	Stock	28.67	28.71	28.6	28.671	3465120.0
2007-04-19 15:30:00	MSFT	Stock	28.68	28.7	28.56	28.68	4772761.0
2007-04-19 16:00:00	MSFT	Stock	28.69	28.72	28.69	28.69	864750.0
2007-04-19 16:30:00	MSFT	Stock	28.69	28.69	28.68	28.68	403794.0
2007-04-19 17:00:00	MSFT	Stock	28.68	28.71	28.68	28.71	1110.0
2007-04-19 17:30:00	MSFT	Stock	28.74	28.74	28.69	28.74	1178393.0
2007-04-19 18:00:00	MSFT	Stock	28.71	28.73	28.71	28.73	1350.0
2007-04-19 18:30:00	MSFT	Stock	28.73	28.73	28.73	28.73	2850.0
2007-04-19 19:00:00	MSFT	Stock	28.73	28.73	28.73	28.73	1800.0

> showing 50 of 56,569 rows — these rows as CSV

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