PREVIEW / etf_30min / 2009-04-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-15.parquet
  size:    212 KB
  rows:    7,033

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-04-15 04:00:00	SPY	ETF	84.41	84.41	84.41	84.41	160.0
2009-04-15 04:30:00	SPY	ETF	84.5	84.73	84.48	84.73	28030.0
2009-04-15 05:00:00	SPY	ETF	84.75	84.75	84.61	84.61	400.0
2009-04-15 05:30:00	SPY	ETF	84.56	84.57	84.41	84.41	900.0
2009-04-15 06:00:00	SPY	ETF	84.41	84.52	84.36	84.51	28300.0
2009-04-15 06:30:00	SPY	ETF	84.5	84.59	84.39	84.59	16720.0
2009-04-15 07:00:00	SPY	ETF	84.58	84.76	84.46	84.54	434420.0
2009-04-15 07:30:00	SPY	ETF	84.52	84.54	84.19	84.2	540480.0
2009-04-15 08:00:00	SPY	ETF	84.21	84.38	83.95	84.26	1834608.0
2009-04-15 08:30:00	SPY	ETF	84.14	84.38	83.93	84.04	1994638.0
2009-04-15 09:00:00	SPY	ETF	84.04	84.65	83.73	83.83	2820855.0
2009-04-15 09:30:00	SPY	ETF	83.84	84.32	83.61	84.28	26244262.0
2009-04-15 10:00:00	SPY	ETF	84.28	84.62	84.21	84.415	19350571.0
2009-04-15 10:30:00	SPY	ETF	84.41	84.42	83.95	83.98	17768832.0
2009-04-15 11:00:00	SPY	ETF	83.98	84.18	83.8	84.06	12768865.0
2009-04-15 11:30:00	SPY	ETF	84.06	84.52	84.06	84.41	12181310.0
2009-04-15 12:00:00	SPY	ETF	84.41	84.61	84.34	84.4	10104265.0
2009-04-15 12:30:00	SPY	ETF	84.39	84.77	84.35	84.74	12364330.0
2009-04-15 13:00:00	SPY	ETF	84.75	84.885	84.42	84.52	12487741.0
2009-04-15 13:30:00	SPY	ETF	84.51	84.63	84.19	84.38	13976894.0
2009-04-15 14:00:00	SPY	ETF	84.38	84.66	83.97	84.01	20630746.0
2009-04-15 14:30:00	SPY	ETF	84.0	84.18	83.87	84.01	15411331.0
2009-04-15 15:00:00	SPY	ETF	84.01	84.63	83.99	84.52	21398844.0
2009-04-15 15:30:00	SPY	ETF	84.51	85.42	84.25	85.29	34557869.0
2009-04-15 16:00:00	SPY	ETF	85.28	85.48	83.73	85.3	5502700.0
2009-04-15 16:30:00	SPY	ETF	85.3	85.39	84.65	85.35	227761.0
2009-04-15 17:00:00	SPY	ETF	85.37	85.41	85.29	85.37	357372.0
2009-04-15 17:30:00	SPY	ETF	85.37	85.48	85.37	85.43	74320.0
2009-04-15 18:00:00	SPY	ETF	85.43	85.43	85.3	85.31	76847.0
2009-04-15 18:30:00	SPY	ETF	85.3	85.35	85.3	85.33	31392.0
2009-04-15 19:00:00	SPY	ETF	85.32	85.35	85.28	85.34	19783.0
2009-04-15 19:30:00	SPY	ETF	85.33	85.34	85.29	85.33	25636.0
2009-04-15 04:00:00	QQQ	ETF	32.42	32.42	32.42	32.42	100.0
2009-04-15 06:00:00	QQQ	ETF	32.35	32.42	32.35	32.42	7244.0
2009-04-15 06:30:00	QQQ	ETF	32.4	32.45	32.4	32.45	5400.0
2009-04-15 07:00:00	QQQ	ETF	32.42	32.48	32.39	32.41	14600.0
2009-04-15 07:30:00	QQQ	ETF	32.41	32.41	32.31	32.31	147949.0
2009-04-15 08:00:00	QQQ	ETF	32.31	32.32	32.25	32.3	870587.0
2009-04-15 08:30:00	QQQ	ETF	32.3	32.4	32.27	32.3	413924.0
2009-04-15 09:00:00	QQQ	ETF	32.31	32.35	32.23	32.23	973649.0
2009-04-15 09:30:00	QQQ	ETF	32.24	32.3	32.09	32.21	15286467.0
2009-04-15 10:00:00	QQQ	ETF	32.21	32.39	32.2	32.32	8540862.0
2009-04-15 10:30:00	QQQ	ETF	32.33	32.33	32.08	32.08	6929684.0
2009-04-15 11:00:00	QQQ	ETF	32.08	32.1	31.96	32.01	8171714.0
2009-04-15 11:30:00	QQQ	ETF	32.0024	32.15	32.0	32.11	4388013.0
2009-04-15 12:00:00	QQQ	ETF	32.1125	32.17	32.07	32.0797	4234527.0
2009-04-15 12:30:00	QQQ	ETF	32.0724	32.21	32.07	32.18	3527744.0
2009-04-15 13:00:00	QQQ	ETF	32.18	32.31	32.15	32.26	6687065.0
2009-04-15 13:30:00	QQQ	ETF	32.26	32.29	32.15	32.21	5884282.0
2009-04-15 14:00:00	QQQ	ETF	32.2	32.26	31.98	31.99	8157958.0

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

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