PREVIEW / etf_30min / 2010-03-04

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-04.parquet
  size:    236 KB
  rows:    7,965

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-04 04:00:00	SPY	ETF	112.06	112.17	112.06	112.17	18100.0
2010-03-04 04:30:00	SPY	ETF	112.12	112.19	112.12	112.17	3032.0
2010-03-04 05:00:00	SPY	ETF	112.28	112.35	112.25	112.35	3100.0
2010-03-04 05:30:00	SPY	ETF	112.3	112.3	112.3	112.3	700.0
2010-03-04 06:00:00	SPY	ETF	112.21	112.21	112.17	112.17	700.0
2010-03-04 06:30:00	SPY	ETF	112.22	112.41	112.22	112.31	34400.0
2010-03-04 07:00:00	SPY	ETF	112.29	112.35	112.19	112.27	704990.0
2010-03-04 07:30:00	SPY	ETF	112.31	112.42	112.29	112.42	652420.0
2010-03-04 08:00:00	SPY	ETF	112.39	112.43	111.9	112.32	1577579.0
2010-03-04 08:30:00	SPY	ETF	112.32	112.63	112.27	112.55	3774862.0
2010-03-04 09:00:00	SPY	ETF	112.55	112.56	112.4	112.44	960766.0
2010-03-04 09:30:00	SPY	ETF	112.45	112.75	112.4	112.66	14160216.0
2010-03-04 10:00:00	SPY	ETF	112.67	112.75	112.36	112.5	13786759.0
2010-03-04 10:30:00	SPY	ETF	112.49	112.5	112.03	112.2275	18795686.0
2010-03-04 11:00:00	SPY	ETF	112.23	112.47	112.19	112.39	10127086.0
2010-03-04 11:30:00	SPY	ETF	112.4	112.45	112.25	112.39	6647215.0
2010-03-04 12:00:00	SPY	ETF	112.39	112.43	112.26	112.375	4638250.0
2010-03-04 12:30:00	SPY	ETF	112.38	112.44	112.27	112.4	4288416.0
2010-03-04 13:00:00	SPY	ETF	112.4	112.55	112.36	112.4099	4683517.0
2010-03-04 13:30:00	SPY	ETF	112.4	112.41	112.19	112.36	6330707.0
2010-03-04 14:00:00	SPY	ETF	112.35	112.44	112.29	112.41	4127938.0
2010-03-04 14:30:00	SPY	ETF	112.4	112.54	112.34	112.51	6471014.0
2010-03-04 15:00:00	SPY	ETF	112.5	112.55	112.38	112.54	6473895.0
2010-03-04 15:30:00	SPY	ETF	112.54	112.8	112.51	112.65	19558163.0
2010-03-04 16:00:00	SPY	ETF	112.64	112.79	112.28	112.7	5792194.0
2010-03-04 16:30:00	SPY	ETF	112.69	112.71	112.65	112.71	1736475.0
2010-03-04 17:00:00	SPY	ETF	112.7	112.74	112.66	112.74	71149.0
2010-03-04 17:30:00	SPY	ETF	112.7	112.74	112.69	112.74	13232.0
2010-03-04 18:00:00	SPY	ETF	112.73	112.74	112.66	112.7	29048.0
2010-03-04 18:30:00	SPY	ETF	112.71	112.75	112.69	112.75	21780.0
2010-03-04 19:00:00	SPY	ETF	112.77	112.85	112.76	112.83	42660.0
2010-03-04 19:30:00	SPY	ETF	112.83	112.89	112.8	112.8	149911.0
2010-03-04 05:30:00	QQQ	ETF	45.59	45.59	45.59	45.59	204.0
2010-03-04 06:30:00	QQQ	ETF	45.6	45.6	45.6	45.6	400.0
2010-03-04 07:00:00	QQQ	ETF	45.58	45.58	45.52	45.52	843239.0
2010-03-04 07:30:00	QQQ	ETF	45.54	45.6	45.54	45.6	521216.0
2010-03-04 08:00:00	QQQ	ETF	45.4	45.95	45.4	45.54	1333848.0
2010-03-04 08:30:00	QQQ	ETF	45.54	45.73	45.53	45.68	620045.0
2010-03-04 09:00:00	QQQ	ETF	45.68	45.7	45.64	45.65	588216.0
2010-03-04 09:30:00	QQQ	ETF	45.64	45.76	45.54	45.72	6899041.0
2010-03-04 10:00:00	QQQ	ETF	45.73	45.73	45.49	45.59	6463447.0
2010-03-04 10:30:00	QQQ	ETF	45.6	45.6	45.4	45.5485	7390863.0
2010-03-04 11:00:00	QQQ	ETF	45.54	45.63	45.53	45.61	3168704.0
2010-03-04 11:30:00	QQQ	ETF	45.61	45.65	45.53	45.6199	2848770.0
2010-03-04 12:00:00	QQQ	ETF	45.62	45.6201	45.55	45.58	2246676.0
2010-03-04 12:30:00	QQQ	ETF	45.59	45.62	45.54	45.58	1238406.0
2010-03-04 13:00:00	QQQ	ETF	45.59	45.65	45.58	45.5975	1460764.0
2010-03-04 13:30:00	QQQ	ETF	45.59	45.62	45.525	45.6	2064164.0
2010-03-04 14:00:00	QQQ	ETF	45.6	45.67	45.58	45.65	1732764.0
2010-03-04 14:30:00	QQQ	ETF	45.65	45.7	45.63	45.68	2075192.0

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

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