PREVIEW / etf_30min / 2009-03-06

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-06.parquet
  size:    212 KB
  rows:    7,151

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-06 04:00:00	SPY	ETF	69.41	69.41	69.41	69.41	300.0
2009-03-06 05:00:00	SPY	ETF	69.28	69.28	68.91	68.91	300.0
2009-03-06 05:30:00	SPY	ETF	68.89	68.89	68.89	68.89	100.0
2009-03-06 06:00:00	SPY	ETF	68.86	68.9	68.38	68.59	120450.0
2009-03-06 06:30:00	SPY	ETF	68.63	68.86	68.58	68.85	254072.0
2009-03-06 07:00:00	SPY	ETF	68.9	69.03	68.63	68.63	1321350.0
2009-03-06 07:30:00	SPY	ETF	68.63	68.79	68.6	68.77	1362334.0
2009-03-06 08:00:00	SPY	ETF	68.85	69.23	68.65	69.11	7697752.0
2009-03-06 08:30:00	SPY	ETF	69.12	69.95	68.95	69.69	13164198.0
2009-03-06 09:00:00	SPY	ETF	69.67	69.82	68.69	69.41	3400268.0
2009-03-06 09:30:00	SPY	ETF	69.4	70.45	69.09	69.54	66631025.0
2009-03-06 10:00:00	SPY	ETF	69.55	69.73	68.73	69.08	50179798.0
2009-03-06 10:30:00	SPY	ETF	69.08	69.2	67.97	68.09	43389123.0
2009-03-06 11:00:00	SPY	ETF	68.09	68.45	67.91	68.22	25747939.0
2009-03-06 11:30:00	SPY	ETF	68.22	68.63	68.04	68.32	22657609.0
2009-03-06 12:00:00	SPY	ETF	68.3206	68.79	68.26	68.31	19483911.0
2009-03-06 12:30:00	SPY	ETF	68.32	68.38	67.7	68.07	19773961.0
2009-03-06 13:00:00	SPY	ETF	68.07	68.09	67.59	67.74	17642028.0
2009-03-06 13:30:00	SPY	ETF	67.74	67.8	67.4	67.7	21546716.0
2009-03-06 14:00:00	SPY	ETF	67.6938	68.04	67.47	67.89	24160634.0
2009-03-06 14:30:00	SPY	ETF	67.89	68.17	67.19	67.27	26690671.0
2009-03-06 15:00:00	SPY	ETF	67.27	67.6	67.1	67.21	28374986.0
2009-03-06 15:30:00	SPY	ETF	67.22	69.8	67.215	68.84	67613583.0
2009-03-06 16:00:00	SPY	ETF	68.83	70.19	67.5	69.33	8936198.0
2009-03-06 16:30:00	SPY	ETF	69.34	69.6	68.84	69.45	9435993.0
2009-03-06 17:00:00	SPY	ETF	69.47	69.49	69.27	69.34	126144.0
2009-03-06 17:30:00	SPY	ETF	69.4	69.47	69.34	69.43	29522.0
2009-03-06 18:00:00	SPY	ETF	69.43	69.45	69.37	69.4	30801.0
2009-03-06 18:30:00	SPY	ETF	69.43	69.45	69.35	69.38	20206.0
2009-03-06 19:00:00	SPY	ETF	69.4	69.46	69.39	69.4	23829.0
2009-03-06 19:30:00	SPY	ETF	69.39	69.44	69.36	69.43	15567.0
2009-03-06 04:30:00	QQQ	ETF	26.73	26.73	26.73	26.73	100.0
2009-03-06 05:00:00	QQQ	ETF	26.51	26.51	26.51	26.51	100.0
2009-03-06 06:00:00	QQQ	ETF	26.51	26.51	26.41	26.43	300.0
2009-03-06 06:30:00	QQQ	ETF	26.49	26.65	26.49	26.65	75800.0
2009-03-06 07:00:00	QQQ	ETF	26.65	26.71	26.49	26.51	246603.0
2009-03-06 07:30:00	QQQ	ETF	26.51	26.53	26.44	26.51	737975.0
2009-03-06 08:00:00	QQQ	ETF	26.52	26.65	26.46	26.55	3660359.0
2009-03-06 08:30:00	QQQ	ETF	26.55	26.84	26.53	26.74	4539533.0
2009-03-06 09:00:00	QQQ	ETF	26.75	26.78	26.6	26.63	947720.0
2009-03-06 09:30:00	QQQ	ETF	26.64	26.81	26.47	26.49	20106763.0
2009-03-06 10:00:00	QQQ	ETF	26.49	26.6	26.12	26.23	26040592.0
2009-03-06 10:30:00	QQQ	ETF	26.22	26.27	25.79	25.84	21733923.0
2009-03-06 11:00:00	QQQ	ETF	25.86	25.93	25.73	25.84	14914557.0
2009-03-06 11:30:00	QQQ	ETF	25.84	26.02	25.83	25.95	9999105.0
2009-03-06 12:00:00	QQQ	ETF	25.95	26.13	25.93	25.99	9831221.0
2009-03-06 12:30:00	QQQ	ETF	25.99	26.05	25.84	26.0199	10611071.0
2009-03-06 13:00:00	QQQ	ETF	26.02	26.02	25.845	25.91	6642887.0
2009-03-06 13:30:00	QQQ	ETF	25.9099	25.95	25.76	25.93	11449227.0
2009-03-06 14:00:00	QQQ	ETF	25.93	26.08	25.86	25.981	15569746.0

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

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