PREVIEW / etf_30min / 2010-08-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-18.parquet
  size:    249 KB
  rows:    8,281

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-08-18 04:00:00	SPY	ETF	109.15	109.2	109.11	109.19	13850.0
2010-08-18 04:30:00	SPY	ETF	109.26	109.26	109.08	109.08	500.0
2010-08-18 05:00:00	SPY	ETF	109.41	109.49	109.41	109.49	450.0
2010-08-18 05:30:00	SPY	ETF	109.45	109.51	109.39	109.49	10150.0
2010-08-18 06:00:00	SPY	ETF	109.48	109.48	109.3	109.3	8600.0
2010-08-18 06:30:00	SPY	ETF	109.35	109.36	109.35	109.36	2600.0
2010-08-18 07:00:00	SPY	ETF	109.32	109.42	109.29	109.34	69372.0
2010-08-18 07:30:00	SPY	ETF	109.35	109.62	109.35	109.48	105175.0
2010-08-18 08:00:00	SPY	ETF	109.49	109.77	109.24	109.71	468591.0
2010-08-18 08:30:00	SPY	ETF	109.7	109.82	109.6	109.78	459980.0
2010-08-18 09:00:00	SPY	ETF	109.77	109.82	109.53	109.54	727903.0
2010-08-18 09:30:00	SPY	ETF	109.54	109.54	108.91	109.21	25350998.0
2010-08-18 10:00:00	SPY	ETF	109.22	109.51	109.0	109.04	15676397.0
2010-08-18 10:30:00	SPY	ETF	109.05	109.32	108.99	109.26	12000171.0
2010-08-18 11:00:00	SPY	ETF	109.27	109.62	109.19	109.42	14137156.0
2010-08-18 11:30:00	SPY	ETF	109.42	109.74	109.41	109.62	9459851.0
2010-08-18 12:00:00	SPY	ETF	109.62	109.7	109.5	109.65	6573062.0
2010-08-18 12:30:00	SPY	ETF	109.65	110.01	109.55	109.95	7674536.0
2010-08-18 13:00:00	SPY	ETF	109.95	110.31	109.94	110.2201	10407424.0
2010-08-18 13:30:00	SPY	ETF	110.2283	110.33	110.1	110.28	6063740.0
2010-08-18 14:00:00	SPY	ETF	110.28	110.38	110.07	110.18	9375305.0
2010-08-18 14:30:00	SPY	ETF	110.17	110.25	110.06	110.13	6514241.0
2010-08-18 15:00:00	SPY	ETF	110.13	110.21	109.79	109.88	12843120.0
2010-08-18 15:30:00	SPY	ETF	109.87	110.05	109.78	109.78	26574875.0
2010-08-18 16:00:00	SPY	ETF	109.78	110.0757	108.985	109.26	10572018.0
2010-08-18 16:30:00	SPY	ETF	109.27	109.47	109.25	109.37	806545.0
2010-08-18 17:00:00	SPY	ETF	109.37	109.38	109.25	109.33	258888.0
2010-08-18 17:30:00	SPY	ETF	109.35	109.35	109.28	109.32	48993.0
2010-08-18 18:00:00	SPY	ETF	109.31	109.31	109.19	109.22	197044.0
2010-08-18 18:30:00	SPY	ETF	109.22	109.28	109.22	109.28	106765.0
2010-08-18 19:00:00	SPY	ETF	109.29	109.31	109.23	109.23	39634.0
2010-08-18 19:30:00	SPY	ETF	109.22	109.26	109.11	109.19	59587.0
2010-08-18 04:00:00	QQQ	ETF	45.35	45.35	45.11	45.11	619.0
2010-08-18 04:30:00	QQQ	ETF	45.14	45.17	45.12	45.12	454.0
2010-08-18 05:00:00	QQQ	ETF	45.2	45.24	45.2	45.24	200.0
2010-08-18 05:30:00	QQQ	ETF	45.24	45.24	45.24	45.24	100.0
2010-08-18 06:00:00	QQQ	ETF	45.19	45.2	45.18	45.18	806.0
2010-08-18 06:30:00	QQQ	ETF	45.21	45.21	45.21	45.21	250.0
2010-08-18 07:00:00	QQQ	ETF	45.19	45.19	45.16	45.17	28274.0
2010-08-18 07:30:00	QQQ	ETF	45.2	45.3	45.2	45.25	45166.0
2010-08-18 08:00:00	QQQ	ETF	45.25	45.37	45.24	45.35	334237.0
2010-08-18 08:30:00	QQQ	ETF	45.34	45.39	45.3	45.37	174814.0
2010-08-18 09:00:00	QQQ	ETF	45.37	45.39	45.29	45.29	448556.0
2010-08-18 09:30:00	QQQ	ETF	45.29	45.33	45.11	45.325	7953816.0
2010-08-18 10:00:00	QQQ	ETF	45.325	45.49	45.24	45.2601	7563684.0
2010-08-18 10:30:00	QQQ	ETF	45.27	45.42	45.26	45.355	3412149.0
2010-08-18 11:00:00	QQQ	ETF	45.36	45.51	45.33	45.41	4144196.0
2010-08-18 11:30:00	QQQ	ETF	45.41	45.61	45.41	45.56	2513367.0
2010-08-18 12:00:00	QQQ	ETF	45.57	45.61	45.52	45.59	1640527.0
2010-08-18 12:30:00	QQQ	ETF	45.595	45.72	45.52	45.68	2370699.0

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

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