PREVIEW / stock_30min / 2007-06-22

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-06-22.parquet
  size:    1.2 MB
  rows:    68,148
  symbols: 3,031

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-06-22 09:30:00	AAPL	Stock	4.4232	4.4446	4.3996	4.4275	98011760.0
2007-06-22 10:00:00	AAPL	Stock	4.4275	4.4446	4.4121	4.4246	64857576.0
2007-06-22 10:30:00	AAPL	Stock	4.4246	4.4382	4.4125	4.4229	46850440.0
2007-06-22 11:00:00	AAPL	Stock	4.4239	4.425	4.4046	4.4175	38879092.0
2007-06-22 11:30:00	AAPL	Stock	4.4175	4.425	4.3943	4.4068	37891616.0
2007-06-22 12:00:00	AAPL	Stock	4.4065	4.4107	4.3911	4.3988	36034684.0
2007-06-22 12:30:00	AAPL	Stock	4.3986	4.4064	4.3793	4.3982	46481792.0
2007-06-22 13:00:00	AAPL	Stock	4.3979	4.4007	4.3707	4.3918	50009232.0
2007-06-22 13:30:00	AAPL	Stock	4.3923	4.3957	4.3825	4.3911	24673936.0
2007-06-22 14:00:00	AAPL	Stock	4.3911	4.4	4.3839	4.3989	22845788.0
2007-06-22 14:30:00	AAPL	Stock	4.3982	4.4057	4.3889	4.3932	31879960.0
2007-06-22 15:00:00	AAPL	Stock	4.3936	4.4086	4.3879	4.3911	32509372.0
2007-06-22 15:30:00	AAPL	Stock	4.3911	4.3975	4.3829	4.3925	56415212.0
2007-06-22 16:00:00	AAPL	Stock	4.3925	4.3929	4.3923	4.3929	13969872.0
2007-06-22 09:30:00	MSFT	Stock	30.0	30.1	29.86	29.92	4881535.0
2007-06-22 10:00:00	MSFT	Stock	29.91	29.92	29.76	29.81	4569525.0
2007-06-22 10:30:00	MSFT	Stock	29.82	29.94	29.77	29.9	3217286.0
2007-06-22 11:00:00	MSFT	Stock	29.903	29.92	29.82	29.838	2952909.0
2007-06-22 11:30:00	MSFT	Stock	29.83	29.86	29.68	29.75	4341178.0
2007-06-22 12:00:00	MSFT	Stock	29.74	29.75	29.49	29.5	5523770.0
2007-06-22 12:30:00	MSFT	Stock	29.49	29.63	29.46	29.58	4649016.0
2007-06-22 13:00:00	MSFT	Stock	29.57	29.71	29.48	29.67	4513153.0
2007-06-22 13:30:00	MSFT	Stock	29.68	29.7	29.5	29.52	4027888.0
2007-06-22 14:00:00	MSFT	Stock	29.52	29.56	29.5	29.529	4006468.0
2007-06-22 14:30:00	MSFT	Stock	29.52	29.64	29.52	29.58	3590990.0
2007-06-22 15:00:00	MSFT	Stock	29.58	29.6	29.48	29.49	3864308.0
2007-06-22 15:30:00	MSFT	Stock	29.48	29.57	29.45	29.5	11081223.0
2007-06-22 16:00:00	MSFT	Stock	29.5	29.52	29.49	29.49	8410521.0
2007-06-22 08:00:00	NVDA	Stock	0.7163	0.7208	0.7138	0.7138	357720.0
2007-06-22 08:30:00	NVDA	Stock	0.7138	0.7148	0.7128	0.7128	316920.0
2007-06-22 09:00:00	NVDA	Stock	0.716	0.719	0.7155	0.7155	386160.0
2007-06-22 09:30:00	NVDA	Stock	0.7163	0.7205	0.7115	0.7135	92912880.0
2007-06-22 10:00:00	NVDA	Stock	0.7133	0.7135	0.7058	0.7113	73398780.0
2007-06-22 10:30:00	NVDA	Stock	0.7113	0.7197	0.7108	0.7158	80331600.0
2007-06-22 11:00:00	NVDA	Stock	0.7158	0.72	0.7143	0.7183	50503920.0
2007-06-22 11:30:00	NVDA	Stock	0.7183	0.7243	0.7172	0.7233	61710300.0
2007-06-22 12:00:00	NVDA	Stock	0.7233	0.7247	0.72	0.7207	72316740.0
2007-06-22 12:30:00	NVDA	Stock	0.7205	0.7215	0.7183	0.7187	61821480.0
2007-06-22 13:00:00	NVDA	Stock	0.7187	0.7248	0.718	0.7233	56676000.0
2007-06-22 13:30:00	NVDA	Stock	0.7237	0.725	0.72	0.7218	45287580.0
2007-06-22 14:00:00	NVDA	Stock	0.7218	0.7267	0.7208	0.7262	47544180.0
2007-06-22 14:30:00	NVDA	Stock	0.7262	0.7312	0.7258	0.7298	58788480.0
2007-06-22 15:00:00	NVDA	Stock	0.73	0.7303	0.7252	0.7253	50083800.0
2007-06-22 15:30:00	NVDA	Stock	0.7253	0.7275	0.7223	0.7262	85796040.0
2007-06-22 16:00:00	NVDA	Stock	0.726	0.73	0.7253	0.7255	28903500.0
2007-06-22 16:30:00	NVDA	Stock	0.7267	0.7274	0.726	0.726	3117780.0
2007-06-22 17:00:00	NVDA	Stock	0.7267	0.7267	0.7258	0.7258	963300.0
2007-06-22 17:30:00	NVDA	Stock	0.727	0.7292	0.727	0.7292	183120.0
2007-06-22 18:00:00	NVDA	Stock	0.7292	0.7292	0.7292	0.7292	44700.0
2007-06-22 19:30:00	NVDA	Stock	0.727	0.729	0.726	0.729	39660.0

> showing 50 of 68,148 rows — these rows as CSV

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