PREVIEW / etf_30min / 2009-09-18

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-18.parquet
  size:    225 KB
  rows:    7,596

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-09-18 04:00:00	SPY	ETF	106.36	106.4	106.26	106.38	5900.0
2009-09-18 05:00:00	SPY	ETF	106.53	106.53	106.39	106.39	700.0
2009-09-18 05:30:00	SPY	ETF	106.72	106.78	106.69	106.72	10200.0
2009-09-18 06:00:00	SPY	ETF	106.76	106.83	106.68	106.77	20700.0
2009-09-18 06:30:00	SPY	ETF	106.76	106.86	106.76	106.86	10200.0
2009-09-18 07:00:00	SPY	ETF	106.92	106.92	106.83	106.86	147617.0
2009-09-18 07:30:00	SPY	ETF	106.86	106.88	106.8	106.83	66081.0
2009-09-18 08:00:00	SPY	ETF	106.83	106.95	106.73	106.93	691156.0
2009-09-18 08:30:00	SPY	ETF	106.95	107.04	106.9	107.04	978586.0
2009-09-18 09:00:00	SPY	ETF	107.04	107.19	107.02	107.15	1696872.0
2009-09-18 09:30:00	SPY	ETF	107.15	107.16	106.66	106.738	22318442.0
2009-09-18 10:00:00	SPY	ETF	106.74	106.77	106.46	106.6	17721255.0
2009-09-18 10:30:00	SPY	ETF	106.59	106.9	106.54	106.76	13841461.0
2009-09-18 11:00:00	SPY	ETF	106.76	106.82	106.6	106.6	9858249.0
2009-09-18 11:30:00	SPY	ETF	106.6	106.72	106.5	106.5	10051927.0
2009-09-18 12:00:00	SPY	ETF	106.49	106.65	106.36	106.56	11488606.0
2009-09-18 12:30:00	SPY	ETF	106.56	106.89	106.54	106.87	6344790.0
2009-09-18 13:00:00	SPY	ETF	106.87	106.95	106.59	106.91	5333055.0
2009-09-18 13:30:00	SPY	ETF	106.9117	107.1	106.84	106.999	6266464.0
2009-09-18 14:00:00	SPY	ETF	107.0	107.1	106.97	106.98	5928939.0
2009-09-18 14:30:00	SPY	ETF	106.98	107.04	106.84	106.88	4980486.0
2009-09-18 15:00:00	SPY	ETF	106.88	107.15	106.87	107.08	6690327.0
2009-09-18 15:30:00	SPY	ETF	107.0722	107.1	106.71	106.73	17846102.0
2009-09-18 16:00:00	SPY	ETF	106.73	107.0	106.46	106.65	8170285.0
2009-09-18 16:30:00	SPY	ETF	106.65	106.7796	106.58	106.6	2715636.0
2009-09-18 17:00:00	SPY	ETF	106.6	106.61	106.53	106.58	117640.0
2009-09-18 17:30:00	SPY	ETF	106.58	106.62	106.46	106.53	68223.0
2009-09-18 18:00:00	SPY	ETF	106.53	106.54	106.49	106.53	14802.0
2009-09-18 18:30:00	SPY	ETF	106.53	106.53	106.48	106.5	3825.0
2009-09-18 19:00:00	SPY	ETF	106.52	106.56	106.49	106.55	4000.0
2009-09-18 19:30:00	SPY	ETF	106.58	106.6	106.55	106.55	3884.0
2009-09-18 04:00:00	QQQ	ETF	42.2	42.2	42.2	42.2	200.0
2009-09-18 06:00:00	QQQ	ETF	42.35	42.39	42.35	42.38	700.0
2009-09-18 06:30:00	QQQ	ETF	42.42	42.42	42.42	42.42	2000.0
2009-09-18 07:00:00	QQQ	ETF	42.42	42.42	42.4	42.4	15000.0
2009-09-18 07:30:00	QQQ	ETF	42.4	42.41	42.4	42.41	9013.0
2009-09-18 08:00:00	QQQ	ETF	42.41	42.45	42.38	42.45	128945.0
2009-09-18 08:30:00	QQQ	ETF	42.45	42.49	42.44	42.49	371686.0
2009-09-18 09:00:00	QQQ	ETF	42.5	42.58	42.49	42.56	449292.0
2009-09-18 09:30:00	QQQ	ETF	42.56	42.59	42.37	42.448	15173277.0
2009-09-18 10:00:00	QQQ	ETF	42.44	42.45	42.21	42.319	7982841.0
2009-09-18 10:30:00	QQQ	ETF	42.32	42.47	42.302	42.44	5860038.0
2009-09-18 11:00:00	QQQ	ETF	42.45	42.49	42.4	42.44	5907427.0
2009-09-18 11:30:00	QQQ	ETF	42.431	42.47	42.36	42.36	7083597.0
2009-09-18 12:00:00	QQQ	ETF	42.3699	42.41	42.31	42.37	6394682.0
2009-09-18 12:30:00	QQQ	ETF	42.36	42.51	42.35	42.501	2772830.0
2009-09-18 13:00:00	QQQ	ETF	42.51	42.54	42.47	42.54	3080892.0
2009-09-18 13:30:00	QQQ	ETF	42.5301	42.62	42.51	42.58	3080634.0
2009-09-18 14:00:00	QQQ	ETF	42.58	42.61	42.53	42.53	3204803.0
2009-09-18 14:30:00	QQQ	ETF	42.5312	42.55	42.46	42.47	3390011.0

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

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