PREVIEW / stock_30min / 2007-04-20

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-04-20.parquet
  size:    1.0 MB
  rows:    56,998
  symbols: 2,587

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-20 06:30:00	AAPL	Stock	3.25	3.25	3.2414	3.2414	16800.0
2007-04-20 07:00:00	AAPL	Stock	3.255	3.2564	3.255	3.2564	57400.0
2007-04-20 07:30:00	AAPL	Stock	3.2564	3.2564	3.2489	3.2518	149044.0
2007-04-20 08:00:00	AAPL	Stock	3.2489	3.2504	3.2432	3.2496	956368.0
2007-04-20 08:30:00	AAPL	Stock	3.2486	3.25	3.2464	3.2475	1168748.0
2007-04-20 09:00:00	AAPL	Stock	3.2475	3.25	3.2429	3.2457	6416900.0
2007-04-20 09:30:00	AAPL	Stock	3.246	3.2536	3.2354	3.24	129857812.0
2007-04-20 10:00:00	AAPL	Stock	3.2396	3.2521	3.2343	3.2464	47582864.0
2007-04-20 10:30:00	AAPL	Stock	3.2461	3.25	3.2368	3.2382	29688764.0
2007-04-20 11:00:00	AAPL	Stock	3.2382	3.2411	3.2343	3.2393	25911312.0
2007-04-20 11:30:00	AAPL	Stock	3.2393	3.2429	3.235	3.2368	24113152.0
2007-04-20 12:00:00	AAPL	Stock	3.2368	3.2411	3.235	3.2393	14230636.0
2007-04-20 12:30:00	AAPL	Stock	3.2393	3.2396	3.2339	3.2386	18603788.0
2007-04-20 13:00:00	AAPL	Stock	3.2389	3.2479	3.2375	3.2454	29910972.0
2007-04-20 13:30:00	AAPL	Stock	3.245	3.2475	3.2407	3.2413	18049808.0
2007-04-20 14:00:00	AAPL	Stock	3.2411	3.2429	3.2382	3.2393	18846380.0
2007-04-20 14:30:00	AAPL	Stock	3.2393	3.2439	3.2375	3.2429	31163580.0
2007-04-20 15:00:00	AAPL	Stock	3.2425	3.2429	3.2378	3.2393	20338192.0
2007-04-20 15:30:00	AAPL	Stock	3.2393	3.2564	3.2371	3.2486	89147800.0
2007-04-20 16:00:00	AAPL	Stock	3.2486	3.2529	3.2454	3.2496	4831568.0
2007-04-20 16:30:00	AAPL	Stock	3.2496	3.25	3.2489	3.2489	2827272.0
2007-04-20 17:00:00	AAPL	Stock	3.2489	3.2532	3.2482	3.2493	139468.0
2007-04-20 17:30:00	AAPL	Stock	3.2493	3.25	3.2493	3.2496	257600.0
2007-04-20 18:00:00	AAPL	Stock	3.2496	3.25	3.2489	3.2496	102200.0
2007-04-20 18:30:00	AAPL	Stock	3.2496	3.25	3.2482	3.2482	134568.0
2007-04-20 19:00:00	AAPL	Stock	3.2482	3.25	3.2471	3.2482	57988.0
2007-04-20 19:30:00	AAPL	Stock	3.2496	3.2532	3.2482	3.25	135156.0
2007-04-20 07:30:00	MSFT	Stock	28.81	28.81	28.81	28.81	500.0
2007-04-20 08:00:00	MSFT	Stock	28.84	28.84	28.7	28.8	8160.0
2007-04-20 08:30:00	MSFT	Stock	28.8	28.84	28.8	28.83	8000.0
2007-04-20 09:00:00	MSFT	Stock	28.83	29.0	28.83	29.0	600389.0
2007-04-20 09:30:00	MSFT	Stock	28.98	29.0	28.7	28.98	16766345.0
2007-04-20 10:00:00	MSFT	Stock	28.97	29.09	28.95	29.08	6382482.0
2007-04-20 10:30:00	MSFT	Stock	29.09	29.1	28.96	28.97	3844639.0
2007-04-20 11:00:00	MSFT	Stock	28.97	28.98	28.94	28.97	2411921.0
2007-04-20 11:30:00	MSFT	Stock	28.98	28.99	28.89	28.89	2358552.0
2007-04-20 12:00:00	MSFT	Stock	28.892	28.95	28.85	28.86	2263406.0
2007-04-20 12:30:00	MSFT	Stock	28.85	28.89	28.79	28.841	3697455.0
2007-04-20 13:00:00	MSFT	Stock	28.84	28.89	28.8	28.889	2119186.0
2007-04-20 13:30:00	MSFT	Stock	28.88	28.9	28.83	28.83	1646025.0
2007-04-20 14:00:00	MSFT	Stock	28.83	28.9	28.82	28.88	1570959.0
2007-04-20 14:30:00	MSFT	Stock	28.87	28.99	28.87	28.97	2564270.0
2007-04-20 15:00:00	MSFT	Stock	28.97	29.0	28.9	28.93	4165967.0
2007-04-20 15:30:00	MSFT	Stock	28.93	29.03	28.91	29.02	5925405.0
2007-04-20 16:00:00	MSFT	Stock	29.02	29.06	29.0	29.02	714765.0
2007-04-20 16:30:00	MSFT	Stock	29.03	29.05	29.02	29.02	33904.0
2007-04-20 17:00:00	MSFT	Stock	29.03	29.04	29.03	29.03	1550.0
2007-04-20 17:30:00	MSFT	Stock	29.03	29.05	29.03	29.05	1150.0
2007-04-20 18:00:00	MSFT	Stock	29.05	29.05	29.03	29.03	3066.0
2007-04-20 18:30:00	MSFT	Stock	29.03	29.03	29.03	29.03	501.0

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

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