PREVIEW / etf_30min / 2009-03-19

all etf 30-min files

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

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-19 04:00:00	SPY	ETF	79.5	79.5	79.27	79.28	2600.0
2009-03-19 04:30:00	SPY	ETF	79.34	79.52	79.34	79.49	3400.0
2009-03-19 05:00:00	SPY	ETF	79.59	79.61	79.48	79.52	7800.0
2009-03-19 05:30:00	SPY	ETF	79.66	79.66	79.56	79.56	3100.0
2009-03-19 06:00:00	SPY	ETF	79.6	79.7	79.56	79.58	77000.0
2009-03-19 06:30:00	SPY	ETF	79.57	79.83	79.56	79.79	59250.0
2009-03-19 07:00:00	SPY	ETF	79.73	80.26	79.7	80.03	808012.0
2009-03-19 07:30:00	SPY	ETF	80.05	80.41	80.05	80.41	1338134.0
2009-03-19 08:00:00	SPY	ETF	80.4	80.41	80.0	80.38	1995145.0
2009-03-19 08:30:00	SPY	ETF	80.36	80.7	80.33	80.63	3478813.0
2009-03-19 09:00:00	SPY	ETF	80.64	81.04	78.0	80.94	3665626.0
2009-03-19 09:30:00	SPY	ETF	80.93	81.0	79.55	79.56	50966324.0
2009-03-19 10:00:00	SPY	ETF	79.56	80.09	79.35	79.74	46877435.0
2009-03-19 10:30:00	SPY	ETF	79.75	80.2825	79.65	79.7999	27205076.0
2009-03-19 11:00:00	SPY	ETF	79.8	80.2	79.2401	79.2401	26088709.0
2009-03-19 11:30:00	SPY	ETF	79.24	79.7125	78.72	79.22	30161836.0
2009-03-19 12:00:00	SPY	ETF	79.22	79.5	78.87	79.2299	17133685.0
2009-03-19 12:30:00	SPY	ETF	79.23	79.47	79.07	79.0901	26595307.0
2009-03-19 13:00:00	SPY	ETF	79.09	79.5	78.93	79.38	15194830.0
2009-03-19 13:30:00	SPY	ETF	79.37	79.69	79.06	79.5	21494703.0
2009-03-19 14:00:00	SPY	ETF	79.51	79.85	79.15	79.24	30588284.0
2009-03-19 14:30:00	SPY	ETF	79.2525	80.885	78.76	78.97	27723772.0
2009-03-19 15:00:00	SPY	ETF	78.98	80.765	78.9	79.09	21363464.0
2009-03-19 15:30:00	SPY	ETF	79.1	79.42	78.69	78.89	38928840.0
2009-03-19 16:00:00	SPY	ETF	78.88	79.79	78.84	78.9	18553891.0
2009-03-19 16:30:00	SPY	ETF	78.9	78.96	78.76	78.81	1078796.0
2009-03-19 17:00:00	SPY	ETF	78.79	79.4	78.58	78.7	662574.0
2009-03-19 17:30:00	SPY	ETF	78.65	79.77	78.58	78.62	64978.0
2009-03-19 18:00:00	SPY	ETF	78.62	79.2875	78.51	78.63	74504.0
2009-03-19 18:30:00	SPY	ETF	78.61	78.65	78.54	78.63	44704.0
2009-03-19 19:00:00	SPY	ETF	78.62	78.65	78.55	78.59	11530.0
2009-03-19 19:30:00	SPY	ETF	78.59	78.6	78.55	78.56	16385.0
2009-03-19 04:00:00	QQQ	ETF	29.67	29.67	29.6	29.6	775.0
2009-03-19 04:30:00	QQQ	ETF	29.64	29.64	29.64	29.64	100.0
2009-03-19 05:00:00	QQQ	ETF	29.67	29.7	29.67	29.7	200.0
2009-03-19 06:00:00	QQQ	ETF	29.7	29.73	29.7	29.73	200.0
2009-03-19 06:30:00	QQQ	ETF	29.7	29.7	29.7	29.7	200.0
2009-03-19 07:00:00	QQQ	ETF	29.79	29.99	29.79	29.9	132000.0
2009-03-19 07:30:00	QQQ	ETF	29.89	30.04	29.89	30.0	173336.0
2009-03-19 08:00:00	QQQ	ETF	29.99	30.0	29.88	29.95	435303.0
2009-03-19 08:30:00	QQQ	ETF	29.95	30.09	29.95	30.09	732417.0
2009-03-19 09:00:00	QQQ	ETF	30.1	30.15	30.04	30.12	1624871.0
2009-03-19 09:30:00	QQQ	ETF	30.13	30.13	29.71	29.71	19763154.0
2009-03-19 10:00:00	QQQ	ETF	29.71	29.94	29.66	29.8	16896601.0
2009-03-19 10:30:00	QQQ	ETF	29.81	29.99	29.73	29.79	9430637.0
2009-03-19 11:00:00	QQQ	ETF	29.79	29.88	29.57	29.58	11618231.0
2009-03-19 11:30:00	QQQ	ETF	29.58	29.7	29.46	29.6	10463208.0
2009-03-19 12:00:00	QQQ	ETF	29.6022	29.63	29.52	29.62	7776476.0
2009-03-19 12:30:00	QQQ	ETF	29.62	29.7	29.56	29.57	5908275.0
2009-03-19 13:00:00	QQQ	ETF	29.56	29.69	29.5	29.65	6567369.0

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

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