PREVIEW / etf_30min / 2008-11-04

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-04.parquet
  size:    183 KB
  rows:    6,470

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-11-04 04:00:00	SPY	ETF	97.7	98.03	97.7	98.03	7000.0
2008-11-04 04:30:00	SPY	ETF	98.12	98.65	98.07	98.65	6400.0
2008-11-04 05:00:00	SPY	ETF	98.72	98.99	98.72	98.99	3100.0
2008-11-04 05:30:00	SPY	ETF	98.89	99.14	98.84	99.14	6400.0
2008-11-04 06:00:00	SPY	ETF	99.14	99.38	99.07	99.16	118003.0
2008-11-04 06:30:00	SPY	ETF	99.2	99.23	98.91	98.93	177403.0
2008-11-04 07:00:00	SPY	ETF	98.93	99.66	98.93	99.53	704993.0
2008-11-04 07:30:00	SPY	ETF	99.51	99.73	99.34	99.49	781927.0
2008-11-04 08:00:00	SPY	ETF	99.49	99.67	97.35	99.21	2388290.0
2008-11-04 08:30:00	SPY	ETF	99.2	99.4	98.98	99.11	1053869.0
2008-11-04 09:00:00	SPY	ETF	99.11	99.31	98.81	99.03	2443957.0
2008-11-04 09:30:00	SPY	ETF	99.06	99.09	98.25	98.35	31930529.0
2008-11-04 10:00:00	SPY	ETF	98.36	99.49	98.19	99.43	26049082.0
2008-11-04 10:30:00	SPY	ETF	99.45	100.29	99.34	100.02	27831203.0
2008-11-04 11:00:00	SPY	ETF	100.02	100.62	96.7142	100.24	24433228.0
2008-11-04 11:30:00	SPY	ETF	100.24	100.72	100.02	100.518	16332003.0
2008-11-04 12:00:00	SPY	ETF	100.518	100.59	100.05	100.07	15291682.0
2008-11-04 12:30:00	SPY	ETF	100.07	100.16	99.81	99.97	12079913.0
2008-11-04 13:00:00	SPY	ETF	99.97	100.34	99.75	100.3	18311948.0
2008-11-04 13:30:00	SPY	ETF	100.3	100.63	100.02	100.24	14838900.0
2008-11-04 14:00:00	SPY	ETF	100.24	100.25	99.42	99.83	26083532.0
2008-11-04 14:30:00	SPY	ETF	99.83	99.97	98.97	99.22	22111991.0
2008-11-04 15:00:00	SPY	ETF	99.22	100.64	98.7	99.46	27958061.0
2008-11-04 15:30:00	SPY	ETF	99.45	100.86	99.45	100.4	60023970.0
2008-11-04 16:00:00	SPY	ETF	100.37	100.621	99.69	100.46	8196540.0
2008-11-04 16:30:00	SPY	ETF	100.42	100.45	100.05	100.3	2295532.0
2008-11-04 17:00:00	SPY	ETF	100.32	100.42	100.27	100.34	76638.0
2008-11-04 17:30:00	SPY	ETF	100.34	100.41	100.34	100.36	74778.0
2008-11-04 18:00:00	SPY	ETF	100.36	100.41	100.32	100.38	102339.0
2008-11-04 18:30:00	SPY	ETF	100.39	100.65	100.39	100.59	22550.0
2008-11-04 19:00:00	SPY	ETF	100.55	100.55	100.35	100.38	10398.0
2008-11-04 19:30:00	SPY	ETF	100.35	100.49	100.3	100.48	53595.0
2008-11-04 04:00:00	QQQ	ETF	33.2	33.2	33.2	33.2	100.0
2008-11-04 04:30:00	QQQ	ETF	33.43	33.54	33.43	33.54	5400.0
2008-11-04 05:00:00	QQQ	ETF	33.6	33.65	33.58	33.65	5700.0
2008-11-04 05:30:00	QQQ	ETF	33.66	33.66	33.66	33.66	1000.0
2008-11-04 06:00:00	QQQ	ETF	33.75	33.85	33.68	33.74	53000.0
2008-11-04 06:30:00	QQQ	ETF	33.75	33.8	33.7	33.7	39001.0
2008-11-04 07:00:00	QQQ	ETF	33.66	33.8	33.65	33.79	135075.0
2008-11-04 07:30:00	QQQ	ETF	33.78	33.81	33.7	33.7	167783.0
2008-11-04 08:00:00	QQQ	ETF	33.8	33.8	33.55	33.59	567801.0
2008-11-04 08:30:00	QQQ	ETF	33.59	33.64	33.53	33.57	470205.0
2008-11-04 09:00:00	QQQ	ETF	33.57	33.6	33.44	33.48	1437232.0
2008-11-04 09:30:00	QQQ	ETF	33.49	33.53	32.98	33.07	21575205.0
2008-11-04 10:00:00	QQQ	ETF	33.08	33.41	32.98	33.385	14507251.0
2008-11-04 10:30:00	QQQ	ETF	33.39	33.72	33.25	33.61	14369675.0
2008-11-04 11:00:00	QQQ	ETF	33.61	33.81	33.25	33.678	8334751.0
2008-11-04 11:30:00	QQQ	ETF	33.665	34.01	33.6	33.93	9317491.0
2008-11-04 12:00:00	QQQ	ETF	33.93	33.96	33.7	33.732	11278215.0
2008-11-04 12:30:00	QQQ	ETF	33.74	33.8	33.67	33.77	5950240.0

> showing 50 of 6,470 rows — these rows as CSV

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