PREVIEW / etf_30min / 2010-03-30

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-30.parquet
  size:    237 KB
  rows:    8,028

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-03-30 04:00:00	SPY	ETF	117.52	117.53	117.51	117.51	700.0
2010-03-30 04:30:00	SPY	ETF	117.41	117.41	117.41	117.41	100.0
2010-03-30 05:30:00	SPY	ETF	117.36	117.36	117.35	117.35	2222.0
2010-03-30 06:00:00	SPY	ETF	117.35	117.35	117.35	117.35	100.0
2010-03-30 06:30:00	SPY	ETF	117.49	117.49	117.47	117.49	10000.0
2010-03-30 07:00:00	SPY	ETF	117.52	117.62	117.5	117.6	38005.0
2010-03-30 07:30:00	SPY	ETF	117.61	117.61	117.51	117.56	102620.0
2010-03-30 08:00:00	SPY	ETF	117.54	117.63	117.5	117.51	404875.0
2010-03-30 08:30:00	SPY	ETF	117.52	117.52	117.36	117.4	1113826.0
2010-03-30 09:00:00	SPY	ETF	117.39	117.51	117.32	117.47	980784.0
2010-03-30 09:30:00	SPY	ETF	117.46	117.8	117.36	117.75	20104248.0
2010-03-30 10:00:00	SPY	ETF	117.75	117.83	117.38	117.49	17944173.0
2010-03-30 10:30:00	SPY	ETF	117.49	117.61	117.44	117.48	9903849.0
2010-03-30 11:00:00	SPY	ETF	117.47	117.5	116.91	117.06	19078712.0
2010-03-30 11:30:00	SPY	ETF	117.06	117.27	116.96	117.22	6392514.0
2010-03-30 12:00:00	SPY	ETF	117.22	117.41	117.16	117.36	9360371.0
2010-03-30 12:30:00	SPY	ETF	117.36	117.41	117.2	117.3565	7341010.0
2010-03-30 13:00:00	SPY	ETF	117.35	117.352	117.09	117.17	5303631.0
2010-03-30 13:30:00	SPY	ETF	117.18	117.29	117.07	117.2291	6852386.0
2010-03-30 14:00:00	SPY	ETF	117.2285	117.32	117.1	117.29	3961863.0
2010-03-30 14:30:00	SPY	ETF	117.29	117.55	117.24	117.44	7583975.0
2010-03-30 15:00:00	SPY	ETF	117.44	117.49	117.33	117.44	5061855.0
2010-03-30 15:30:00	SPY	ETF	117.45	117.57	117.32	117.37	14270847.0
2010-03-30 16:00:00	SPY	ETF	117.38	117.7	116.99	117.4	5417783.0
2010-03-30 16:30:00	SPY	ETF	117.39	117.39	117.27	117.34	706651.0
2010-03-30 17:00:00	SPY	ETF	117.32	117.42	117.32	117.35	79269.0
2010-03-30 17:30:00	SPY	ETF	117.35	117.36	117.34	117.36	124456.0
2010-03-30 18:00:00	SPY	ETF	117.34	117.34	117.3	117.3	11224.0
2010-03-30 18:30:00	SPY	ETF	117.32	117.34	117.32	117.33	6700.0
2010-03-30 19:00:00	SPY	ETF	117.35	117.39	117.33	117.38	32420.0
2010-03-30 19:30:00	SPY	ETF	117.38	117.42	117.38	117.42	40470.0
2010-03-30 04:00:00	QQQ	ETF	48.36	48.36	48.36	48.36	1000.0
2010-03-30 07:00:00	QQQ	ETF	48.39	48.41	48.37	48.4	6480.0
2010-03-30 07:30:00	QQQ	ETF	48.4	48.41	48.38	48.38	24325.0
2010-03-30 08:00:00	QQQ	ETF	48.38	48.43	48.37	48.39	62070.0
2010-03-30 08:30:00	QQQ	ETF	48.38	48.38	48.31	48.33	139341.0
2010-03-30 09:00:00	QQQ	ETF	48.33	48.38	48.31	48.36	332183.0
2010-03-30 09:30:00	QQQ	ETF	48.36	48.5369	48.35	48.5	8474138.0
2010-03-30 10:00:00	QQQ	ETF	48.51	48.55	48.26	48.32	7646865.0
2010-03-30 10:30:00	QQQ	ETF	48.33	48.3899	48.28	48.3301	3454729.0
2010-03-30 11:00:00	QQQ	ETF	48.32	48.33	48.06	48.14	5172027.0
2010-03-30 11:30:00	QQQ	ETF	48.1499	48.28	48.13	48.25	2734911.0
2010-03-30 12:00:00	QQQ	ETF	48.25	48.34	48.24	48.3282	2037629.0
2010-03-30 12:30:00	QQQ	ETF	48.33	48.35	48.29	48.32	1460350.0
2010-03-30 13:00:00	QQQ	ETF	48.32	48.33	48.2298	48.27	2672525.0
2010-03-30 13:30:00	QQQ	ETF	48.269	48.31	48.21	48.2899	1414811.0
2010-03-30 14:00:00	QQQ	ETF	48.28	48.33	48.26	48.31	1031657.0
2010-03-30 14:30:00	QQQ	ETF	48.31	48.41	48.31	48.38	1785826.0
2010-03-30 15:00:00	QQQ	ETF	48.3701	48.41	48.36	48.39	1802024.0
2010-03-30 15:30:00	QQQ	ETF	48.3999	48.46	48.37	48.38	6238410.0

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

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