PREVIEW / etf_30min / 2009-03-04

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-04.parquet
  size:    210 KB
  rows:    7,052

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-04 04:00:00	SPY	ETF	70.68	70.78	70.68	70.78	6264.0
2009-03-04 04:30:00	SPY	ETF	70.73	71.03	70.73	71.03	13922.0
2009-03-04 05:00:00	SPY	ETF	70.85	70.94	70.78	70.78	3586.0
2009-03-04 05:30:00	SPY	ETF	70.69	70.82	70.69	70.82	500.0
2009-03-04 06:00:00	SPY	ETF	70.81	70.81	70.6	70.65	10197.0
2009-03-04 06:30:00	SPY	ETF	70.72	70.82	70.67	70.8	47712.0
2009-03-04 07:00:00	SPY	ETF	70.82	70.82	70.5	70.65	1469907.0
2009-03-04 07:30:00	SPY	ETF	70.66	70.78	70.41	70.44	919337.0
2009-03-04 08:00:00	SPY	ETF	70.45	70.74	70.27	70.43	4151893.0
2009-03-04 08:30:00	SPY	ETF	70.44	71.25	70.44	71.17	3275035.0
2009-03-04 09:00:00	SPY	ETF	71.17	71.32	71.045	71.25	4893220.0
2009-03-04 09:30:00	SPY	ETF	71.23	71.58	70.81	70.89	58643962.0
2009-03-04 10:00:00	SPY	ETF	70.895	71.3	70.41	70.8606	43335336.0
2009-03-04 10:30:00	SPY	ETF	70.86	71.44	70.65	71.2	33787388.0
2009-03-04 11:00:00	SPY	ETF	71.19	71.85	71.19	71.81	30509745.0
2009-03-04 11:30:00	SPY	ETF	71.79	71.95	71.47	71.81	21580121.0
2009-03-04 12:00:00	SPY	ETF	71.81	71.89	71.23	71.49	19398325.0
2009-03-04 12:30:00	SPY	ETF	71.44	71.69	71.03	71.22	18133251.0
2009-03-04 13:00:00	SPY	ETF	71.22	71.54	70.93	71.34	22119470.0
2009-03-04 13:30:00	SPY	ETF	71.33	71.64	70.0729	71.32	21094597.0
2009-03-04 14:00:00	SPY	ETF	71.32	72.02	71.21	71.7	29940784.0
2009-03-04 14:30:00	SPY	ETF	71.7	72.48	71.58	72.41	28437750.0
2009-03-04 15:00:00	SPY	ETF	72.41	72.85	70.7	72.84	33253560.0
2009-03-04 15:30:00	SPY	ETF	72.83	72.87	71.5	71.73	60442185.0
2009-03-04 16:00:00	SPY	ETF	71.74	72.439	70.95	71.49	20847855.0
2009-03-04 16:30:00	SPY	ETF	71.48	71.5	71.23	71.46	2341473.0
2009-03-04 17:00:00	SPY	ETF	71.46	71.53	70.0729	71.51	1771113.0
2009-03-04 17:30:00	SPY	ETF	71.52	71.58	69.67	71.54	269972.0
2009-03-04 18:00:00	SPY	ETF	71.54	71.57	71.36	71.42	512995.0
2009-03-04 18:30:00	SPY	ETF	71.43	71.49	71.38	71.38	202588.0
2009-03-04 19:00:00	SPY	ETF	71.38	71.68	71.3	71.61	51962.0
2009-03-04 19:30:00	SPY	ETF	71.62	71.68	71.36	71.44	45684.0
2009-03-04 04:00:00	QQQ	ETF	26.79	26.85	26.79	26.85	3144.0
2009-03-04 04:30:00	QQQ	ETF	26.87	26.87	26.87	26.87	300.0
2009-03-04 06:00:00	QQQ	ETF	26.83	26.83	26.79	26.79	2200.0
2009-03-04 06:30:00	QQQ	ETF	26.81	26.81	26.81	26.81	5000.0
2009-03-04 07:00:00	QQQ	ETF	26.79	26.84	26.76	26.8	372066.0
2009-03-04 07:30:00	QQQ	ETF	26.8	26.84	26.71	26.74	381711.0
2009-03-04 08:00:00	QQQ	ETF	26.74	26.83	26.7	26.78	4160956.0
2009-03-04 08:30:00	QQQ	ETF	26.8	27.04	26.78	27.01	1444743.0
2009-03-04 09:00:00	QQQ	ETF	26.99	27.06	26.89	27.01	1718122.0
2009-03-04 09:30:00	QQQ	ETF	27.01	27.23	26.92	27.06	18622717.0
2009-03-04 10:00:00	QQQ	ETF	27.06	27.21	26.99	27.14	12011299.0
2009-03-04 10:30:00	QQQ	ETF	27.15	27.35	27.09	27.289	11516504.0
2009-03-04 11:00:00	QQQ	ETF	27.281	27.47	27.281	27.46	9549104.0
2009-03-04 11:30:00	QQQ	ETF	27.46	27.52	27.09	27.47	9545466.0
2009-03-04 12:00:00	QQQ	ETF	27.47	27.51	27.25	27.34	8275563.0
2009-03-04 12:30:00	QQQ	ETF	27.35	27.43	27.24	27.29	7612862.0
2009-03-04 13:00:00	QQQ	ETF	27.29	27.41	27.17	27.3405	7117794.0
2009-03-04 13:30:00	QQQ	ETF	27.35	27.4722	27.31	27.3401	6569025.0

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

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