PREVIEW / etf_30min / 2009-03-24

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-24.parquet
  size:    214 KB
  rows:    7,055

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
2009-03-24 04:00:00	SPY	ETF	81.58	81.58	81.58	81.58	900.0
2009-03-24 04:30:00	SPY	ETF	81.61	81.61	81.61	81.61	100.0
2009-03-24 05:00:00	SPY	ETF	81.46	81.48	81.28	81.32	14024.0
2009-03-24 05:30:00	SPY	ETF	81.33	81.43	81.2	81.21	48300.0
2009-03-24 06:00:00	SPY	ETF	81.24	81.42	81.15	81.37	181450.0
2009-03-24 06:30:00	SPY	ETF	81.33	81.39	81.11	81.39	32200.0
2009-03-24 07:00:00	SPY	ETF	81.48	81.56	81.4	81.47	297064.0
2009-03-24 07:30:00	SPY	ETF	81.49	81.54	81.37	81.38	334810.0
2009-03-24 08:00:00	SPY	ETF	81.4	81.67	81.11	81.32	1554917.0
2009-03-24 08:30:00	SPY	ETF	81.3	81.85	81.24	81.33	766405.0
2009-03-24 09:00:00	SPY	ETF	81.32	81.32	81.11	81.24	1118579.0
2009-03-24 09:30:00	SPY	ETF	81.24	81.47	80.9	81.44	36213482.0
2009-03-24 10:00:00	SPY	ETF	81.45	81.85	81.12	81.1799	34383217.0
2009-03-24 10:30:00	SPY	ETF	81.1706	81.34	80.87	81.14	24163741.0
2009-03-24 11:00:00	SPY	ETF	81.14	81.71	81.02	81.6	18259814.0
2009-03-24 11:30:00	SPY	ETF	81.6	82.2547	81.33	81.37	21094237.0
2009-03-24 12:00:00	SPY	ETF	81.37	81.64	81.16	81.6099	15168803.0
2009-03-24 12:30:00	SPY	ETF	81.6	82.08	81.49	81.98	17434190.0
2009-03-24 13:00:00	SPY	ETF	81.98	82.36	81.82	82.26	23867472.0
2009-03-24 13:30:00	SPY	ETF	82.27	82.27	81.66	81.83	19701683.0
2009-03-24 14:00:00	SPY	ETF	81.8275	82.26	81.71	81.84	19111693.0
2009-03-24 14:30:00	SPY	ETF	81.83	81.98	81.45	81.63	22686851.0
2009-03-24 15:00:00	SPY	ETF	81.62	81.75	81.11	81.34	20570173.0
2009-03-24 15:30:00	SPY	ETF	81.34	82.2547	80.51	80.61	40337050.0
2009-03-24 16:00:00	SPY	ETF	80.59	81.18	80.54	80.71	4900524.0
2009-03-24 16:30:00	SPY	ETF	80.72	80.75	80.55	80.61	997957.0
2009-03-24 17:00:00	SPY	ETF	80.58	80.67	80.52	80.634	790042.0
2009-03-24 17:30:00	SPY	ETF	80.58	82.2547	80.51	80.57	3172020.0
2009-03-24 18:00:00	SPY	ETF	80.57	80.66	80.5	80.66	95000.0
2009-03-24 18:30:00	SPY	ETF	80.63	80.85	80.6	80.75	486453.0
2009-03-24 19:00:00	SPY	ETF	80.74	80.81	80.73	80.74	34232.0
2009-03-24 19:30:00	SPY	ETF	80.78	80.9	80.75	80.9	15687.0
2009-03-24 04:00:00	QQQ	ETF	30.62	30.62	30.62	30.62	3750.0
2009-03-24 05:00:00	QQQ	ETF	30.6	30.61	30.57	30.58	9608.0
2009-03-24 05:30:00	QQQ	ETF	30.57	30.61	30.52	30.52	1032.0
2009-03-24 06:00:00	QQQ	ETF	30.53	30.53	30.51	30.51	1850.0
2009-03-24 06:30:00	QQQ	ETF	30.61	30.61	30.6	30.6	2200.0
2009-03-24 07:00:00	QQQ	ETF	30.63	30.64	30.59	30.6	108491.0
2009-03-24 07:30:00	QQQ	ETF	30.61	30.63	30.6	30.62	58600.0
2009-03-24 08:00:00	QQQ	ETF	30.63	30.64	30.58	30.61	891080.0
2009-03-24 08:30:00	QQQ	ETF	30.61	30.67	30.59	30.63	172890.0
2009-03-24 09:00:00	QQQ	ETF	30.62	30.66	30.57	30.65	382132.0
2009-03-24 09:30:00	QQQ	ETF	30.65	30.7385	30.5	30.6499	13625611.0
2009-03-24 10:00:00	QQQ	ETF	30.65	30.79	30.45	30.46	14833486.0
2009-03-24 10:30:00	QQQ	ETF	30.47	30.47	30.34	30.431	9367675.0
2009-03-24 11:00:00	QQQ	ETF	30.44	30.65	30.4	30.61	6408695.0
2009-03-24 11:30:00	QQQ	ETF	30.5974	30.63	30.47	30.47	6568590.0
2009-03-24 12:00:00	QQQ	ETF	30.48	30.59	30.41	30.58	4098059.0
2009-03-24 12:30:00	QQQ	ETF	30.58	30.79	30.57	30.76	7465245.0
2009-03-24 13:00:00	QQQ	ETF	30.77	30.88	30.69	30.85	6681113.0

> showing 50 of 7,055 rows — these rows as CSV

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