PREVIEW / stock_30min / 2007-03-23

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-23.parquet
  size:    1008 KB
  rows:    54,491
  symbols: 2,550

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-03-23 07:30:00	AAPL	Stock	3.3536	3.3536	3.3536	3.3536	2800.0
2007-03-23 08:00:00	AAPL	Stock	3.3496	3.35	3.3161	3.3179	3069836.0
2007-03-23 08:30:00	AAPL	Stock	3.3179	3.3286	3.3125	3.3268	2012080.0
2007-03-23 09:00:00	AAPL	Stock	3.3268	3.3346	3.3268	3.3339	1493100.0
2007-03-23 09:30:00	AAPL	Stock	3.3339	3.3482	3.3321	3.3432	52652908.0
2007-03-23 10:00:00	AAPL	Stock	3.3436	3.3596	3.3436	3.3457	63305396.0
2007-03-23 10:30:00	AAPL	Stock	3.3457	3.3536	3.3346	3.3368	54224268.0
2007-03-23 11:00:00	AAPL	Stock	3.3364	3.3493	3.3361	3.3461	37301152.0
2007-03-23 11:30:00	AAPL	Stock	3.3461	3.3557	3.3457	3.3511	37313500.0
2007-03-23 12:00:00	AAPL	Stock	3.3514	3.3532	3.3468	3.3468	21131852.0
2007-03-23 12:30:00	AAPL	Stock	3.3471	3.3496	3.3446	3.3471	17465000.0
2007-03-23 13:00:00	AAPL	Stock	3.3475	3.3489	3.3382	3.345	25993520.0
2007-03-23 13:30:00	AAPL	Stock	3.3454	3.3479	3.3411	3.3468	15124844.0
2007-03-23 14:00:00	AAPL	Stock	3.3468	3.3479	3.3414	3.345	19470108.0
2007-03-23 14:30:00	AAPL	Stock	3.3446	3.3479	3.3414	3.3439	17904516.0
2007-03-23 15:00:00	AAPL	Stock	3.3443	3.3518	3.3429	3.3471	30455040.0
2007-03-23 15:30:00	AAPL	Stock	3.3471	3.3507	3.34	3.34	41071660.0
2007-03-23 16:00:00	AAPL	Stock	3.3411	3.3418	3.3386	3.34	2888172.0
2007-03-23 16:30:00	AAPL	Stock	3.34	3.34	3.3386	3.3386	3045560.0
2007-03-23 17:00:00	AAPL	Stock	3.3393	3.3393	3.3386	3.3386	66500.0
2007-03-23 17:30:00	AAPL	Stock	3.3393	3.3396	3.3386	3.3396	224056.0
2007-03-23 18:00:00	AAPL	Stock	3.3396	3.3404	3.3396	3.3404	35000.0
2007-03-23 18:30:00	AAPL	Stock	3.3393	3.3414	3.339	3.3414	137872.0
2007-03-23 19:00:00	AAPL	Stock	3.3418	3.3418	3.3393	3.3418	77000.0
2007-03-23 19:30:00	AAPL	Stock	3.3414	3.3414	3.3414	3.3414	3724.0
2007-03-23 07:30:00	MSFT	Stock	28.26	28.26	28.26	28.26	500.0
2007-03-23 08:00:00	MSFT	Stock	28.27	28.28	28.16	28.22	7519.0
2007-03-23 08:30:00	MSFT	Stock	28.23	28.25	28.22	28.25	2350.0
2007-03-23 09:00:00	MSFT	Stock	28.2	28.25	28.15	28.2	41380.0
2007-03-23 09:30:00	MSFT	Stock	28.22	28.27	27.8	27.928	6409047.0
2007-03-23 10:00:00	MSFT	Stock	27.93	28.16	27.93	28.06	8099419.0
2007-03-23 10:30:00	MSFT	Stock	28.06	28.12	28.04	28.1	2005733.0
2007-03-23 11:00:00	MSFT	Stock	28.091	28.13	28.05	28.11	1780447.0
2007-03-23 11:30:00	MSFT	Stock	28.1	28.18	28.1	28.12	2071194.0
2007-03-23 12:00:00	MSFT	Stock	28.13	28.2	28.05	28.091	3254858.0
2007-03-23 12:30:00	MSFT	Stock	28.09	28.1	27.95	28.06	3208596.0
2007-03-23 13:00:00	MSFT	Stock	28.05	28.09	28.01	28.05	1335185.0
2007-03-23 13:30:00	MSFT	Stock	28.05	28.1	28.03	28.06	1162274.0
2007-03-23 14:00:00	MSFT	Stock	28.06	28.1	27.95	28.03	3032562.0
2007-03-23 14:30:00	MSFT	Stock	28.04	28.08	28.02	28.07	1429688.0
2007-03-23 15:00:00	MSFT	Stock	28.07	28.1	27.97	28.02	4643055.0
2007-03-23 15:30:00	MSFT	Stock	28.01	28.15	27.99	27.99	9177329.0
2007-03-23 16:00:00	MSFT	Stock	28.01	28.03	27.97	27.97	1246294.0
2007-03-23 16:30:00	MSFT	Stock	28.02	28.02	27.97	27.97	340424.0
2007-03-23 17:00:00	MSFT	Stock	27.98	27.98	27.97	27.98	2050.0
2007-03-23 17:30:00	MSFT	Stock	27.98	27.98	27.98	27.98	300.0
2007-03-23 18:00:00	MSFT	Stock	27.98	27.98	27.98	27.98	2000.0
2007-03-23 18:30:00	MSFT	Stock	27.98	28.001	27.98	28.0	6223.0
2007-03-23 19:00:00	MSFT	Stock	28.0	28.0	27.98	27.98	244.0
2007-03-23 07:00:00	NVDA	Stock	0.5108	0.5108	0.5108	0.5108	12000.0

> showing 50 of 54,491 rows — these rows as CSV

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