PREVIEW / etf_30min / 2010-01-29

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-01-29.parquet
  size:    258 KB
  rows:    8,422

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
2010-01-29 04:00:00	SPY	ETF	108.52	108.52	108.44	108.44	900.0
2010-01-29 04:30:00	SPY	ETF	108.46	108.46	108.33	108.33	1058.0
2010-01-29 05:00:00	SPY	ETF	108.37	108.4	108.19	108.25	7800.0
2010-01-29 05:30:00	SPY	ETF	108.33	108.67	108.33	108.63	101800.0
2010-01-29 06:00:00	SPY	ETF	108.55	108.8	108.55	108.8	3600.0
2010-01-29 06:30:00	SPY	ETF	108.78	108.85	108.7	108.7	52100.0
2010-01-29 07:00:00	SPY	ETF	108.65	108.75	108.59	108.59	272186.0
2010-01-29 07:30:00	SPY	ETF	108.61	108.85	108.59	108.8	335348.0
2010-01-29 08:00:00	SPY	ETF	108.77	109.01	108.73	108.97	1307483.0
2010-01-29 08:30:00	SPY	ETF	108.97	109.34	108.85	109.13	6095572.0
2010-01-29 09:00:00	SPY	ETF	109.13	109.26	109.03	109.05	1892406.0
2010-01-29 09:30:00	SPY	ETF	109.04	109.5	108.74	109.32	37070577.0
2010-01-29 10:00:00	SPY	ETF	109.32	109.77	109.02	109.67	22651078.0
2010-01-29 10:30:00	SPY	ETF	109.67	109.8	109.08	109.29	17898675.0
2010-01-29 11:00:00	SPY	ETF	109.28	109.35	108.655	108.77	23723332.0
2010-01-29 11:30:00	SPY	ETF	108.77	108.86	108.41	108.42	18878556.0
2010-01-29 12:00:00	SPY	ETF	108.41	108.7	108.24	108.6216	17642592.0
2010-01-29 12:30:00	SPY	ETF	108.63	108.87	108.44	108.832	10759326.0
2010-01-29 13:00:00	SPY	ETF	108.84	108.92	108.65	108.76	8189144.0
2010-01-29 13:30:00	SPY	ETF	108.75	108.8	108.19	108.36	15431417.0
2010-01-29 14:00:00	SPY	ETF	108.37	108.57	108.2	108.31	12867354.0
2010-01-29 14:30:00	SPY	ETF	108.32	108.34	107.64	107.93	25525235.0
2010-01-29 15:00:00	SPY	ETF	107.92	108.0	107.4	107.55	26824316.0
2010-01-29 15:30:00	SPY	ETF	107.55	108.566	107.22	107.42	45328836.0
2010-01-29 16:00:00	SPY	ETF	107.42	109.62	107.15	107.33	13851707.0
2010-01-29 16:30:00	SPY	ETF	107.32	107.4	107.26	107.34	2103565.0
2010-01-29 17:00:00	SPY	ETF	107.36	107.38	107.26	107.31	130162.0
2010-01-29 17:30:00	SPY	ETF	107.31	107.35	107.21	107.27	163368.0
2010-01-29 18:00:00	SPY	ETF	107.27	107.35	107.24	107.27	118870.0
2010-01-29 18:30:00	SPY	ETF	107.33	107.36	107.27	107.31	15993.0
2010-01-29 19:00:00	SPY	ETF	107.38	107.38	107.29	107.34	8300.0
2010-01-29 19:30:00	SPY	ETF	107.35	107.36	107.31	107.35	11200.0
2010-01-29 04:00:00	QQQ	ETF	43.65	43.65	43.62	43.62	200.0
2010-01-29 04:30:00	QQQ	ETF	43.63	43.63	43.63	43.63	500.0
2010-01-29 05:00:00	QQQ	ETF	43.61	43.61	43.57	43.57	600.0
2010-01-29 05:30:00	QQQ	ETF	43.57	43.57	43.53	43.53	2000.0
2010-01-29 06:00:00	QQQ	ETF	43.63	43.67	43.63	43.67	600.0
2010-01-29 06:30:00	QQQ	ETF	43.7	43.7	43.69	43.7	1400.0
2010-01-29 07:00:00	QQQ	ETF	43.65	43.73	43.64	43.7	19802.0
2010-01-29 07:30:00	QQQ	ETF	43.67	43.78	43.67	43.78	30295.0
2010-01-29 08:00:00	QQQ	ETF	43.67	43.85	43.67	43.83	673968.0
2010-01-29 08:30:00	QQQ	ETF	43.84	44.04	43.8	44.04	2623431.0
2010-01-29 09:00:00	QQQ	ETF	44.03	44.04	43.87	43.89	1383081.0
2010-01-29 09:30:00	QQQ	ETF	43.9	44.02	43.8	43.899	24603056.0
2010-01-29 10:00:00	QQQ	ETF	43.9	44.0	43.62	43.96	15579341.0
2010-01-29 10:30:00	QQQ	ETF	43.96	44.0	43.595	43.67	14016206.0
2010-01-29 11:00:00	QQQ	ETF	43.67	43.7	43.28	43.34	20616703.0
2010-01-29 11:30:00	QQQ	ETF	43.341	43.45	43.24	43.26	14027237.0
2010-01-29 12:00:00	QQQ	ETF	43.26	43.36	43.15	43.35	14156776.0
2010-01-29 12:30:00	QQQ	ETF	43.3401	44.0	43.25	43.38	6063683.0

> showing 50 of 8,422 rows — these rows as CSV

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