PREVIEW / etf_30min / 2008-10-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-10-10.parquet
  size:    194 KB
  rows:    7,053

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
2008-10-10 04:00:00	SPY	ETF	89.3	90.0	89.21	89.21	7100.0
2008-10-10 04:30:00	SPY	ETF	89.21	89.8	89.18	89.75	66900.0
2008-10-10 05:00:00	SPY	ETF	89.56	89.93	88.45	88.5	75700.0
2008-10-10 05:30:00	SPY	ETF	88.5	88.65	88.17	88.3	55500.0
2008-10-10 06:00:00	SPY	ETF	88.3	88.7	87.75	88.15	203005.0
2008-10-10 06:30:00	SPY	ETF	88.15	89.0	87.95	88.95	419680.0
2008-10-10 07:00:00	SPY	ETF	88.95	89.32	88.53	88.92	1034596.0
2008-10-10 07:30:00	SPY	ETF	88.9	89.03	87.89	88.08	1728980.0
2008-10-10 08:00:00	SPY	ETF	88.08	90.854	87.99	89.07	4024543.0
2008-10-10 08:30:00	SPY	ETF	89.03	89.36	86.1	86.62	5956146.0
2008-10-10 09:00:00	SPY	ETF	86.63	87.4	86.04	86.81	6793517.0
2008-10-10 09:30:00	SPY	ETF	86.76	89.78	83.58	88.48	126378919.0
2008-10-10 10:00:00	SPY	ETF	88.48	92.06	88.18	89.69	83482379.0
2008-10-10 10:30:00	SPY	ETF	89.67	90.3	87.12	87.89	53739785.0
2008-10-10 11:00:00	SPY	ETF	87.9	88.71	86.38	86.54	42361886.0
2008-10-10 11:30:00	SPY	ETF	86.51	91.34	85.01	85.77	51607595.0
2008-10-10 12:00:00	SPY	ETF	85.78	91.0173	85.63	86.97	43720655.0
2008-10-10 12:30:00	SPY	ETF	86.97	91.0173	86.22	87.28	33013593.0
2008-10-10 13:00:00	SPY	ETF	87.28	91.38	85.82	86.69	27589429.0
2008-10-10 13:30:00	SPY	ETF	86.69	86.77	84.05	85.19	41985081.0
2008-10-10 14:00:00	SPY	ETF	85.19	87.26	84.48	84.97	58422359.0
2008-10-10 14:30:00	SPY	ETF	84.96	86.21	84.34	85.2	35257967.0
2008-10-10 15:00:00	SPY	ETF	85.19	91.073	84.96	90.7098	79938321.0
2008-10-10 15:30:00	SPY	ETF	90.69	93.94	89.15	90.46	114289367.0
2008-10-10 16:00:00	SPY	ETF	90.45	91.66	84.02	88.95	30719577.0
2008-10-10 16:30:00	SPY	ETF	88.98	91.0173	88.76	89.2	16408445.0
2008-10-10 17:00:00	SPY	ETF	89.2	91.0178	88.5	89.2	9154626.0
2008-10-10 17:30:00	SPY	ETF	89.2	89.49	85.33	89.48	1111940.0
2008-10-10 18:00:00	SPY	ETF	89.48	89.91	89.48	89.75	365016.0
2008-10-10 18:30:00	SPY	ETF	89.74	90.55	89.56	90.48	121356.0
2008-10-10 19:00:00	SPY	ETF	90.4	90.4	89.2	89.24	106121.0
2008-10-10 19:30:00	SPY	ETF	89.3	89.65	89.27	89.6	96416.0
2008-10-10 04:00:00	QQQ	ETF	31.0	31.0	30.87	30.87	4200.0
2008-10-10 05:00:00	QQQ	ETF	30.45	30.45	30.45	30.45	100.0
2008-10-10 05:30:00	QQQ	ETF	30.41	30.41	30.27	30.34	4400.0
2008-10-10 06:00:00	QQQ	ETF	30.5	30.77	30.43	30.77	8800.0
2008-10-10 06:30:00	QQQ	ETF	30.62	30.92	30.51	30.92	38180.0
2008-10-10 07:00:00	QQQ	ETF	31.0	31.23	30.95	30.98	175719.0
2008-10-10 07:30:00	QQQ	ETF	30.99	31.03	30.53	30.56	488962.0
2008-10-10 08:00:00	QQQ	ETF	30.57	30.96	30.45	30.84	1636035.0
2008-10-10 08:30:00	QQQ	ETF	30.83	30.87	30.24	30.32	1603593.0
2008-10-10 09:00:00	QQQ	ETF	30.33	30.7	30.23	30.5	3248695.0
2008-10-10 09:30:00	QQQ	ETF	30.51	31.44	29.52	31.23	79665611.0
2008-10-10 10:00:00	QQQ	ETF	31.24	32.05	31.08	31.33	41578334.0
2008-10-10 10:30:00	QQQ	ETF	31.33	31.4	30.51	30.74	32480886.0
2008-10-10 11:00:00	QQQ	ETF	30.74	31.03	30.07	30.12	26495064.0
2008-10-10 11:30:00	QQQ	ETF	30.12	30.54	29.83	29.97	25322047.0
2008-10-10 12:00:00	QQQ	ETF	29.98	30.579	29.92	30.24	23347410.0
2008-10-10 12:30:00	QQQ	ETF	30.24	30.62	29.99	30.37	19396044.0
2008-10-10 13:00:00	QQQ	ETF	30.36	30.4	29.94	30.13	14663379.0

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

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