PREVIEW / etf_30min / 2009-10-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-16.parquet
  size:    234 KB
  rows:    7,664

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-10-16 04:00:00	SPY	ETF	109.72	109.79	109.72	109.79	2400.0
2009-10-16 04:30:00	SPY	ETF	109.63	109.63	109.63	109.63	100.0
2009-10-16 05:00:00	SPY	ETF	109.64	109.64	109.64	109.64	150.0
2009-10-16 06:00:00	SPY	ETF	109.67	109.67	109.67	109.67	100.0
2009-10-16 06:30:00	SPY	ETF	109.63	109.63	109.24	109.24	6063.0
2009-10-16 07:00:00	SPY	ETF	109.16	109.19	108.97	108.99	437693.0
2009-10-16 07:30:00	SPY	ETF	109.01	109.09	108.82	109.01	427988.0
2009-10-16 08:00:00	SPY	ETF	109.02	109.5	108.53	108.66	2027872.0
2009-10-16 08:30:00	SPY	ETF	108.66	108.76	108.63	108.74	1215111.0
2009-10-16 09:00:00	SPY	ETF	108.74	109.65	108.73	108.8	1574885.0
2009-10-16 09:30:00	SPY	ETF	108.8	109.06	108.57	108.64	30224964.0
2009-10-16 10:00:00	SPY	ETF	108.64	108.65	108.28	108.53	21708596.0
2009-10-16 10:30:00	SPY	ETF	108.53	108.56	108.23	108.35	10373556.0
2009-10-16 11:00:00	SPY	ETF	108.35	108.69	108.33	108.63	11865576.0
2009-10-16 11:30:00	SPY	ETF	108.62	108.64	108.34	108.54	7444635.0
2009-10-16 12:00:00	SPY	ETF	108.54	108.64	108.47	108.51	5952838.0
2009-10-16 12:30:00	SPY	ETF	108.51	108.66	108.43	108.61	5665086.0
2009-10-16 13:00:00	SPY	ETF	108.62	109.02	108.54	109.019	9163710.0
2009-10-16 13:30:00	SPY	ETF	109.01	109.17	108.8	108.949	12163498.0
2009-10-16 14:00:00	SPY	ETF	108.94	109.01	108.72	108.95	10421143.0
2009-10-16 14:30:00	SPY	ETF	108.95	109.0	108.84	108.89	5054837.0
2009-10-16 15:00:00	SPY	ETF	108.88	109.0925	108.87	109.03	10465532.0
2009-10-16 15:30:00	SPY	ETF	109.02	109.27	108.78	108.89	27637356.0
2009-10-16 16:00:00	SPY	ETF	108.89	108.91	108.43	108.63	15875547.0
2009-10-16 16:30:00	SPY	ETF	108.62	108.64	108.52	108.59	633369.0
2009-10-16 17:00:00	SPY	ETF	108.59	108.62	108.5	108.54	180633.0
2009-10-16 17:30:00	SPY	ETF	108.54	108.56	108.5	108.53	46351.0
2009-10-16 18:00:00	SPY	ETF	108.52	108.56	108.48	108.48	32667.0
2009-10-16 18:30:00	SPY	ETF	108.5	108.52	108.47	108.48	9931.0
2009-10-16 19:00:00	SPY	ETF	108.48	108.55	108.47	108.55	15136.0
2009-10-16 19:30:00	SPY	ETF	108.53	108.55	108.5	108.55	5378.0
2009-10-16 05:00:00	QQQ	ETF	43.14	43.14	43.14	43.14	5000.0
2009-10-16 06:00:00	QQQ	ETF	43.17	43.17	43.17	43.17	100.0
2009-10-16 06:30:00	QQQ	ETF	43.04	43.04	43.03	43.03	2000.0
2009-10-16 07:00:00	QQQ	ETF	42.97	42.98	42.94	42.94	69300.0
2009-10-16 07:30:00	QQQ	ETF	42.95	42.98	42.9	42.93	90000.0
2009-10-16 08:00:00	QQQ	ETF	42.96	42.97	42.79	42.84	540618.0
2009-10-16 08:30:00	QQQ	ETF	42.81	42.87	42.81	42.86	554490.0
2009-10-16 09:00:00	QQQ	ETF	42.86	42.97	42.86	42.91	749311.0
2009-10-16 09:30:00	QQQ	ETF	42.92	42.98	42.72	42.76	17336748.0
2009-10-16 10:00:00	QQQ	ETF	42.76	42.768	42.48	42.58	13977360.0
2009-10-16 10:30:00	QQQ	ETF	42.57	42.63	42.5	42.55	6559242.0
2009-10-16 11:00:00	QQQ	ETF	42.54	42.66	42.52	42.59	6608978.0
2009-10-16 11:30:00	QQQ	ETF	42.59	42.6	42.52	42.58	4333549.0
2009-10-16 12:00:00	QQQ	ETF	42.58	42.69	42.58	42.64	3983022.0
2009-10-16 12:30:00	QQQ	ETF	42.65	42.68	42.6	42.67	3219457.0
2009-10-16 13:00:00	QQQ	ETF	42.67	42.86	42.63	42.8501	5444220.0
2009-10-16 13:30:00	QQQ	ETF	42.8501	42.99	42.7498	42.88	6947178.0
2009-10-16 14:00:00	QQQ	ETF	42.87	42.9347	42.79	42.8799	6087081.0
2009-10-16 14:30:00	QQQ	ETF	42.87	42.89	42.8	42.81	2642034.0

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

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