PREVIEW / etf_30min / 2009-03-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-03.parquet
  size:    214 KB
  rows:    7,195

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-03 04:00:00	SPY	ETF	71.87	71.93	71.8	71.8	2900.0
2009-03-03 04:30:00	SPY	ETF	71.62	71.62	71.28	71.28	1600.0
2009-03-03 05:00:00	SPY	ETF	71.31	71.33	71.2	71.27	3912.0
2009-03-03 05:30:00	SPY	ETF	71.14	71.36	71.14	71.35	16000.0
2009-03-03 06:00:00	SPY	ETF	71.4	71.4	71.2	71.2	8800.0
2009-03-03 06:30:00	SPY	ETF	71.19	71.19	70.89	71.05	41062.0
2009-03-03 07:00:00	SPY	ETF	71.1	71.63	71.1	71.43	1206982.0
2009-03-03 07:30:00	SPY	ETF	71.46	71.58	71.27	71.27	712934.0
2009-03-03 08:00:00	SPY	ETF	72.05	72.05	71.2	71.74	2644866.0
2009-03-03 08:30:00	SPY	ETF	71.75	71.93	71.59	71.74	2312955.0
2009-03-03 09:00:00	SPY	ETF	71.74	71.88	71.5	71.61	3158963.0
2009-03-03 09:30:00	SPY	ETF	71.61	71.7	71.0	71.2	33515771.0
2009-03-03 10:00:00	SPY	ETF	71.2	71.42	70.68	71.07	39594680.0
2009-03-03 10:30:00	SPY	ETF	71.07	71.32	70.55	70.66	27163297.0
2009-03-03 11:00:00	SPY	ETF	70.66	70.81	69.76	70.17	39853588.0
2009-03-03 11:30:00	SPY	ETF	70.17	70.21	69.64	69.76	25211472.0
2009-03-03 12:00:00	SPY	ETF	69.76	70.8	69.74	70.69	25222716.0
2009-03-03 12:30:00	SPY	ETF	70.69	70.69	70.12	70.19	26292477.0
2009-03-03 13:00:00	SPY	ETF	70.18	70.51	69.92	70.06	18920560.0
2009-03-03 13:30:00	SPY	ETF	70.06	70.55	69.76	70.39	28128518.0
2009-03-03 14:00:00	SPY	ETF	70.39	71.03	70.34	70.84	32178869.0
2009-03-03 14:30:00	SPY	ETF	70.83	71.45	70.34	71.26	42858096.0
2009-03-03 15:00:00	SPY	ETF	71.26	71.5	70.13	70.23	35516977.0
2009-03-03 15:30:00	SPY	ETF	70.22	70.494	69.86	70.04	45033394.0
2009-03-03 16:00:00	SPY	ETF	70.05	71.299	69.39	69.5	10643026.0
2009-03-03 16:30:00	SPY	ETF	69.54	70.07	68.76	69.08	2056028.0
2009-03-03 17:00:00	SPY	ETF	69.06	69.17	68.9	69.13	246152.0
2009-03-03 17:30:00	SPY	ETF	69.14	69.19	68.96	69.08	144480.0
2009-03-03 18:00:00	SPY	ETF	69.1	69.35	69.1	69.33	120136.0
2009-03-03 18:30:00	SPY	ETF	69.34	69.5	69.3	69.5	127294.0
2009-03-03 19:00:00	SPY	ETF	69.5	69.58	69.46	69.51	76861.0
2009-03-03 19:30:00	SPY	ETF	69.48	69.55	69.25	69.38	47377.0
2009-03-03 04:30:00	QQQ	ETF	26.95	26.95	26.95	26.95	100.0
2009-03-03 05:00:00	QQQ	ETF	26.82	26.82	26.82	26.82	100.0
2009-03-03 06:00:00	QQQ	ETF	26.82	26.82	26.81	26.81	10000.0
2009-03-03 06:30:00	QQQ	ETF	26.75	26.77	26.75	26.77	450.0
2009-03-03 07:00:00	QQQ	ETF	26.87	26.95	26.8	26.92	99114.0
2009-03-03 07:30:00	QQQ	ETF	26.9	26.91	26.84	26.87	263499.0
2009-03-03 08:00:00	QQQ	ETF	27.05	27.05	26.84	26.98	406548.0
2009-03-03 08:30:00	QQQ	ETF	26.98	27.03	26.93	27.0	2027643.0
2009-03-03 09:00:00	QQQ	ETF	27.0	27.0	26.85	26.85	1303577.0
2009-03-03 09:30:00	QQQ	ETF	26.85	26.95	26.75	26.81	12082077.0
2009-03-03 10:00:00	QQQ	ETF	26.8	26.9	26.67	26.8	13603778.0
2009-03-03 10:30:00	QQQ	ETF	26.79	26.87	26.64	26.7	9240851.0
2009-03-03 11:00:00	QQQ	ETF	26.69	26.74	26.43	26.59	11709699.0
2009-03-03 11:30:00	QQQ	ETF	26.59	26.6004	26.42	26.48	7881205.0
2009-03-03 12:00:00	QQQ	ETF	26.49	26.84	26.47	26.8	7728543.0
2009-03-03 12:30:00	QQQ	ETF	26.8005	26.81	26.6	26.629	5741579.0
2009-03-03 13:00:00	QQQ	ETF	26.62	26.78	26.56	26.62	7173223.0
2009-03-03 13:30:00	QQQ	ETF	26.6201	26.82	26.54	26.78	10006574.0

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

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