PREVIEW / etf_30min / 2009-07-28

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-28.parquet
  size:    226 KB
  rows:    7,519

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-07-28 04:00:00	SPY	ETF	98.45	98.45	98.33	98.38	6300.0
2009-07-28 04:30:00	SPY	ETF	98.33	98.34	98.2	98.24	21400.0
2009-07-28 05:00:00	SPY	ETF	98.3	98.3	98.17	98.17	5600.0
2009-07-28 05:30:00	SPY	ETF	98.06	98.17	98.06	98.17	15100.0
2009-07-28 06:00:00	SPY	ETF	98.16	98.22	98.16	98.21	5900.0
2009-07-28 06:30:00	SPY	ETF	98.25	98.25	97.96	97.98	17500.0
2009-07-28 07:00:00	SPY	ETF	98.03	98.05	97.9	98.0	153915.0
2009-07-28 07:30:00	SPY	ETF	98.01	98.01	97.69	97.7	543493.0
2009-07-28 08:00:00	SPY	ETF	97.71	97.84	97.7	97.78	1068543.0
2009-07-28 08:30:00	SPY	ETF	97.78	97.91	97.69	97.9	1349612.0
2009-07-28 09:00:00	SPY	ETF	97.91	98.04	97.61	97.67	1842887.0
2009-07-28 09:30:00	SPY	ETF	97.66	98.37	97.6	98.26	22291496.0
2009-07-28 10:00:00	SPY	ETF	98.31	98.335	97.41	97.68	24284783.0
2009-07-28 10:30:00	SPY	ETF	97.68	97.85	97.57	97.8	8045157.0
2009-07-28 11:00:00	SPY	ETF	97.81	97.81	97.28	97.32	11874732.0
2009-07-28 11:30:00	SPY	ETF	97.32	98.3305	97.06	97.34	14360566.0
2009-07-28 12:00:00	SPY	ETF	97.34	97.47	97.18	97.32	8131514.0
2009-07-28 12:30:00	SPY	ETF	97.3283	97.48	97.27	97.39	4966398.0
2009-07-28 13:00:00	SPY	ETF	97.39	97.67	97.19	97.58	9802913.0
2009-07-28 13:30:00	SPY	ETF	97.58	97.86	97.48	97.77	10154519.0
2009-07-28 14:00:00	SPY	ETF	97.78	97.98	97.55	97.92	8147886.0
2009-07-28 14:30:00	SPY	ETF	97.91	98.25	97.73	97.82	16774588.0
2009-07-28 15:00:00	SPY	ETF	97.82	97.9	97.57	97.74	13524450.0
2009-07-28 15:30:00	SPY	ETF	97.73	98.15	97.66	98.06	20784427.0
2009-07-28 16:00:00	SPY	ETF	98.05	98.1384	97.5	97.99	5568331.0
2009-07-28 16:30:00	SPY	ETF	97.98	98.3305	97.6562	97.89	1512300.0
2009-07-28 17:00:00	SPY	ETF	97.87	97.92	97.8	97.92	166558.0
2009-07-28 17:30:00	SPY	ETF	97.9679	97.9679	97.87	97.87	14883.0
2009-07-28 18:00:00	SPY	ETF	97.85	97.87	97.78	97.78	70133.0
2009-07-28 18:30:00	SPY	ETF	97.79	97.82	97.78	97.82	37675.0
2009-07-28 19:00:00	SPY	ETF	97.81	97.81	97.67	97.68	108118.0
2009-07-28 19:30:00	SPY	ETF	97.68	97.75	97.63	97.63	35460.0
2009-07-28 04:00:00	QQQ	ETF	39.37	39.39	39.36	39.39	1700.0
2009-07-28 04:30:00	QQQ	ETF	39.33	39.33	39.33	39.33	100.0
2009-07-28 05:00:00	QQQ	ETF	39.32	39.32	39.28	39.28	5519.0
2009-07-28 05:30:00	QQQ	ETF	39.32	39.32	39.32	39.32	350.0
2009-07-28 06:30:00	QQQ	ETF	39.26	39.27	39.26	39.27	577.0
2009-07-28 07:00:00	QQQ	ETF	39.3	39.3	39.23	39.23	160933.0
2009-07-28 07:30:00	QQQ	ETF	39.26	39.26	39.15	39.16	131809.0
2009-07-28 08:00:00	QQQ	ETF	39.15	39.19	39.15	39.17	256953.0
2009-07-28 08:30:00	QQQ	ETF	39.17	39.24	39.13	39.23	521588.0
2009-07-28 09:00:00	QQQ	ETF	39.25	39.25	39.12	39.17	861324.0
2009-07-28 09:30:00	QQQ	ETF	39.17	39.42	39.1401	39.35	12630422.0
2009-07-28 10:00:00	QQQ	ETF	39.38	39.38	38.99	39.17	13023484.0
2009-07-28 10:30:00	QQQ	ETF	39.18	39.25	39.13	39.2	5044668.0
2009-07-28 11:00:00	QQQ	ETF	39.2	39.2001	39.04	39.06	5729618.0
2009-07-28 11:30:00	QQQ	ETF	39.05	39.08	38.93	39.0701	7201010.0
2009-07-28 12:00:00	QQQ	ETF	39.07	39.12	39.02	39.07	3339649.0
2009-07-28 12:30:00	QQQ	ETF	39.07	39.13	39.05	39.1	2351265.0
2009-07-28 13:00:00	QQQ	ETF	39.1002	39.3	39.04	39.26	4733203.0

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

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