PREVIEW / etf_30min / 2009-03-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-17.parquet
  size:    207 KB
  rows:    6,869

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-17 04:00:00	SPY	ETF	76.13	76.2	76.13	76.18	600.0
2009-03-17 04:30:00	SPY	ETF	76.33	76.45	76.33	76.45	500.0
2009-03-17 05:00:00	SPY	ETF	76.4	76.4	76.28	76.28	200.0
2009-03-17 05:30:00	SPY	ETF	76.45	76.48	76.4	76.45	10000.0
2009-03-17 06:00:00	SPY	ETF	76.38	76.66	76.38	76.56	52700.0
2009-03-17 06:30:00	SPY	ETF	76.56	76.71	76.4	76.42	35200.0
2009-03-17 07:00:00	SPY	ETF	76.45	76.45	76.16	76.25	179544.0
2009-03-17 07:30:00	SPY	ETF	76.23	76.33	76.07	76.12	520862.0
2009-03-17 08:00:00	SPY	ETF	76.12	76.81	75.8	75.97	2955568.0
2009-03-17 08:30:00	SPY	ETF	75.97	76.51	75.97	76.34	2422743.0
2009-03-17 09:00:00	SPY	ETF	76.34	76.36	75.9	76.05	2016612.0
2009-03-17 09:30:00	SPY	ETF	76.07	76.24	75.45	75.89	31519760.0
2009-03-17 10:00:00	SPY	ETF	75.88	76.4	75.88	75.95	31556041.0
2009-03-17 10:30:00	SPY	ETF	75.95	76.67	75.84	76.49	26735093.0
2009-03-17 11:00:00	SPY	ETF	76.48	76.49	75.85	76.16	16289378.0
2009-03-17 11:30:00	SPY	ETF	76.2	76.48	75.98	76.44	11504938.0
2009-03-17 12:00:00	SPY	ETF	76.44	76.81	76.31	76.73	15364518.0
2009-03-17 12:30:00	SPY	ETF	76.73	77.3	76.61	77.09	20946434.0
2009-03-17 13:00:00	SPY	ETF	77.09	77.41	76.97	77.2	15343955.0
2009-03-17 13:30:00	SPY	ETF	77.21	77.52	76.91	76.9694	20119129.0
2009-03-17 14:00:00	SPY	ETF	76.97	77.14	76.72	76.74	21471123.0
2009-03-17 14:30:00	SPY	ETF	76.74	77.45	75.8995	77.22	22477531.0
2009-03-17 15:00:00	SPY	ETF	77.22	77.83	77.12	77.5	29964822.0
2009-03-17 15:30:00	SPY	ETF	77.5	78.3	77.27	78.26	48099943.0
2009-03-17 16:00:00	SPY	ETF	78.2	78.53	75.8995	78.41	12073801.0
2009-03-17 16:30:00	SPY	ETF	78.41	78.47	77.4	78.41	2620557.0
2009-03-17 17:00:00	SPY	ETF	78.43	78.5	78.42	78.43	163317.0
2009-03-17 17:30:00	SPY	ETF	78.44	78.46	78.4	78.43	31824.0
2009-03-17 18:00:00	SPY	ETF	78.45	78.45	78.39	78.4	59726.0
2009-03-17 18:30:00	SPY	ETF	78.4	78.4	78.33	78.33	48793.0
2009-03-17 19:00:00	SPY	ETF	78.33	78.33	78.22	78.23	63270.0
2009-03-17 19:30:00	SPY	ETF	78.22	78.34	78.22	78.23	88550.0
2009-03-17 04:30:00	QQQ	ETF	28.47	28.48	28.47	28.48	400.0
2009-03-17 06:00:00	QQQ	ETF	28.48	28.59	28.48	28.59	1375.0
2009-03-17 06:30:00	QQQ	ETF	28.6	28.61	28.55	28.55	3626.0
2009-03-17 07:00:00	QQQ	ETF	28.47	28.47	28.37	28.41	14024.0
2009-03-17 07:30:00	QQQ	ETF	28.4	28.44	28.35	28.36	198558.0
2009-03-17 08:00:00	QQQ	ETF	28.36	28.4	28.27	28.33	261364.0
2009-03-17 08:30:00	QQQ	ETF	28.37	28.52	28.37	28.46	475535.0
2009-03-17 09:00:00	QQQ	ETF	28.46	28.47	28.33	28.41	897797.0
2009-03-17 09:30:00	QQQ	ETF	28.41	28.63	28.3	28.5099	19542734.0
2009-03-17 10:00:00	QQQ	ETF	28.51	28.65	28.46	28.48	11766078.0
2009-03-17 10:30:00	QQQ	ETF	28.49	28.7	28.45	28.6301	7446129.0
2009-03-17 11:00:00	QQQ	ETF	28.63	28.67	28.55	28.58	5561574.0
2009-03-17 11:30:00	QQQ	ETF	28.58	28.69	28.54	28.67	4358341.0
2009-03-17 12:00:00	QQQ	ETF	28.67	28.76	28.63	28.74	5422871.0
2009-03-17 12:30:00	QQQ	ETF	28.7499	28.88	28.68	28.81	8355171.0
2009-03-17 13:00:00	QQQ	ETF	28.8	28.94	28.77	28.83	7167742.0
2009-03-17 13:30:00	QQQ	ETF	28.84	28.97	28.77	28.7821	7859753.0
2009-03-17 14:00:00	QQQ	ETF	28.79	28.84	28.69	28.71	8976868.0

> showing 50 of 6,869 rows — these rows as CSV

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