PREVIEW / stock_30min / 2007-03-22

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-03-22.parquet
  size:    1.0 MB
  rows:    56,303
  symbols: 2,552

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-22 06:00:00	AAPL	Stock	3.3489	3.3489	3.3489	3.3489	14000.0
2007-03-22 07:30:00	AAPL	Stock	3.3511	3.3514	3.3511	3.3514	16800.0
2007-03-22 08:00:00	AAPL	Stock	3.3493	3.3493	3.3368	3.3389	461664.0
2007-03-22 08:30:00	AAPL	Stock	3.3375	3.3457	3.3375	3.345	600796.0
2007-03-22 09:00:00	AAPL	Stock	3.3446	3.3482	3.3396	3.3482	1179192.0
2007-03-22 09:30:00	AAPL	Stock	3.3475	3.355	3.3214	3.3371	75207328.0
2007-03-22 10:00:00	AAPL	Stock	3.3364	3.3529	3.3329	3.3507	65962456.0
2007-03-22 10:30:00	AAPL	Stock	3.3504	3.3521	3.3404	3.3407	53877096.0
2007-03-22 11:00:00	AAPL	Stock	3.3407	3.3521	3.3404	3.3471	29143492.0
2007-03-22 11:30:00	AAPL	Stock	3.3471	3.3604	3.3464	3.3539	40062260.0
2007-03-22 12:00:00	AAPL	Stock	3.3543	3.3604	3.3479	3.3542	27232716.0
2007-03-22 12:30:00	AAPL	Stock	3.3543	3.37	3.3504	3.3611	37724316.0
2007-03-22 13:00:00	AAPL	Stock	3.3611	3.3614	3.3479	3.3536	29496768.0
2007-03-22 13:30:00	AAPL	Stock	3.3536	3.3536	3.3379	3.3446	41875764.0
2007-03-22 14:00:00	AAPL	Stock	3.345	3.3582	3.345	3.3475	34105624.0
2007-03-22 14:30:00	AAPL	Stock	3.3472	3.3532	3.3407	3.3482	28892948.0
2007-03-22 15:00:00	AAPL	Stock	3.3482	3.3511	3.3407	3.3504	27930924.0
2007-03-22 15:30:00	AAPL	Stock	3.3511	3.3571	3.3468	3.3521	40836600.0
2007-03-22 16:00:00	AAPL	Stock	3.3557	3.3557	3.3518	3.3536	5100228.0
2007-03-22 16:30:00	AAPL	Stock	3.3536	3.3536	3.3489	3.35	586908.0
2007-03-22 17:00:00	AAPL	Stock	3.35	3.35	3.3482	3.3482	70896.0
2007-03-22 17:30:00	AAPL	Stock	3.3482	3.35	3.3475	3.3475	132440.0
2007-03-22 18:00:00	AAPL	Stock	3.3475	3.3475	3.3436	3.3464	66024.0
2007-03-22 18:30:00	AAPL	Stock	3.3557	3.3557	3.3464	3.3464	3502716.0
2007-03-22 19:00:00	AAPL	Stock	3.3496	3.35	3.3496	3.3496	81060.0
2007-03-22 19:30:00	AAPL	Stock	3.345	3.345	3.345	3.345	5516.0
2007-03-22 07:00:00	MSFT	Stock	28.46	28.49	28.46	28.49	8140.0
2007-03-22 07:30:00	MSFT	Stock	28.83	28.94	28.51	28.51	3855.0
2007-03-22 08:00:00	MSFT	Stock	28.49	28.52	28.44	28.44	13093.0
2007-03-22 08:30:00	MSFT	Stock	28.45	28.5	28.45	28.49	15807.0
2007-03-22 09:00:00	MSFT	Stock	28.49	28.53	28.44	28.51	55139.0
2007-03-22 09:30:00	MSFT	Stock	28.52	28.55	28.11	28.14	5949697.0
2007-03-22 10:00:00	MSFT	Stock	28.14	28.33	28.07	28.21	4745702.0
2007-03-22 10:30:00	MSFT	Stock	28.2	28.21	28.01	28.06	4714874.0
2007-03-22 11:00:00	MSFT	Stock	28.059	28.28	28.04	28.2	3139352.0
2007-03-22 11:30:00	MSFT	Stock	28.202	28.26	28.13	28.24	2593172.0
2007-03-22 12:00:00	MSFT	Stock	28.24	28.28	28.14	28.28	2186795.0
2007-03-22 12:30:00	MSFT	Stock	28.28	28.36	28.13	28.25	2038683.0
2007-03-22 13:00:00	MSFT	Stock	28.25	28.3	28.16	28.3	2137872.0
2007-03-22 13:30:00	MSFT	Stock	28.29	28.29	28.19	28.28	1694368.0
2007-03-22 14:00:00	MSFT	Stock	28.29	28.38	28.28	28.31	2472523.0
2007-03-22 14:30:00	MSFT	Stock	28.3	28.38	28.24	28.31	2598584.0
2007-03-22 15:00:00	MSFT	Stock	28.32	28.33	28.17	28.23	3589267.0
2007-03-22 15:30:00	MSFT	Stock	28.23	28.32	28.19	28.27	7312329.0
2007-03-22 16:00:00	MSFT	Stock	28.26	28.29	28.22	28.27	1023254.0
2007-03-22 16:30:00	MSFT	Stock	28.32	28.32	28.27	28.27	3400.0
2007-03-22 17:00:00	MSFT	Stock	28.27	28.27	28.27	28.27	175600.0
2007-03-22 18:00:00	MSFT	Stock	28.26	28.26	28.25	28.25	1850.0
2007-03-22 18:30:00	MSFT	Stock	28.27	28.27	28.25	28.25	1564585.0
2007-03-22 19:00:00	MSFT	Stock	28.25	28.27	28.25	28.27	200.0

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

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