PREVIEW / etf_30min / 2009-03-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-13.parquet
  size:    208 KB
  rows:    6,924

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-13 04:00:00	SPY	ETF	76.03	76.31	75.99	76.31	35856.0
2009-03-13 04:30:00	SPY	ETF	76.21	76.21	76.11	76.21	1043.0
2009-03-13 05:00:00	SPY	ETF	76.22	76.23	76.22	76.23	400.0
2009-03-13 05:30:00	SPY	ETF	76.08	76.08	76.0	76.05	67730.0
2009-03-13 06:00:00	SPY	ETF	76.05	76.16	76.02	76.12	22050.0
2009-03-13 06:30:00	SPY	ETF	76.07	76.34	76.07	76.34	24393.0
2009-03-13 07:00:00	SPY	ETF	76.42	76.59	76.26	76.28	307243.0
2009-03-13 07:30:00	SPY	ETF	76.27	76.42	76.18	76.3	604278.0
2009-03-13 08:00:00	SPY	ETF	76.3	76.44	75.4698	76.4	1363782.0
2009-03-13 08:30:00	SPY	ETF	76.42	76.51	75.53	75.96	3572948.0
2009-03-13 09:00:00	SPY	ETF	75.96	76.3427	75.6	75.99	2265964.0
2009-03-13 09:30:00	SPY	ETF	76.01	76.08	75.41	76.0	44357828.0
2009-03-13 10:00:00	SPY	ETF	76.01	76.39	75.64	75.66	35285947.0
2009-03-13 10:30:00	SPY	ETF	75.66	76.24	75.46	75.61	29294954.0
2009-03-13 11:00:00	SPY	ETF	75.57	75.82	75.1624	75.47	24158119.0
2009-03-13 11:30:00	SPY	ETF	75.47	75.48	74.89	75.11	22072617.0
2009-03-13 12:00:00	SPY	ETF	75.1	75.28	74.73	74.93	18611001.0
2009-03-13 12:30:00	SPY	ETF	74.94	75.46	74.92	75.4	17628623.0
2009-03-13 13:00:00	SPY	ETF	75.4	75.84	75.3	75.78	13263646.0
2009-03-13 13:30:00	SPY	ETF	75.77	75.82	75.47	75.72	13535034.0
2009-03-13 14:00:00	SPY	ETF	75.72	76.0	75.5	75.68	21041513.0
2009-03-13 14:30:00	SPY	ETF	75.68	76.19	75.6	75.8	22367946.0
2009-03-13 15:00:00	SPY	ETF	75.79	76.33	75.75	76.21	16527635.0
2009-03-13 15:30:00	SPY	ETF	76.22	76.98	75.87	76.1	31769731.0
2009-03-13 16:00:00	SPY	ETF	76.13	76.34	74.85	76.3	13195653.0
2009-03-13 16:30:00	SPY	ETF	76.3	76.49	76.29	76.34	671989.0
2009-03-13 17:00:00	SPY	ETF	76.34	76.42	76.25	76.26	267331.0
2009-03-13 17:30:00	SPY	ETF	76.27	76.3	76.25	76.25	72885.0
2009-03-13 18:00:00	SPY	ETF	76.25	76.25	76.23	76.25	95486.0
2009-03-13 18:30:00	SPY	ETF	76.24	76.25	76.22	76.25	119409.0
2009-03-13 19:00:00	SPY	ETF	76.25	76.25	76.22	76.25	345777.0
2009-03-13 19:30:00	SPY	ETF	76.25	76.4	76.25	76.31	102561.0
2009-03-13 20:00:00	SPY	ETF	76.39	76.39	76.39	76.39	350.0
2009-03-13 04:30:00	QQQ	ETF	28.86	28.86	28.86	28.86	420.0
2009-03-13 05:00:00	QQQ	ETF	28.83	28.83	28.83	28.83	100.0
2009-03-13 05:30:00	QQQ	ETF	28.83	28.83	28.79	28.79	300.0
2009-03-13 06:00:00	QQQ	ETF	28.79	28.8	28.79	28.8	300.0
2009-03-13 06:30:00	QQQ	ETF	28.82	28.83	28.82	28.83	200.0
2009-03-13 07:00:00	QQQ	ETF	28.91	28.98	28.86	28.86	65308.0
2009-03-13 07:30:00	QQQ	ETF	28.86	28.89	28.82	28.85	98160.0
2009-03-13 08:00:00	QQQ	ETF	28.85	28.89	28.8	28.83	386727.0
2009-03-13 08:30:00	QQQ	ETF	28.83	28.84	28.57	28.58	1558219.0
2009-03-13 09:00:00	QQQ	ETF	28.59	28.68	28.57	28.67	843132.0
2009-03-13 09:30:00	QQQ	ETF	28.67	28.76	28.45	28.731	22284606.0
2009-03-13 10:00:00	QQQ	ETF	28.73	28.84	28.54	28.57	15809970.0
2009-03-13 10:30:00	QQQ	ETF	28.5699	28.79	28.51	28.56	15607946.0
2009-03-13 11:00:00	QQQ	ETF	28.56	28.64	28.42	28.52	10617179.0
2009-03-13 11:30:00	QQQ	ETF	28.52	28.5201	28.34	28.4	7887185.0
2009-03-13 12:00:00	QQQ	ETF	28.4	28.46	28.32	28.41	6069010.0
2009-03-13 12:30:00	QQQ	ETF	28.4	28.52	28.37	28.5	8056092.0

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

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